configure the service account in reporting services

Question

User1045943723 posted

How does one configure the service account in reporting services configuration manager so an ASP.net website on another server has permission to  run a report. 

We have a website set up on \\NSF-WEB and it points to data on
\\NSF-SQL. We are running VS2010 on \\NSF-WEB where we have a page with a remote
report.

  <ServerReport ReportPath="/NSF_DB/MccLenderAnnual"

    ReportServerUrl="http://
NSF-WEB /ReportServerNSFDB" />

 The permissions granted to user
'SHELBYSYS\ NSF-WEB$' are insufficient for performing this operation.
(rsAccessDenied)

Thanks

Answer 1

User1918766559 posted

Could you open the Report Server Web Service URL ? If it shows the default SSRS home page , then please go to site settings & add your domain/user as System Administrator.

Otherwise, try to minimise the UAC control by open msconfig from start-> run -> select Tools -> Select Change UAC Settings(Change User Account Control Settings) -> Click Launch -> minimise the UAC settings control to down(Never Notify)

Restart the system & try to open the Report Server Web Service URL.

 

 

Thanks,

Anindita

http://anindita9.wordpress.com

 

Answer 2

User-8475372 posted

Generally, if you are working on windows 7, try opening the report server url in IE as ADMINISTRATOR. Set the full access permissions for the 'SHELBYSYS\ NSF-WEB$' user both in Report server and in the Database server(Add as a user in logins).

 

Answer 3

User1045943723 posted

Tried giving acces, but  still  getting  this error:

 

The permissions granted to user
'SHELBYSYS\ NSF-WEB$' are insufficient for performing this operation.
(rsAccessDenied)

Thanks