//
you're reading...
ASP.NET, Database, IT-Center, SQL Server

Error Reporting Server MsSQLServer2005, The permissions granted to user ‘NT AUTHORITY\NETWORK SERVICE’ are insufficient for performing this operation. (rsAccessDenied)

The permissions granted to user ‘NT AUTHORITY\NETWORK SERVICE’ are insufficient for performing this operation. (rsAccessDenied)

I had come across this error a few years ago but had forgotten what the fix was for this.

We faced the same error while configuring the reports on one of our production servers.

We were trying to access the reports from a ASP.net application. The reports worked well when tried to access directly from the browser i.e. using http://localhost/reports . But when the same was accessed by the report viewer control in a web site it used to give an error saying :

“The permissions granted to user ‘NT AUTHORITY\NETWORK SERVICE’ are insufficient for performing this operation. (rsAccessDenied) “

The fix to this problem is very simple:

________________________________________________________________________

Error “The permissions granted to user ‘\IUSR_’ are insufficient in Reporting Server
If you get this error “The permissions granted to user ‘\IUSR_’ are insufficient for performing this operation.” when you work with Reporting Server, it is because the reporting server’s virtual directories under IIS is running in ‘Annonymous Mode’. To fix this open IIS, right click on the virtual directory that your report server uses, click on the tab ‘Directory Settings’ and click edit under ‘Authentication and Access Control’ and untick the ‘Enable Anonymous Access’

About berbagisolusi

Berbagi merupakan sebuah bentuk simbol keikhlasan untuk membantu dan menolong, sedangkan solusi adalah cara menyelesaikan masalah. Setiap manusia pasti mengalami masalah, tetapi kita tidak perlu mengalami masalah yang sama jika orang lain pernah mengalami dan kita tahu hal tersebut.

Discussion

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 9 other followers

December 2011
M T W T F S S
« Nov   Jan »
 1234
567891011
12131415161718
19202122232425
262728293031  

Archives

Web Statistic

Blog Stats

  • 149,580 hits
%d bloggers like this: