I am trying to access SSAS 2005 through excel on a client computer.
I get the following error message: The data connection wizard cannot obtain a list of databases from the specified source.
It looks like I connect, but I cannot list any of the catalogs.
Both catalogs are migrated from a sql2000 database.
I ensured that the account has a browsable role through the roles in SSAS.
Interestingly if I create a UDL file with a connection to ssas and choose existing connections and specifiy the udl file I can access the specific ssas catalog.
In creating the udl file I cannot see the catalogs, but I can type in the catalog name which connects me and allows me to browse the cube using excel.
Unfortunatley, my users use other applications besides excel which don't allow access through udls.
Any help would be appreciated.
View Complete Post