August 22, 2012 at 3:26 am
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
August 23, 2012 at 8:45 am
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.
August 23, 2012 at 9:09 am
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
August 23, 2012 at 9:42 am
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.
August 23, 2012 at 10:02 am
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
August 23, 2012 at 10:21 am
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?
August 23, 2012 at 10:31 am
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
August 23, 2012 at 11:48 am
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.
August 24, 2012 at 4:31 am
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.
August 24, 2012 at 7:12 am
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.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply