none
MDT 2010 - connection to SQL " SQL Server does not exist or access denied. (-2147467259)"

    Question

  • At the moment i have a single image that gets replicated accross to a child site and SQL replication has been set up to reflect this along with DFS , this works fine if im PXE booting to get an image at it applies the correct configurations according to the location i have assigned.

    The issue i'm having is that this seems not to work when im kicking off a USMT 3 from within the user enviroment from windows XP , i have checked the logs and it cant seem to talk the local SQL server so it defaults and talks back to the parient sever which is in accross another country , bear in mind i'm loging into the xp box under a domain admin account and the issue still occurs.

    Which account does it use to connect to the SQL server?

    why cant it find teh Network path to the SQL server when its on the same box as the WDS.

    Any help on this would be greatly appreciated.....cheers

    OPENING TRUSTED SQL CONNECTION to server %WDSServer%. ZTIGather 13/05/2011 10:15:31 AM 0 (0x0000)
    Connecting to SQL Server using connect string: Provider=SQLOLEDB;OLE DB Services=0;Data Source=%WDSServer%\ROC_SOE;Initial Catalog=SOE;Network Library=DBNMPNTW;Integrated Security=SSPI ZTIGather 13/05/2011 10:15:31 AM 0 (0x0000)

    ZTI error opening SQL Connection: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259) ZTIGather 13/05/2011 10:15:49 AM 0 (0x0000)
    Unable to establish database connection using [LOCATIONS] properties. ZTIGather 13/05/2011 10:15:49 AM 0 (0x0000)

    Friday, May 13, 2011 2:49 AM

All replies

  • Have you added the build account for the MDT to the SQL Server DB, so MDT can speak to the SQL DB.
    Friday, May 13, 2011 3:14 AM