Analysis Services Programming
SSPI Property
This property determines the security package that will be used during the session.
Property Name
SSPI
Property ID
DBPROP_MSMD_SSPI
Remarks
The value of this property corresponds to the name of a security package. You can use the Security Support Provider Interface (SSPI) EnumerateSecurityPackages function to enumerate the providers that are supported on a given computer.
Microsoft™ SQL Server® 2000 Analysis Services supports the following packages:
- Negotiate
- Kerberos
- NTLM
- Anonymous User
Example
Suppose that the Kerberos security provider is the security package used for authentication in the domain on which a particular client application must run. The following code opens a connection using this provider and then displays a dialog box to complete the connection:
Dim cn as New ADODB.Connection
cn="Provider=MSOLAP; SSPI=Negotiate; Prompt=1"
cn.open