Microsoft KB Archive/900351

= An &quot;Error - Opening SQL Connection (Error Number = -2147217843)&quot; error message may be logged in the ZeroTouchInstallation.log file when you use the ZTI script to connect to a SQL Server database in Solution Accelerator for Business Desktop Deployment =

Article ID: 900351

Article Last Modified on 6/29/2005

-

APPLIES TO


 * Microsoft Solution Accelerator for Business Desktop Deployment

-





SYMPTOMS
Consider the following scenario. You use the CustomSettings.ini file to configure the ZeroTouchInstallation.vbs (ZTI) script in Microsoft Solution Accelerator for Business Desktop Deployment (BDD). Then, you use the ZTI script to connect to a Microsoft SQL Server database. You do this to obtain workstation configuration settings. In this scenario, the following error messages may be logged in the ZeroTouchInstallation.log file:

Warning - DBID key not defined in the section [DB_NYC]

Warning - DBPwd key not defined in the section [DB_NYC]

Warning - SQLShare key not defined in the section [DB_NYC]

WARNING - SQLShare NOT defined in the section [DB_NYC], trusted connection may not be possible.

OPENING STANDARD SECURITY SQL CONNECTION to server NYCSRV01, database BDDAdminDB, and SQL ID smsadmin.

ERROR - Opening SQL Connection (Error Number = -2147217843) (Error Description: Login failed for user 'smsadmin'.).

Note You provide the required parameters to connect to the SQL Server database in the CustomSettings.ini configuration file.



CAUSE
This problem occurs because the ZTI script cannot connect to SQL Server. The ZTI script tries to establish a named pipe connection to SQL Server by using the SQLServer parameter and the SQLShare parameter that are specified in a CustomSetting.ini file that is similar to the following. [DBAccess1] SQLServer=SERVER1 Database=BDDAdminDB Table=BDDAdminCore Parameters=MacAddress SQLShare=Logs The ZTI script forms a Universal Naming Convention (UNC) path by combining the value of the SQLServer parameter and the value of the SQLShare parameter. In this example, the ZTI script forms the path \\SERVER1\Logs. Then, the ZTI script tries to connect to this path. This problem occurs when the ZTI script that uses the Microsoft Systems Management Server advanced client network access account or the Systems Management Server earlier client software installation account cannot connect to SQL Server by using this path.



RESOLUTION
To resolve this problem, add the SQLShare parameter to the database configuration information in the CustomSettings.ini file.



MORE INFORMATION
In some sites, the SQL Server database may reside on a server to which the client has already established a named pipe connection. For example, the SQL Server database may reside on the server that is your distribution point. In this case, the connection may succeed even though the SQLShare parameter is not included in the CustomSettings.ini file. You still receive a warning that the SQLShare parameter is not defined, but the ZeroTouchInstallation.log file indicates that the connection succeeds. Error messages that are similar to the following may be logged in the ZeroTouchInstallation.log file:

Warning - DBID key not defined in the section [DB_NYC]

Warning - DBPwd key not defined in the section [DB_NYC]

Warning - SQLShare key not defined in the section [DB_NYC]

WARNING - SQLShare NOT defined in the section [DB_NYC], trusted connection may not be possible.

Already connected to server NYCSRV01 as it is the current distribution point.

OPENING TRUSTED SQL CONNECTION to server NYCSRV01 and database BDDAdminDB. Successfully opened connection to database

Keywords: kbtshoot kbprb KB900351

-

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

© Microsoft Corporation. All rights reserved.