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)
 RS 'NT AUTHORITY\NETWORK SERVICE' permissions erro

Author  Topic 

dexter.knudson
Constraint Violating Yak Guru

260 Posts

Posted - 2008-07-13 : 19:05:09
We are connecting to RS via Report Viewer in an ASP.net form. It works fine in dev mode but when deployed on the server we received a error: "The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied)"
We have given 'NT AUTHORITY\NETWORK SERVICE' dbo access in the app DB & dbo & RSExecRole in the ReportServer DB. I have also given this account System Administrator & System User access in the RS 'Site Settings'.
Does anyone have any ideas what the problem may be?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-13 : 19:38:43
Here is the answer:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=267060&SiteID=1
Go to Top of Page

BruceB
Starting Member

1 Post

Posted - 2010-03-20 : 13:44:58
The link does not work
Go to Top of Page
   

- Advertisement -