Changing sa password in an enterprise

  • I remember a while ago attending a web cast with Brian Knight.  At the end of this web cast he talked about an application I think he created to help with managing SQL Servers.  In particular, he refered to the ability to change all of his sa passwords.  Does anyone remember this, or know of a easy was to do this in a batch mode. 

     

    Regards,

    Cory Stein

    MCDBA, MCSE, MCP+Internet

  • I use a batch file (*.cmd) that calls

     

    isql -S ServerA -E -Q"sp_password null, new, sa" >> change.txt

    with a line for each server, add a server add a line, change the pwd (search and replace). Low tech, but bulletproof and works well.

     

    You could write something more complciated, read list of servers from a db, file, etc. and loop. DMO.ListAvailableServers is blocked on our network after the slammer worm, so that doesn't work.

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

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