Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

How Can I Verify the MSDE System Administrator Password is blank (null) using OSQL?

How Can I Verify the MSDE System Administrator Password is blank (null) using OSQL?

1. On the computer that is hosting the instance of MSDE to which you are connecting, open a command prompt window.

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:

Password:



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:

1>



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

NOTE:
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.

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 18:49
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.