How do I change the SA password in MSDE? (NETIQKB26419)

  • 7726419
  • 02-Feb-2007
  • 08-Sep-2008

Resolution

goal
How do I change the SA password in MSDE?

fact
VigilEnt Security Manager 3.0

fact
VigilEnt Security Manager 3.0 SR1

fact
VigilEnt Security Manager 3.0 SR2

fact
VigilEnt Security Manager 4.0

fix

To change the password from the command line on MSSQL Server or MSDE:

  1. Open a command shell by selecting Start|Run, and typing cmd.exe in the Run dialog box.
  2. Change to the directory in which the MSSQL or MSDE utilities are stored (this is ususally C:\MSDE\binn, C:\MSSQL7\binn, etc.,).
  3. Issue the following command where <newpassword> is the password you have chosen:

 osql -U sa -P "" -Q "sp_password NULL,<newpassword>,sa"



note
MSDE is only supported for evaluation purposes only.  MSDE is not supported for production.  Only Microsoft SQL Server is supported for production installations.

Additional Information

Formerly known as NETIQKB26419