Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
INF: Connect to Analysis Services By Using "SSPI = Anonymous" on Windows XP
Article ID: 324040 - View products that this article applies to.
This article was previously published under Q324040
This article describes how to enable an Anonymous Logon group (NT AUTHORITY\ANONYMOUS) to access Microsoft SQL Server 2000 Analysis Services when it is installed on a computer that is running Windows XP.
In Windows XP local security policy, the Anonymous Logon group is no longer a member of the Everyone group. Although the Everyone group has permissions to access the Analysis Services OLAP database, the anonymous users cannot connect to Analysis Services when it is installed on a computer that is running Windows XP.
Although the Everyone group has permissions to connect to Analysis Services when it is installed on a computer that is running Windows XP, the client application cannot obtain metadata or query Analysis Services cubes when the SSPI=anonymous parameter is used in the connection string.
To enable an anonymous user to access Analysis Services, use either of the following methods.
Method 1Explicitly add the NT AUTHORITY\ANONYMOUS LOGON account to an OLAP database role. To do so, follow these steps:
Method 2Enable the "Network Access: Let Everyone permissions apply to anonymous users" local security policy. To do so, follow these steps: