permission to write to output file by non-sa domain service account job owner
-
Hello All,
We are getting following error message when executing the Job inside SSIS Package and this runs daily and I need to store its output to txt file on the other application server from the DB server.
And the user is the domain application service account (NOT SQL domain service account) but that user doesn’t have the sysadmin permissions.
The proxy account is set up using a domain SQL service account that has SA privilege which is our SQL services are running through this account.
My concern is that domain application service account and SQL domain service account should be part of local administrative on application server and folder level requires?(like read\write) ?
Application service account really requires SA permissions on the SQL DB instance? Or without SA permission how we can resolve this issue..Warning: cannot write logfile \\machinename\newfolder\xxxxxxx.csv. Writing to log files is only allowed to jobs that are owned by sysadmin. Please consider writing log to table.
So requesting you please help me to troubleshoot this issue.Thanks in advance!!
Best Regards,SQL server DBA
-
I'm waiting for experts suggestions to resolve this.Please help.
Thanks in advance!!
SQL server DBA
-
Well, your error is accurate. A Job has to be "owned" by SA in order to be able to write to the log. There's no way around that restriction that I know of. I don't know whether ownership and execution context need to be the same, however. Changing the owner is relatively easy. Try that first.
Steve (aka sgmunson)
Rent Servers for Income (picks and shovels strategy)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply