Post reply

user for SQL agent needs belog to SQLServer2005SQLAgentUser$.... ?

  • April 26, 2010 at 10:33 am

    #146610

    Hello guys,

    I would like to use a specific user for the SQLAgent.

    I have created the user under Active directory, this user must belong to the group:

    SQLServer2005SQLAgentUser$SQL......

    or it is not needed?

    or only changing the user to run the service SQL agent is enough?

    Thank for your reply

  • April 28, 2010 at 8:38 pm

    #1159381

    Hi,

    If you use SQL Server Configuration Manager to change service account (which is recommended way to change it) you don't need to grant any permissions. In other case (changing service account using Services Administrative add-in) there are registry and folders permissions that have to be set: http://support.microsoft.com/kb/283811.

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

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