Great Plains Analysis Cubes Permissions

Posted on 2011-10-13
Last Modified: 2012-05-12
Try to create pivot table reports and get error message:

"Cannot connect to DynamicsGPWarehouse on server xx"

However, in Management Studio, I can successfully execute a query against the DynamicsGPWarehouse  database.  Appears to be some kind of permissions problem, but I am using the sa user.  Any ideas?
Question by:thoecherl
    LVL 11

    Expert Comment

    by:Simone B
    Do you have remote connections enabled in your surface area configuration?

    Author Comment

    We are using SQL Server 2008.  In the SQL Server properties, under Connections, the "Allow remote connections to this server" box is checked.  Is that what you mean?
    LVL 11

    Expert Comment

    by:Simone B
    Yup, that's the one. So that's not the problem. I'll try to think of something else.
    LVL 4

    Accepted Solution

    Are you launching Management Studio on the server when trying to execute this code? Are you able to connect to other databases on the same server?

    The reason I ask is that it sounds like TCP/IP has not been enabled under the SQL server Config Manager. (Protocols for MSSQLSERVER)

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    755 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

    18 Experts available now in Live!

    Get 1:1 Help Now