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
 Development Tools
 Reporting Services Development
 permission

Author  Topic 

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2010-02-19 : 05:01:10
Hello,
I have put my web project (which uses reporting services) into the web server for testing.
All works fine on th elocal machine but on the server I get this error when trying to access the reports:
The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied)

What do I do to solve this please?
thanks

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2010-02-19 : 05:17:07
I have now done this:
go to the property tab and create a new group with name
BUILTIN\Users
And in the role assignment tick browser role

Now the error is :

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'dsDB'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors

Any thoughts please?
thanks
Go to Top of Page

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2010-02-19 : 06:19:37
Solved by using the correct user in sql server logins.
Thanks
Go to Top of Page
   

- Advertisement -