• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 671
  • Last Modified:

Excel 2007 on Win7 can not connect to cube on sql server

I have problems with connecting to a OLAP cube from Excel 2007 when the the Operation system is Windows 7. I have no problems on Windows XP, and I believe its a authentication problem, since Windows 7 is using lerberos mandatory.

I have created an SPN with the command: Setspn.exe -S MSOLAPSvc.3/Royal-Canin.cn SalesTools

but it still do not work.

Any ideas to solve this issue?
0
Comitto
Asked:
Comitto
1 Solution
 
senadCommented:
did you check if firewall of some sort in perhaps blocking the connection ?
0
 
ComittoAuthor Commented:
No, that was not the problem.

I did however find the problem myself. OLAP server have to be "trusted" in the domain
0
 
gosi75Commented:
I have the same problem, how do you make the OLAP server trusted in the domain?
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now