Specifies the name of the authentication service used by the data server to identify the user.
If this parameter is specified, none of the other OLE DB authentication parameters (CacheAuthentication, EncryptPassword, MaskPassword, PersistEncrypted, and PersistSecurityInfo) are needed and are ignored if specified.
When to specify IntegratedSecurity You must specify the IntegratedSecurity parameter before connecting to the database.
OLE DB
IntegratedSecurity='value'
Parameter |
Description |
---|---|
value |
A string specifying the name of the authentication service. If NULL, the default authentication service is used. |
None
To use an authentication service such as the Security Support Provider Interface (SSPI) for Windows NT:
Database profile Type the name of the authentication service in the Integrated Security box on the Security page in the Database Profile Setup dialog box.
Application Type the following in code:
SQLCA.DBParm="IntegratedSecurity='SSPI'"