The Microsoft Data Engine (MSDE) version 1.0 is installed with the following products:
- Visio 2000 Enterprise Edition
- Microsoft Visio 2000 Enterprise Edition SR-1
The Microsoft SQL Server Desktop Engine (MSDE2000) is installed with Microsoft Visio Enterprise Network Tools (VENT).
To determine whether this applies to your system, try to log on to MSDE by using the OSQL utility from a command prompt. Use the following syntax:
However, if you receive the following message after you run the command
the security vulnerability applies to the system, and you must follow the steps in the next section to change the 'sa' password.
How to Secure the 'sa' Account with a PasswordYou can use the sp_password stored procedure to set up a password for the 'sa' account. For example, to change the 'sa' password from NULL to "Test!01", use code similar to the following:
- At the command prompt, log on to MSDE as follows:C:\>osql -U sa -P
- When you receive the "1>" message, change the 'sa' account password by using the following command:EXEC sp_password NULL,'Test!01','sa'Note In this command, 'Test!01' is a secure password that meets your organization's security guidelines and that you can remember.
Note The password for 'sa' account must be strong. For password advice, visit the following Microsoft Web site:
Acknowledgment: Adrian Romo of Quilogy contributed to this Microsoft Knowledge Base article.
Article ID: 321081 - Last Review: Jun 19, 2014 - Revision: 1