Posted: 4/11/2012
I am trying to connect to a SSAS 2008 R2 cube via Excel 2010 I built on server A that I only have access through a VPN.
When I enter the informaion required to connect to the database server, I get the following error. I am using a windows username and password on server A since it is not on our domain.
I have ensured that I have SQLBrowser service running. I can conncet just fine to a SSAS Instance on my network just fine.
Anyone else run into this issue?
Posted: 4/12/2012
This problem happened me when I was not in the domain.
Are you connected to VPN and then connected to cube?
Yeah the server/cube I am trying to connect to is not in our domain. I only have access to the server/cube via a VPN tunnel.
Posted: 5/3/2012
This link may help. Sorry, not an expert on Kerberos or Network security.
http://social.msdn.microsoft.com/Forums/eu/sqlanalysisservices/thread/4efa0d68-9690-4f82-a933-722d97bab81c