Post reply

Change SQL admin/sa password across all the servers

  • November 21, 2011 at 8:49 am

    #248142

    Hello All,

    Do anyone know how to change the sa password at one time across all the servers? Can this be done using SQL script or system commands? Is there any affordable third party tool for this?

    Thanks much,

    Indy

  • November 21, 2011 at 9:07 am

    #1410807

    powershell could run the command for each server, however, if you had, say 20 servers, and all 20 servers have sa witht eh same password, that's still not very secure...i'd recommend for any non-development servers(production, sensitive, etc) that a windows domain group be added as sysadmins and the sa login be disabled, or at elast the pasword changed to something that is not predicatable, and different for each server.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • November 21, 2011 at 9:38 am

    #1410848

    Register all the servers in SSMS, right click the server group and select "New query".

    Run sp_password.

    However, I wouldn't set the same password on all the servers, as Lowell pointed out.

    -- Gianluca Sartori

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

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