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

  • As Mike pointed out, SSAS *only* supports Windows Auth, so yes, when using Excel, you'll be authenticated by your windows account (unless using http, in which case it's determined by your IIS settings, which will either pass your credentials or use the anon user or potentially even the app pool account - but again, these are all windows accounts). There is no concept of SQL Authentication.

    Steve.