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

  • SSIS and SSAS are different products, their authentication does not have to work the same way.

    However, although you can use lots of different authentications in SSIS to connect to different data sources, connecting to an SSIS server is always using windows authentication. You may not have noticed, but when you connect through Management Studio to an SSIS Server, the authentication mode is set to windows and cannot be changed.