SSRS Reporting Services

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
Roberto Madro R.Programmer AnalystAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Roberto Madro R.Connect With a Mentor Programmer AnalystAuthor Commented:
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
 
Ryan McCauleyData and Analytics ManagerCommented:
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
 
Roberto Madro R.Programmer AnalystAuthor Commented:
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
2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

 
Rodney BarnhardtServer AdministratorCommented:
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
 
Roberto Madro R.Programmer AnalystAuthor Commented:
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
 
Rodney BarnhardtServer AdministratorCommented:
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
 
Roberto Madro R.Programmer AnalystAuthor Commented:
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
 
Rodney BarnhardtServer AdministratorCommented:
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
 
Rodney BarnhardtConnect With a Mentor Server AdministratorCommented:
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
 
Roberto Madro R.Programmer AnalystAuthor Commented:
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
All Courses

From novice to tech pro — start learning today.