Analysis Services Only Windows Authentication

sql-server sql-server-2005 ssis ssas analysis
AJM picture AJM · Mar 9, 2009 · Viewed 13.9k times · Source

Is it true that Analysis Services ONLY supports windows authentication?

Answer

Nick Kavadias picture Nick Kavadias · Mar 9, 2009

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

Related questions

SSIS Connection Manager Not Storing SQL Password

I used to have a dts that had a sql server authentication connection. Basically, the userid password is stored in the package itself. Now, when I go to SSIS, the password is not getting stored to the package. I saw …

Read More
How do you call a Stored Procedure in SSIS?

I am trying to create an SSIS package that queries data from a table, and calls a stored procedure in another database with each row. In my old DTS package, I was doing this: EXEC myStoredProcedure ?, ?, ? ...and then I mapped …

Read More
SSIS: Just started getting a "Key not valid for use in specified state." error on my scheduled SSIS package

I have 2 scheduled jobs on my SQL Server 2005 machine that are scheduled to run each morning (around 2:00 AM). These jobs have worked fine (mostly) for years and although I've had a few hiccups that I've had to work through this …

Read More