September 9, 2014 at 2:56 am
Hello community,
Used Version: SQL Server 2014
I try to execute a rs.exe command within a StoredProc per sp_xpcmdshell
and get the following error message which comes from missing permissions.
SELECT @Command = 'rs -i F:\RSS\RP\RenderToPDF.rss -v id=5 -v ziel=F:\pdf\5.pdf -s http://SQL1:80/ReportServer_RP -e Exec2005'
EXEC xp_cmdshell @Command
RP ist the named instance of the DB and ReportServer.
The error message: The permissions of the user 'SQL1 \ DK_SQL_DE' are insufficient for performing this operation.
The SQL Server's service account is SQL1\DK_SQL_DE.
Docu says:
"The Windows process spawned by xp_cmdshell has the same security rights as the SQL Server service account. "
and
"To use the tool, you must have permission to connect to the Reporting Server instance for which the script is executed."
The Login SQL1\DK_SQL_DE within the instance RP has mappings to the Reportserver-DB, the ReportserverTempDB and the DB with
DefaultSchema 'dbo'.
In the filesystem all needed permissions are set.
The Command rs - i .... within a DOS-Shell executed as SQL\Administrator works - the PDFs are generated.
Has someone any idea what's missing?
Regards, Andi
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply