|Q: How to setup SSAS anonymous authentication - to access data from internet or another domain?|
|Written by Vidas Matelis|
|Tuesday, 01 February 2011 23:54|
Q: How to setup SSAS anonymous authentication - to access data from internet or another domain?
A: Sometimes you might need to setup access to your Microsoft SQL Server Analysis Services using anonymous authentication. For example, you would like to allow access to your SSAS data from another active directory domain or from the internet and you DO NOT CARE ABOUT DATA SECURITY.
To setup SSAS anonymous authentication you need to complete 3 steps :
After such setup any user should be able to access your SSAS database without authentication.
If you are still exepriencing problems, here are few tips that might help you troubleshoot your setup:
EventClass: Audit Login
If you do not see such trace record, then your connection is not reaching this SSAS instance. Check if your firewall is configured properly to let through SSAS connection (read more about SSAS Ports here).
For SQL Server 2008R2 RTM there is a known bug that might prevent you from connecting to SSAS server using anonymous authentication.If this bug affects you, then after configuring everyting properly, when you try to connect to SSAS server you still will get error message:
Either the user, NT AUTHORITY\ANONYMOUS LOGON, does not have access to the AdventureWorks database, or the database does not exist.
There is no hotfix available for this bug at the time of writing this post, but Marius Dumitru from Microsoft SSAS team provided this workaround (apply this at your own risk):
Read more about Registry key EveryoneIncludesAnonymous here. If that does not work, then add user group "Everyone" to SSAS database role and grant that role necessary permissions.
- How to install Adventure Works SQL DW and Analysis Services 2005/2008 sample database and project
- MDX-How can I get Last (Previous) Year to Date (YTD) values?
- What TCP port SQL Server Analysis Services 2005 uses
- MDX-How do you calculate monthly average of one year, optionally including empty months?
- MDX-How do I calculate sales for 12 Month to date?