I am connecting to an Analysis Server through a VPN. I have access rights to the server and can ping the server successfully. However when I try and open an Excel pivot table linked to the Analysis Server I receive the following error:- Open Connection Failed. Unable to open connection. Unspecified Error.
Does any one know any solutions to fix this issue or has anyone else experienced it?