Dynamics GP SSRS Report Deployment Problems
Posted by Brandon Richards, Implementation Manager on August 9, 2017
If you’re trying to deploy SQL Server Reporting Services Reports (SSRS) and it keeps failing, saying you don’t have permission, it might be because you have SQL Express.
Dynamics GP Error Message: You do not have security access to the location where you want the reports to be deployed
Report deployment with SSRS is NOT supported on SQL Express editions. It only works with SQL Server 2012, 2014, or 2016 Standard or Enterprise Editions.
Here’s what Microsoft CustomerSource has to say. Notice SQL Express is not listed.
If you have further questions, or would like information and pricing on SQL Server, contact us at Marketing@Crestwood.com