Post reply

Change password on a Job

  • July 17, 2006 at 4:58 am

    #171595

    Hello:

     

    I need to change passwords every 3-4 months in my sqlserver database.

    I know how to change the password, but i am interesring if I can change it automaticully in the Job also.

     

    Offer.

  • July 17, 2006 at 8:47 am

    #649572

    Ideally, the best option is to have your network admin to create a user account specifically to be used for SQL jobs.  This account would have non-expiring password, not be permitted to logon to workstations, and have just enough permissions for the work it needs (i.e. access network shares only that it needs, cannot logon locally, only run as batch job or service, etc).

    Hope this helps



    Mark

  • July 18, 2006 at 8:34 pm

    #650000

    Best practices says that service accounts should change passwords according to the regular password policy employed by the institution (though no more than 90 days). But otherwise, I agree with what Mark says. In actuality, you can take it one step further. Your network admin can configure the account to only log on to the computer systems that's required. So you could keep the account from being used anywhere except where it's needed.

    K. Brian Kelley
    @kbriankelley

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

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