Disabling Basic or Digest Authentication 

 

By default, Microsoft SQL Server 2005 Analysis Services (SSAS) rejects authentication requests from clients that use Basic or Digest authentication to submit those requests. This default setting prevents clients from using Basic or Digest authentication to connect over the Internet. Enabling Analysis Services to accept these requests will reduce the security of the Analysis Services data.

Modifying Basic or Digest Authentication

To modify whether Analysis Services rejects client requests that use Basic or Digest authentication, change the following server configuration properties:

  • Security \ HTTP \ DisableBasicAuthentication
    Based on the default setting of 1, Analysis Services rejects client requests that are submitted by using Basic authentication. To accept client requests that use Basic authentication, change the setting for this property to 0.
  • Security \ HTTP \ DisableDigestAuthentication
    Based on the default setting of 1, Analysis Services rejects client requests that are submitted by using Digest authentication. To accept client requests that use Digest Authentication, change the setting for this property to 0.

If you enable either Basic or Digest authentication by using one of the previous properties, you can use the Security \ HTTP \ MinKeySize property to specify a minimum key size, in bits, for Secure Socket Layer (SSL) authentication. The default size is 56 bits.

To access these server configuration properties, right-click the instance of Analysis Services, click Properties, and then locate these properties on the Security page

See Also

Concepts

Requiring Data Encryption
Requiring Client Authentication
Requiring Specific Security Packages
Specifying the Role Cache Refresh Frequency

Help and Information

Getting SQL Server 2005 Assistance