Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Insufficient permissions to access Reporting in Management Studio & web reports Expand / Collapse
Author
Message
Posted Wednesday, August 22, 2012 3:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 24, 2012 7:11 AM
Points: 6, Visits: 11
Hi all,

I've just added SQL Reporting Services to our SQL 2005 server, but cannot access the web interface (http://localhost/Reports) or any Reporting properties through Management Studio.

When I try to access http://localhost/Reports I get this error:

The permissions granted to user 'DOMAIN\username' are insufficient for performing this operation. (rsAccessDenied)

This is using a domain admin account.

If I try to view the permissions for Reporting in Management Studio, I can't access the Properties dialog box, receiving a permissions error. I've tried various accounts but can't access either.

All the posts I've read refer to adding permissions to the Home folder through the web interface, but I can't even access this.

Any help greatly appreciated.

Thanks,
Chris
Post #1348276
Posted Thursday, August 23, 2012 8:45 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 3:49 PM
Points: 191, Visits: 891
If you are a local admin on the box, you should have access to the admin website (and the reports home page, for that matter). Also, just to make sure, make your windows authenticated username an SA on SQL Server.

The URL for the admin page should be of the format http://<servername>:80/Reports.

If you are using a named instance, put the named instance with a underscore after Reports, like
http://<servername>:80/Reports_instancename

Once you can connect to the admin website, you should be able to set the needed users to have access to the home page.
Post #1349164
Posted Thursday, August 23, 2012 9:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 24, 2012 7:11 AM
Points: 6, Visits: 11
Thanks for the response.

The domain admin account I'm using has full SA permissions which I've just double checked, but I can't access the Reports site http://localhost:80/Reports - I'm accessing from the SQL server itself, but also if I try from my desktop I receive the same access denied error but with the domain admin account I configured the SQL reporting with rather than with my normal account I'm logged into the desktop with.

I realise this should just work and I should be able to get to the admin part of the reports, and based on the lack of this situation posted to forums (I've done a bit of scouring), I think I've got an odd problem.

I can attempt to remove reporting from the SQL server since it isn't used by any other application, but I have no idea whether this will fix the issue and how easy this will be.

Thanks
Post #1349192
Posted Thursday, August 23, 2012 9:42 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 3:49 PM
Points: 191, Visits: 891
Don't remove it just yet. Try to figure out what is wrong first. Removing it may cause problems well beyond what is going on now.

Go to your SQL Server install in the Start>AllPrograms section, and choose Configuration Tools, and Reporting Services Configuration Manager.

Connect to the server, and then go through all the tabs on the left to make sure everything is set up correctly (Service Account, URL, Database, Report Manager URL, etc.). (Service Account may need to be a local admin to get to the admin screen????? Not sure, but check current configuration and if it is not, make it one, and see if that changes things.)


Something may have been set up incorrectly when it was installed the first time.
Post #1349214
Posted Thursday, August 23, 2012 10:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 24, 2012 7:11 AM
Points: 6, Visits: 11
Everything looks correct in Reporting Services Configuration Manager.

The Windows Service Identity is running under a SQL service domain account we have, which is a local admin on the server.

The Web Service Identity has:

ASP .NET Service Account: NT Authority\NetworkService
Report Server: DefaultAppPool
Report Manager: DefaultAppPool

Database Setup - I've tried various accounts here including the domain admin account and the SA account, all without success.

The remaining options don't appear to have anything in them that would cause an issue.

Can you see anything wrong with the above? Should I try and recreate the Virtual Directories?

Thanks
Post #1349233
Posted Thursday, August 23, 2012 10:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 3:49 PM
Points: 191, Visits: 891
You are using SQL Server 2005. It required IIS for Reporting Services. Is IIS service running? Is it configured correctly?

Is the Virtual Directory "ReportServer"?
Is the RS database set to ReprotServer, and the Report Server Mode set to Native?
When you go to the Report Manager URL tab, and it gives the URL, can you click it to go to it? Does that bomb?
Is the actual Logon username for the SQL Server Reporting Services service the Windows-authenticated SQL Server Service Account? is the service running?
Post #1349246
Posted Thursday, August 23, 2012 10:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 24, 2012 7:11 AM
Points: 6, Visits: 11
You are using SQL Server 2005. It required IIS for Reporting Services. Is IIS service running? Is it configured correctly?

Yes, IIS is running and I've just restarted the service. I believe it is configured correctly.

Virtual Directory is ReportServer.

RS database is set to ReportingServices and the Mode is Native.

When you say the Report Manager URL tab, where do you mean? I have a Report Manager Virtual Directory option in Reporting Services Configuration Manager, but this just has the name (Reports) and website (Default Web Site). If I browse the the Report site (http://localhost/Reports), I still can't access it and receive the permissions error if I click Home.

The SQL Server Reporting Services service is running under the SQL service account I mentioned earlier which is a local admin on the SQL server. I've tried setting the DB connection properties in the Reporting Config Manager to use this, but no luck. The service is running.

Thanks
Post #1349249
Posted Thursday, August 23, 2012 11:48 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 3:49 PM
Points: 191, Visits: 891
Sorry, I was looking at my SQL 2008 RS Config. Guess it has different tabs.

You say that you go to http://localhost/Reports and it says you don't have permissions. Have you tried to give it the port number and use the actual server name in the URL? Like http://MyServer:80/Reports? And tried it from another computer in the same domain?

If none of this works, you are beyond my ability to help. Hopefully someone else knows of something else to try.
Post #1349276
Posted Friday, August 24, 2012 4:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 24, 2012 7:11 AM
Points: 6, Visits: 11
I've tried from different clients on different subnets, using the FQDN of the server with port, without port - you name it, I've tried it.

Thanks for your help, but I think I may have to try removing Reporting Services and starting again.
Post #1349564
Posted Friday, August 24, 2012 7:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 24, 2012 7:11 AM
Points: 6, Visits: 11
Issue found. It was Enterprise Vault Reporting that was causing the issue rather than a problem with SQL Reporting itself. I had to uninstall SQL Reporting to discover this though, but once I did, I found the solution here:

http://www.symantec.com/connect/forums/enterprisvault-reporting

Thanks again for your help.
Post #1349635
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse