Msg 14544, Level 16, State 1, Procedure sp_add_jobserver, Line 68
This job is owned by ‘Domain1\User1’. Only a job owned by a member of the sysadmin role can be a multiserver job.

This is a very odd exception. In mine case it was caused by the TSQL script:

exec @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N'.\Instance1'

Changing the code to:

exec @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N’Server1\Instance1′

solved the problem.

The owner of this Microsoft SQL Server multiserver Agent Job is still not member of the server role ‘sysadmin’ and the SSIS package it calls is executed correctly. So it is possible to run a Microsoft SQL Server Integration Services packages with a Microsoft SQL Server Agent Job under a domain account which is not member of the server role ‘sysadmin’, just create the correct proxy, credential, login and user accounts and add them to the correct roles (SQLAgentUserRole), and grant the correct access for the proxy (SSIS).

One Comment

  1. Pingback: Twitted by roelvanlisdonk

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.