Solved

SSRS Reporting Services

Posted on 2011-02-21
12
1,025 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:codedigger
  • 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:codedigger
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
 

Author Comment

by:codedigger
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
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

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

Shouldn't all users have the same email signature?

You wouldn't let your users design their own business cards, would you? So, why do you let them design their own email signatures? Think of the damage they could be doing to your brand reputation! Choose the easy way to manage set up and add email signatures for all users.

Join & Write a Comment

Suggested Solutions

Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

743 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now