Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

Multiserver jobs - EXECUTE permission denied

Discussion in 'SQL Server 2008 General Discussion' started by Peter Schmitz, Oct 1, 2012.

  1. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    Today, while working on setting up a master/target server configuration which should enable me to define jobs on a single master server and then rolling them out to all other servers defined as targets, I kept running into a specific issue. I could easily execute the job created on the master server, but on the target server, I kept seeing this error:

    It took me quite a bit of time before figuring out that this message indicates that the user mentioned above needs those permissions on the master server, and not on the target server.

    I'll soon write an article about how to setup multiserver jobs administration.

Share This Page

Sponsored link: