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

Great Plains Analysis Cubes Permissions

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?
0
thoecherl
Asked:
thoecherl
  • 2
1 Solution
 
Simone BCommented:
Do you have remote connections enabled in your surface area configuration?
0
 
thoecherlAuthor Commented:
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?
0
 
Simone BCommented:
Yup, that's the one. So that's not the problem. I'll try to think of something else.
0
 
CharlWiehahnCommented:
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)
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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