Solved

SSRS Reporting Services

Posted on 2011-02-21
12
1,034 Views
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
0
Comment
Question by:Roberto Madro R.
[X]
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
12 Comments
 
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.
0
 

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
0
 
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"
http://support.microsoft.com/kb/2467239
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 

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.

Thanks

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
0
 
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
0
 

Author Comment

by:Roberto Madro R.
ID: 34981506
rbarnhardt;

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.

Thanks
0
 
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.
0
 
LVL 32

Assisted Solution

by:Rodney Barnhardt
Rodney Barnhardt earned 500 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.
0
 

Accepted Solution

by:
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
0
 

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.
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Know what services you can and cannot, should and should not combine on your server.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

733 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