Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Issue Installing GP SQ...

Issue Installing GP SQL Reports 2013 with SQL Server 2008 r2 sp Express

(0) Share

Report

Posted on by Community Member Microsoft Employee

I am settting up demo environment on an Amazon Cloud server. I am using SQl SErver 2008 r2 sp2 express and I get an error when try to deploy the GP SQL Reports from the tools>System?Reporting Services. "You do not have security access to the location where you want the reports deployed". The weird thing is that I can put a bad location in the path for the report server and report manager and it doesn't give me any error like it use to check it when I tab off those fields. When I click deploy a window pops up asking for the domain use to publish them with. Whether I put in a good user or bad one I get the same error. Any thoughts. Microsoft support says, SQL Express causes the problem. That doesn't make sense to me though. I was wondering if any others have thoughts about this error or whether I can deploy them. THanks.

*This post is locked for comments

All responses (3)

Answers (0)

soma 24,406 on at

Like (0)

Report

RE: Issue Installing GP SQL Reports 2013 with SQL Server 2008 r2 sp Express

Doncomon, Any updates?
Jonathan Fear on at

Like (0)

Report

RE: Issue Installing GP SQL Reports 2013 with SQL Server 2008 r2 sp Express

Microsoft Support and Soma are both 100% correct SQL Express does not work. Have you tried a full install of SQL?
Suggested answer

soma 24,406 on at

Like (0)

Report

RE: Issue Installing GP SQL Reports 2013 with SQL Server 2008 r2 sp Express

The reports deployment to reporting services in GP is not support on sql server express edition. You need to use sql standard or enterprise edition.

For your reference:

community.dynamics.com/.../71188.aspx

Hope this helps!!!