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