question

Rick 2 avatar image
Rick 2 asked

Analysis Server 2008 Connect via Password

I hope this is not a duplicate, as I did not see my question come out.

How do you connect to Analysis Server 2008 using SQL Server Authentication (password)? When creating a server registration with SQL Mgmt Studio, the authentication box is greyed out for authentication and is set to Windows Authentication.

Thanks Rick

sql-server-2008ssas
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
RickD avatar image
RickD answered

You can only connect via Windows Authentication in this way. This is in the documentation for Analysis Services.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Rajib Bahar avatar image
Rajib Bahar answered

Analysis services does allow you to define roles so that you can authorize proper level of privilege.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.