Post reply

Run a job using SQL Agent Service Rights ! Can it be Changed ?

  • November 27, 2006 at 11:01 am

    #115282

    Hi All,

    I have a job which runs well using a seperate login, but when the job is executed using the SQL agent logni, the job fails. I was wondering if there was a way in which you can run a job with a different user rights and not the SQL Agent rights ?

    Thanks

     

    Kindest Regards,

    John Burchel (Trainee Developer)

  • November 27, 2006 at 10:23 pm

    #674221

    SQL Server Agent proxy accounts were created for this very reason. You can read more about them in Books Online: http://msdn2.microsoft.com/en-us/library/ms189064.aspx

    Cheers,

    Dan

  • November 28, 2006 at 10:01 pm

    #674574

    Hi

    If you right click the properties on the SQL Agent in enterprise manager (while it is stopped). On the General tab you will find Service Startup account. You can change this to a domain account.

     

    Regards

    Mike

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply