Home Forums Data Warehousing Analysis Services Connecting to MSSQL 2005 SSAS cube using sql server authentication RE: Connecting to MSSQL 2005 SSAS cube using sql server authentication

  • Not really.

    The only authentication Analysis Services supports is windows. You can give the "Everyone" group access to a cube and windows ignores the security. Or, you could create a linked server from a SQL Server, use the service account for authentication, and grant SQL Users access to run queries on the linked server, but it is quite the hack.

    Analysis Services does support http access through a SOAP/XMLA layer - using this you can also use anonymous access through a single windows login in IIS. This gets a bit tricky to configure though.