An "Error - Opening SQL Connection (Error Number = -2147217843)" 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 De...


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