Error: Connect to ssas 2008 R2 cube through excel 2010

Who is online?  0 guests and 0 members
Home  »  Forums   »  microsoft business intelligence   »  analysis services   » Error: Connect to ssas 2008 R2 cube through excel 2010

Error: Connect to ssas 2008 R2 cube through excel 2010

Topic RSS Feed

Posts under the topic: Error: Connect to ssas 2008 R2 cube through excel 2010

Posted: 4/11/2012

Jedi Youngling 4  points  Jedi Youngling
  • Joined on: 9/29/2011
  • Posts: 2

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

Jedi Knight 1516  points  Jedi Knight
  • Joined on: 1/3/2010
  • Posts: 266

This problem happened me when I was not in the domain.

Are you connected to VPN and then connected to cube?


Posted: 4/12/2012

Jedi Youngling 4  points  Jedi Youngling
  • Joined on: 9/29/2011
  • Posts: 2

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

Padawan 810  points  Padawan
  • Joined on: 6/7/2011
  • Posts: 46

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


Page 1 of 1 (4 items)