Minimum Rights for NT user to run SQL maintenance

  • I need to create an NT user account for running maintenance jobs, but i want to give only the minimum rights for the user access. I don't want to use the localsystem or sa as I'm running Windows Auth on the server. Please can you give me any idea's asap.

    Thanks

    Keith

  • I would just create a basic NT account that has ad rights and then add them to the sql server users with the rights of process administrators role, if they do not need to do anything apart from run jobs then this is the role to use.

    Regards,

    Terry

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

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