Connection string property to SSAS 2008

• Gangadhara MS

  Hall of Fame

  Points: 3377

  More actions

  July 13, 2011 at 8:33 pm

  #253590

  Dear All,

  Due to pooer performance we have migrated all the cubes from SSAS 2005 to SSAS 2008 64-bit enviroment.

  But the data source is SQL server 2005 databases itself.

  What should be the connection string for this i mean the provider ??

  Pls suggest .

• Koen Verbeeck

  SSC Guru

  Points: 259125

  More actions

  July 15, 2011 at 1:02 am

  #1353223

  The SQL Server Native Client 10.0 (the default if I'm not mistaken) should have no problems connecting to SQL 2005.

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