Thursday, February 7, 2013

EXCEL 2010: Cannot access Analysis Services of SQL 2000

Error "...Unable to locate database server..."
Solution:
Install pivot table service (PTSFULL) from service pack 4 of SQL 2000

Note:
only work with Excel 32-bit version
source: Ole db provider 64 bits for SSAS 2000


No comments:

Post a Comment