Cannot start reporting services from the browser
Hi to all,
I have a problem to view reporting services from the browser (http://ComputerName/Reports).
First i got the following error:
The permissions granted to user 'xxx' are insufficient for performing this operation. (rsAccessDenied).
Then i have removed the SSL configuration from the report manager url
and now i am getting the error"Unable to connect to the remote server"
I am running:
windows 7
MSSQL 2008 Developer
Any advice will be appreciated
Thank you
Ori
November 3rd, 2010 11:03am
Hi Ori,
For the issue "Then i have removed the SSL configuration from the report manager url and now i am getting the error"Unable to connect to the remote server" ",
Open rsreportserver.config file, by default, the file is located at C:\Program Files\Microsoft SQL Server\MSRS10.SQLSERVER\Reporting Services\ReportServer, then, change the SecureConnectionLevel value to 0 like this <Add Key="SecureConnectionLevel"
Value="0"/>.
For the error "The permissions granted to user 'xxx' are insufficient for performing this operation. (rsAccessDenied).",
Try to launch the IE using "Run as administrator". If this does not help, logon the report manager website with the machine built-in administrator account and assign the user "xxx" to a proper role so that the user can access Report server/manager. See
http://technet.microsoft.com/en-us/library/aa337491(SQL.90).aspx for Setting Permissions in Reporting Services.
thanks,
Jerry
Free Windows Admin Tool Kit Click here and download it now
November 5th, 2010 1:57am