Description
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.
Applies to
OLE DB
Syntax
IntegratedSecurity='value'
|
Parameter |
Description |
|---|---|
|
value |
A string specifying the name of the authentication service. If NULL, the default authentication service is used. |
Default value
None
Examples
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'"
