web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Deploy SSRS using SQL ...
Microsoft Dynamics GP (Archived)

Deploy SSRS using SQL Express 2012

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,848 Moderator

I am trying to deploy the GP SSRS reports for the first time on a stand alone server that is using SQL Express. No matter what user credentials I use I keep geting this message  "You do not have security access to the location where you want the reports to be deployed". This server is not a domain controller and I am logged as the Local Administrator. I have this user to SSRS as an admin. Is it complaining about the folder where the report needs to go or about SSRS itself. I ahve checked the permissions on the folder and admin has full control. What do I have to do to get these reports to deploy?

*This post is locked for comments

I have the same question (0)
  • Tim Foster Profile Picture
    Tim Foster 8,515 on at

    Richard,

    When you are running GP are you running it use "Run as Administrator" (Shift-Right click on the GP icon)?

    The credentials you are entering should be the admin account (domain account, in Local Admin group on SSRS server) that you used to install SSRS server or you will have to put the account that you want to use into the Administrator group on the SSRS server.

    Tim

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    I have discovered that GP 2010 SSRS deploy using SQL Express 2012 is not possible. So I removed SQL Express and installed SQL 2012 Stanadard and they deploy just fine.

  • Jonathan Fear Profile Picture
    Jonathan Fear on at

    You cannot use any version of SQL Express for SRS.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    Jonathan, I had overlooked that on the requirements page. We rarely use SQL Express for anything and this was the first one I tried. It would have been nice if the install program would simply have stated this.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans