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
2009-03-09 12:56:22
+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
2009-04-07 21:52:41
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
2009-10-02 03:23:20