OLAP server Connections | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

OLAP server Connections

Hi all,
Is it true that connections to the OLAP server can only be made using a Windows Account?
Is there a way to setup those connections to the OLAP using a Standard Account?
Thanks in advance
Yukon DBA


Yes, It’s true that one can connect to Microsoft OLAP server only using Windows authentication and the user should be in administrator or SQL olap group

I agree you won’t be able to ‘log on’ to the OLAP service using a SQL Server login, only with a Windows account. But wouldn’t the connection be made under the account under which the SQL service itself is running?

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |