SSPI Property

SSPI Property

SQL Server 2000

SSPI Property

This property determines the security package that will be used during the session.

Property Name


Property ID



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

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"
© 2016 Microsoft