Restricting Network Access

Users and administrators must be authenticated by the Microsoft Windows operating system in order to access Microsoft SQL Server 2005 Analysis Services (SSAS) data or administer an instance of Analysis Services. The Windows operating system lets all authenticated users access a member server from the network. However, by default, members of the Everyone group are also permitted to access member servers. The Everyone group includes anonymous users.

To increase the security of the operating system and Analysis Services data, restrict the network access rights of anonymous users by doing the following:

  • Use the Local Security Policy tool to remove the right of the Everyone group to access the computer from the network. This tool is located in the Administrative Tools group on the computer.
  • Disable null sessions to prevent anonymous, or unauthenticated, sessions. To accomplish this, set the RestrictAnonymous key to 1. This key is in the Windows registry located at HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\LSA.

See Also


Specifying and Restricting Ports


Restricting Interactive Logon Access
Disabling Unneeded Services
Granting Local Administrative Rights

Help and Information

Getting SQL Server 2005 Assistance