IntegratedSecurity database parameter
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.
Controls
-
OLE DB
Syntax
|
1 |
IntegratedSecurity='<span>value</span>' |
|
Parameter |
Description |
|---|---|
|
value |
A string specifying the name of the authentication |
Default
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:
1SQLCA.DbParameter="IntegratedSecurity='SSPI'"