Microsoft KB Archive/938701

= A new client computer cannot connect to a Microsoft Solution Accelerator for Business Desktop Deployment 2007 deployment database that uses the &quot;TCP\IP sockets&quot; option in the network library =

Article ID: 938701

Article Last Modified on 8/29/2007

-

APPLIES TO


 * Microsoft Solution Accelerator for Business Desktop Deployment

-



SYMPTOMS
A new client computer cannot connect to the Microsoft Solution Accelerator for Business Desktop Deployment 2007 deployment database. The following information is recorded in the ZTIGather.log file:

Connecting to SQL Server using connect string: Provider=SQLOLEDB;OLE DB Services=0;Data Source=10.54.253.162;Initial Catalog=BDDAdminDB;Network Library=DBMSSOCN;Integrated Security=SSPI ZTIGather  22/02/2007 16:41:52 0 (0x0000) ZTI error opening SQL Connection: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (-2147217843)  ZTIGather   22/02/2007 16:41:52 0 (0x0000) Unable to establish database connection using [XXXX] properties. ZTIGather  22/02/2007 16:41:52 0 (0x0000)



CAUSE
This issue may occur if the following conditions are true:
 * The deployment database uses the TCP\IP sockets option in the network library.
 * You do not specify the DBID value and the DBPwd value in the Customsettings.ini file.
 * The client computer is running Windows Preinstallation Environment (Windows PE).

In Windows PE, users run in the local system account. This account has no domain membership. Network connections are made in the Anonymous Logon user account. Therefore, the database connection fails.



WORKAROUND
To work around this issue, use one of the following methods.

Method 1: Use named pipes for the network library
If you are using Windows Authentication, follow these steps to use named pipes for the network library:
 * 1) Open the Deployment Workbench MC snap-in.
 * 2) Expand Deploy, and then right-click Database.
 * 3) Click New.
 * 4) On the Specify the SQL Server details page, type the SQL Server name in the SQL Server name box. Then, click Named Pipes in the Network library box.
 * 5) Expand Deployment Points, right-click each deployment point, and then click Update.

Method 2: Use SQL Authentication for the TCP/IP sockets network library
To use SQL Authentication for the TCP/IP sockets network library, specify the DBID value and the DBPwd value in the Customsettings.ini file. For information about how to modify the Customsettings.ini file, see the &quot;SQLshare&quot; topic in the configuration reference document. The configuration reference document is typically located in the following folder:

C:\Program Files\BDD 2007\Documentation

Keywords: kbprb kbtshoot kbexpertiseadvanced KB938701

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.