FrontEnd and database connections

May 4, 2011 at 9:33 PM

Hello,

I tried to set up the MDT Web FrontEnd in a test environment based on Windows 2008R2 servers. My databases (MDT as well as primary site) are hosted on different servers. I faced two issues.

It fails to connect to MDT when I use the connection string for TCP/IP access that works fine on SQL Studio. As the DBs are on fixed ports it looks like something like : <server>\<instance>,<port>.I tried various ways wiithout success.

Are TCP/IP network connections for the databases supported ?

 

On the same subject, if we cannot use the application pool account but a specific one, can it be a domain account or does it have to be an SQL internal account to use the admin interface ?

The domain account I vainly tried to set from the interface is able to connect to a local database if it is defined to start the application pool (so "integrated"). Therefore it has the required permissions to access.

 

Thank you in advance for your help.

Regards,