Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


SSRS Reporting Services

Posted on 2011-02-21
Medium Priority
Last Modified: 2012-08-13
I must have configured something wrong, From SQL Server 2008 R2 Reporting Services configuration Manager, I can launch the Configuration Mgr fine, but I can't access Report Mgr from Report Mgr URL and every time I do I get the following error;

User 'Domain\User' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

Your advice please
Question by:Roberto Madro R.
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
LVL 28

Expert Comment

by:Ryan McCauley
ID: 34972805
Did you set up the account using the "Service Account" tab in the SSRS Configuration Manager? I've changed the service account using that tool (on our Windows Server 2008 R2 boxes, which have UAC enabled), and haven't had any issues with it. If you change the service account manually, you can run into permissions issues, but the configuration tool should handle all the permissions that are needed.

Author Comment

by:Roberto Madro R.
ID: 34972920
On the "Service Account" in SSRS Configuration Mgr, I chose the "Network Service" in the "Use-built-in account" as an lternative to the "Domain\user" account I used earlier, I did that thinking I may be able to log in and then be able to control permissions and access better, but that turned out to be a dud.

And from the "Report Mgr URL", the URL I'm gettting is in the following format: http://ServerName:80/Reports

When I click on it, it takes me to the login page, I then try to use the domain/user credentials and still get the error I originally posted
LVL 32

Expert Comment

by:Rodney Barnhardt
ID: 34973094
We had a similar problem and opened a MS support case. Their solution was to install "Cumulative update package 2 for SQL Server 2008 Service Pack 2"
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.


Author Comment

by:Roberto Madro R.
ID: 34974521
These are the choices I'm presented with, I don't have SharePoint Integration at the moment, I was able to make out that much from the first one, not sure what to make of the remaining ones, any thoughts.


Select Product Language Platform Release File name Version Build File size (bytes) Modified date
 SQL Server 2008 All (Global) x86 sp2 2008_PCU2_RSShrPnt_CU2_2467239_10_00_4272_x86 2008 10.00.4272.00 12142054 1/13/2011 10:07:12 PM
SQL Server 2008 All (Global) x86 sp2 2008_PCU2_DMXLAddin_CU2_2467239_10_00_4272_x86 2008 10.00.4272.00 17491925 1/14/2011 1:32:52 AM

 SQL Server 2008 All (Global) x86 sp2 2008_PCU2_SNAC_CU2_2467239_10_00_4272_x86 2008 10.00.4272.00 3851149 1/13/2011 10:07:13 PM

 SQL Server 2008 All (Global) x86 sp2 SQLServer2008_PCU2_CU2_2467239_10_00_4272_x86
LVL 32

Expert Comment

by:Rodney Barnhardt
ID: 34976572
RSShrPnt = Reporting Service for Sharepoint
DMXLAddin = Data Mining
SNAC = Server Native Client
The last one should be the main one, so if you do not have any of the add-ins, then this is the one you want.

This may help explain it more: http://blogs.msdn.com/b/psssql/archive/2009/10/23/should-i-have-a-snac-with-my-cumulative-update.aspx

Author Comment

by:Roberto Madro R.
ID: 34981506

Thank for the detailed reply, after downloading the hot fix, I started to read the related article and found it bit troubling, throughout the article you're being warrned of the harm you could cause your system if you opt to install this hot fix, they said because it's still in beta and hasn't reached an RTM status yet, have you actually deployed this hot fix yourself and can you share your experience with me.

LVL 32

Expert Comment

by:Rodney Barnhardt
ID: 34981649
We have deployed it as recommended by Microsoft. A co-worker applied it after we worked with Premier Support and maintains that server. I will check with him and post a followup on any issues.
LVL 32

Assisted Solution

by:Rodney Barnhardt
Rodney Barnhardt earned 2000 total points
ID: 34983581
I checked with my co-worker and he said it corrected the problem and the server has ran fine. With that said, I do not know your environment or exactly how you are configured.

Accepted Solution

Roberto Madro R. earned 0 total points
ID: 35000246
Thank you rbarnhardt, I applied your solution but seem to not have gotten far for reasons other than the one I raised here, so we opted for a methodical / meticulous re-install, I'll close this case. Many Thanks

Author Closing Comment

by:Roberto Madro R.
ID: 35042638
Other mis-configured options along the way may have contributed to the problem, although your recommendation was right for that particular problem, other problems needed to be addressed as well.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

610 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