Securing Client Communication with an Analysis Services Instance

The communication stream between clients and an instance of Microsoft SQL Server Analysis Services must be secured. During the setup process, default security settings are configured that control this communications stream. These settings are specified in the msmdsrv.ini configuration file for the instance of Analysis Services, and are exposed as properties of the instance of Analysis Services in SQL Server Management Studio. (The msmdsrv.ini configuration file is located in the Bin folder.)

The default security settings try to guarantee that communication between clients and an instance of Analysis Services is as secure as possible. However, these default security settings may or may not be essential depending on the sensitivity of the data and the security of the networks across which the data is accessed.

The following topics discuss each of these default security settings and describe how to modify these settings, if appropriate:

• Requiring Data Encryption

• Requiring Client Authentication

• Requiring Specific Security Packages

• Specifying the Role Cache Refresh Frequency

See Also

Concepts

Securing the Analysis Services Instance