Post reply

sa password change - sql server 2000

  • June 4, 2008 at 6:41 am

    #121790

    hi all,

    does anybody ahve a script from which sa psasword can be change after regular intervals.

    we need to cahneg sa password regularly and we hv abt 45servers. so mnually changing them will be a big task

    thanks for your help.

  • June 4, 2008 at 7:35 am

    #824170

    There is no option in SQL 2000 but in SQL 2005 you should be check in "Enforce Password policy" and "Enforce Password expiration"This will ask you to change the SA password As per the Windows Policy.

    Manoj

    MCP, MCTS (GDBA/EDA)

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

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