Changing blank SA password for MSDE

• Gary Andrade

  Ten Centuries

  Points: 1028

  More actions

  May 5, 2004 at 11:26 am

  #84191

  I have about 40 machines that got MSDE deployed with blank sa passwords.  I  want to run a script remotely or locally (via SMS) that will set a new sa password. Any ideas or scripts that have been used?  Thanks

• herbiechin

  Right there with Babe

  Points: 752

  More actions

  May 6, 2004 at 3:05 am

  #505428

  Hi Gary,

  Try the following:

  --change the SA Password in the MSDE version 8.00.382

  EXEC sp_password 'OldPass', 'NewPass', 'sa'

  Good luck

  Herb