Analysis Services 2005 Authntication

Hi,

I have a small problem i.e. in SQL Server 2005 Management Studio i can connect to database engine as "Windows Authentication" as well as "Sql Server Authentication". But for connecting Analysis Services Database, Authentication is disabled and by default it is "Windows Authentication". To Enable the Authentication for logging as "SQL Server Authentication" what is the procedure to do.

Can you please help me in this.

Thanks

Dinesh

Hi,

As far as I was aware you can't enable it, based on the fact that the SQL Server logins are associated with a database engine not the Analysis Services engine.

http://technet.microsoft.com/en-us/library/ms144288.aspx

Near the end of that page

Specifying Analysis Services Authentication Mode

SQL Server 2005 Analysis Services supports only Windows Authentication.

Cheers

Matt

|||

Hello! SSAS2005 and earlier only supports windows authentication. Like Matt told you SQL Server authentication is a feature only in the database engine.

Regards

Thomas Ivarsson

|||How does this affect Reporting Services where Forms authentication is being used? We have changed our SSRS to use Forms Authentication although the report connects to an SSAS cube - I am now having problems connecting to this data source. Is it possible to have SSAS also use Forms Authentication?|||

I am not familiar with the Forms Authentication, but because Analysis Services only supports integrated authentication, would it be possible for you to impersonate the specified Windows user (with the Windows account name and password specified, I assume, in the forms) in the application that connects to SSAS ?