Specifies the user account used to connect to the computer running SQL Server (specified by the SQLServer property) using SQL Server authentication. The DBPwd property provides the password for the user account in the DBID property.

Note   SQL Server authentication is not as secure as Integrated Windows authentication. Integrated Windows authentication is the recommended authentication method. Using the DBID and DBPwd properties stores the credentials in clear text in the CustomSettings.ini file and therefore is not secure. For more information about using Integrated Windows authentication, see the SQLShare property.

Note   This property is configurable only by manually editing the CustomSettings.ini and BootStrap.ini files.

 

Property configured by

 

 

Property applies to

 

BootStrap.ini

˜

 

LTI

˜

CustomSettings.ini

˜

 

 

 

MDT DB

 

 

ZTI

˜

 

Value

Description

user_id

The name of the user account credentials used to access the computer running SQL Server using SQL Server authentication

 

Example

[Settings]

Priority=Computers, Default

 

[Default]

OSInstall=YES

 

[Computers]

SQLServer=NYC-SQL-01

DBID=SQL_User-01

DBPwd=<complex_password>

NetLib=DBNMPNTW

Database=MDTDB

Instance=SQLEnterprise2005

Table=Computers

Parameters=SerialNumber, AssetTag

ParameterCondition=OR

 

Related Topics

Property Definition