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.