SSPI Property

SSPI Property

SQL Server 2000

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
Show:
© 2016 Microsoft