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

Posted on 2010-01-07
Last Modified: 2012-05-08
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/ SalesTools

but it still do not work.

Any ideas to solve this issue?
Question by:Comitto
    LVL 22

    Expert Comment

    did you check if firewall of some sort in perhaps blocking the connection ?

    Accepted Solution

    No, that was not the problem.

    I did however find the problem myself. OLAP server have to be "trusted" in the domain

    Expert Comment

    I have the same problem, how do you make the OLAP server trusted in the domain?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Trying to figure out group policy inheritance and which settings apply where can be a chore.  Here's a very simple summary I've written which might help.  Keep in mind, this is just a high-level conceptual overview where I try to avoid getting bogge…
    Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
    This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.
    The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now