How Can I Verify the MSDE System Administrator Password is blank (null) using OSQL?
2. At the command prompt, type the following command, and then press ENTER:
osql -U sa
This connects you to the local, default instance of MSDE by using the sa account.
To connect to a named instance installed on your computer type:
osql -U sa -S Machine1
Whereby Machine1 is the name of the machine that hosts the MSDE database.
You are now at the following prompt:
3. Press ENTER again. This will pass a NULL (blank) password for sa.
If you are now at the following prompt, after you press ENTER, then the password for the sa account is indeed blank:
However, if you receive the following error message, you have entered an incorrect password. This error message indicates that a password has been created for the sa account:
"Login Failed for user "sa"."
The following error message indicates that the computer that is running SQL Server is set to Windows Authentication only:
Login failed for user "sa". Reason: Not associated with a trusted SQL Server connection
Microsoft recommends that you create a non-NULL, strong password to conform to security practices. We also recommend this policy. If you have a blank password you will not be able to setup an active repository in SilkPerformer Repository Manager.