How do I change the SA password in MSDE?
VigilEnt Security Manager 3.0
VigilEnt Security Manager 3.0 SR1
VigilEnt Security Manager 3.0 SR2
VigilEnt Security Manager 4.0
To change the password from the command line on MSSQL Server or MSDE:
- Open a command shell by selecting Start|Run, and typing cmd.exe in the Run dialog box.
- Change to the directory in which the MSSQL or MSDE utilities are stored (this is ususally C:\MSDE\binn, C:\MSSQL7\binn, etc.,).
- Issue the following command where <newpassword> is the password you have chosen:
osql -U sa -P "" -Q "sp_password NULL,<newpassword>,sa"
MSDE is only supported for evaluation purposes only. MSDE is not supported for production. Only Microsoft SQL Server is supported for production installations.