Error in report server priveleges permission

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Error in report server priveleges permission

Author

Topic

kamii47
Constraint Violating Yak Guru

353 Posts

Posted - 2007-03-20 : 02:13:57

I have just installed sql server 2005 developer edition with ssrs

I am getting following error

When Browsing

http://localhost/ReportServer$Yukon/
Reporting Services Error
--------------------------------------------------------------------------------

The permissions granted to user 'KAMRANSHAHID\IUSR_KAMRANSHAHID' are insufficient for performing this operation. (rsAccessDenied) Get Online Help

--------------------------------------------------------------------------------
SQL Server Reporting Services

**********************************************************************************************************

When editing Surface Area Configuration

TITLE: Surface Area Configuration
------------------------------

System.Web.Services.Protocols.SoapException: The permissions granted to user 'KAMRANSHAHID\IUSR_KAMRANSHAHID' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'KAMRANSHAHID\IUSR_KAMRANSHAHID' are insufficient for performing this operation.
at Microsoft.ReportingServices.Library.RSService.SetSystemProperties(Property[] properties)
at Microsoft.ReportingServices.WebServer.ReportingService.SetSystemProperties(Property[] Properties)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService.SetSystemProperties(Property[] Properties) (System.Web.Services)

------------------------------
BUTTONS:

OK

**********************************************************************************************************

Also When I connect from management studio for the reporting services instance I get the same error of insufficient privilge

TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

The permissions granted to user 'KAMRANSHAHID\IUSR_KAMRANSHAHID' are insufficient for performing this operation. (rsAccessDenied) (Report Services SOAP Proxy Source)

For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsAccessDenied&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00

------------------------------

The permissions granted to user 'KAMRANSHAHID\IUSR_KAMRANSHAHID' are insufficient for performing this operation. (rsAccessDenied) (ReportingServicesLibrary)

For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsAccessDenied&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00

------------------------------
BUTTONS:

OK
------------------------------

**********************************************************************************************************

What Am I missing ?

But While browsing report {not server } works fine

kamii47
Constraint Violating Yak Guru

353 Posts

Posted - 2007-03-20 : 12:24:40

I have done by giving ntfs permission to user kamran shahid
and change ownership from administrator to kamranshahid
Now Only problem i am having is that when ever I browse for the reportmanager or reportserver the authentication window come up
in which i have to give my user name and password of the windows
How Can i get rid of this authentication window ?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources