Analysis Services in Named Instance

• lucas_simon

  Valued Member

  Points: 60

  More actions

  July 11, 2013 at 4:32 am

  #280135

  I have set up a 2008R2 SQL cluster with several named instances and a default instance. The application using SQL Server requires analysis services, which I installed with his instance. The application has no problem connecting to the database but is unable to connect to analysis services. I set up a specific service ID for this purpose. What should we be doing to enable a connection?

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  July 11, 2013 at 5:48 am

  #1631530

  The login should have at least read permissions on the SSAS database.

  Did you already create cubes?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP