Requiring Client Authentication

By default, Microsoft SQL Server Analysis Services requires clients to be authenticated by the Microsoft Windows operating system in order to establish a connection with the service. By default, Microsoft SQL Server Analysis Services will reject all requests from unauthenticated clients.

Modifying Client Authentication

To modify the client authentication requirement, the administrator must change the value of the Security \ RequireClientAuthentication server configuration property.

To access this property using SQL Server Management Studio, right-click the instance of Analysis Services, click Properties, and then locate the property on the Security page. The following table describes the possible values for this property.

  • 1
    Clients are required to be authenticated by the Microsoft Windows operating system.

    This is the default value for this property.

  • 0
    Authentication is not required to connect to Microsoft SQL Server Analysis Services.

Note

Changing the default value of this property might reduce the security of your data.