views:

1067

answers:

2

Is it true that Analysis Services ONLY supports windows authentication?

+2  A: 

Yes, it does. Quote from MSDN

"SQL Server Analysis Services supports only Windows Authentication"

You'll need active directory, Refer to the following kb on how to set it up http://support.microsoft.com/kb/917409

Nick Kavadias
+3  A: 

Dependent on what you're trying to achieve, you can connect via HTTP and IIS, with IIS supplying or passing through credentials:

http://www.sqlserveranalysisservices.com/OLAPPapers/ConfiguringHTTPAccessToYukon.htm

Meff
This is a good reference for setting up HTTP access to analysis services.http://bloggingabout.net/blogs/mglaser/archive/2008/08/15/configuring-http-access-to-sql-server-2008-analysis-services-on-microsoft-windows-server-2008.aspx
knightpfhor