munting_monty
asked on
"Unspecified Error" While Connecting to Analysis Server Using Excel from outside of a Windows Domain
I'm getting an "Unspecified Error" when I try authenticate to our Analysis Server using Microsoft Excel Pivot Table Services. It works fine when I am authenitcated within the domain (when I'm at work) but when I am working from home (external of the domain) I cannot connect. I've tried mutliple versions of microsoft excel, as well as making sure MDAC and Pivot Table Services (8,0) are installed correctly.
From what I understand, the only authentication broker available in Analysis service is Active Directory. We tried using domain prefix's on the login (i.e domain\user domain/user and the @ symbol) but no luck so far.
suggestions welcome and thanks in advance.
From what I understand, the only authentication broker available in Analysis service is Active Directory. We tried using domain prefix's on the login (i.e domain\user domain/user and the @ symbol) but no luck so far.
suggestions welcome and thanks in advance.
ASKER
Thanks for your prompt reply danblake!
Linked server sounds like a good idea, but we only have 1 production server.
We've just tried using local accounts that are not members of the domain, also tried to play with domain accounts being administrator of the sql server, with no luck so far.
Querying the database directly is not an option in our scenario (client must use Excel to connect)
Linked server sounds like a good idea, but we only have 1 production server.
We've just tried using local accounts that are not members of the domain, also tried to play with domain accounts being administrator of the sql server, with no luck so far.
Querying the database directly is not an option in our scenario (client must use Excel to connect)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The other route that you may be able to take, (long-winded -- very) is to provide a linked server in SQL-Server and connect to SQL-Server via a Sql-server login and pull the data back from the linked server but this will cause problems with the Excel Pivot Table Services....
Alternativly if the Analysis Services information is stored as ROLAP datasource -- query the SQL-Server database directly where the information is stored with a sql-server login.