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
note
MSDE is only supported for evaluation purposes only. MSDE is not supported for production. Only Microsoft SQL Server is supported for production installations.
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:
- 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"
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