AccessDeniedException for running ssrs report

%3CLINGO-SUB%20id%3D%22lingo-sub-1672871%22%20slang%3D%22en-US%22%3EAccessDeniedException%20for%20running%20ssrs%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1672871%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20tried%20to%20give%20permissions%20to%20a%20service%20account%20to%20run%20reports%20as%20a%20batch%20process%2C%20but%20we%20have%20succeeded%20with%20that%20only%20when%20we%20give%20local%20admin%20permissions%20to%20the%20service%20account%20and%20we%20don't%20wish%20to%20do%20that.%3C%2FP%3E%3CP%3EThe%20command%20we%20are%20running%20is%26nbsp%3B%3C%2FP%3E%3CP%3E%22C%3A%5CProgram%20Files%20(x86)%5CMicrosoft%20SQL%20Server%5C130%5CTools%5CBinn%5Crs.exe%22%20-l%2018000%20-i%20%25RSSSCRIPT%25%20-s%20%22http%3A%2F%2F%25BISERVER%25%2F%25BIURL%25%22%20-v%20FILEPATH%3D%22%25PATHVAR%25%22%20-v%20FILENAME%3D%22%25FILENAMEVAR%25%22%20-v%20REPORT%3D%22%25BIREPORTLONGNAME%25%22%20-v%20FORMAT%3D%22%25BIFORMAT%25%22%20-v%20PARAMS%3D%25BIPARAMS%25%20-v%20PARAM_REPORT%3D%22%25BIMETA%25%22%20-v%20PARAM_FILENAME%3D%22%25BIREPORT%25_Meta.csv%22%20-v%20SKIPROWS%3D%221%22%20-e%20Exec2005%20-t%201%26gt%3B%20%25LOGFOLDER%25%5C%25BIREPORT%25.log%202%26gt%3B%26amp%3B1%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20these%20lines%20are%20in%20ReportServerService%20log%20file%3A%3C%2FP%3E%3CP%3Erunningjobs!ReportServer_0-26!4e80!09%2F10%2F2020-11%3A03%3A21%3A%3A%20i%20INFO%3A%20Adding%3A%201%20running%20jobs%20to%20the%20database%3CBR%20%2F%3Elibrary!ReportServer_0-26!4e34!09%2F10%2F2020-11%3A03%3A32%3A%3A%20e%20ERROR%3A%20Throwing%20Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException%3A%20%2C%20Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException%3A%20The%20permissions%20granted%20to%20user%20'domain%5Cserviceaccount'%20are%20insufficient%20for%20performing%20this%20operation.%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20account%20has%20permissions%20to%20run%20web%20reports%20as%20defined%20in%20MS%20document.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1672871%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EReporting%20Services%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello,

 

We have tried to give permissions to a service account to run reports as a batch process, but we have succeeded with that only when we give local admin permissions to the service account and we don't wish to do that.

The command we are running is 

"C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\rs.exe" -l 18000 -i %RSSSCRIPT% -s "http://%BISERVER%/%BIURL%" -v FILEPATH="%PATHVAR%" -v FILENAME="%FILENAMEVAR%" -v REPORT="%BIREPORTLONGNAME%" -v FORMAT="%BIFORMAT%" -v PARAMS=%BIPARAMS% -v PARAM_REPORT="%BIMETA%" -v PARAM_FILENAME="%BIREPORT%_Meta.csv" -v SKIPROWS="1" -e Exec2005 -t 1> %LOGFOLDER%\%BIREPORT%.log 2>&1

 

And these lines are in ReportServerService log file:

runningjobs!ReportServer_0-26!4e80!09/10/2020-11:03:21:: i INFO: Adding: 1 running jobs to the database
library!ReportServer_0-26!4e34!09/10/2020-11:03:32:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: , Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'domain\serviceaccount' are insufficient for performing this operation.;

 

The account has permissions to run web reports as defined in MS document.

0 Replies