?
Solved

SSRS Reporting Services

Posted on 2011-02-21
12
Medium Priority
?
1,036 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
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 

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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
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
Suggested Courses

777 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