How to verify that the SA password is blank
1. On the computer that is loaded with the MSDE that you are connecting to execute the individual, the command prompt character window is turned on. 2. Enter the following command in the command prompt cell, then press Enter: OSQL -U SA This command will use the SA account to connect you to the MSDE presets on this machine. If you want to connect to the name of the name to be installed on your computer, enter: OSQL -U SA -S ServerName / InstanceName You are now under the following command prompt character: Password: (password:) 3. Press ENTER again. This operation will transmit a NULL password for SA. If you are now being prompted by the following command, after you press Enter, your SA account will have no password: 1> Microsoft recommends that you create a non-NULL's strong password to meet security measures. However, if you receive the following error messages, you can enter an incorrect password you entered. This error message indicates that the password has been established for the SA account:
The login of the user 'sa' failed.
The following error message indicates that the computer is executing SQL Server is set to only "Windows Account Verification":
The login of the user 'sa' failed. Cause: The trusted SQL Server connection is not combined.
You cannot verify your SA password in the "Windows Account Verification" mode. However, you can create a SA password. You can ensure your SA account security when your verification mode is changed to "Mix mode" in the future. If you receive the following error messages, the SQL Server may not be executed, or the name of the installed SQL Server name is not correct:
[Shared Memory] SQL Server does not exist or refuse access.
[Shared Memory] ConnectionOpen (Connect ()).
How to change your SA password
1. On the computer that is loaded with the MSDE that you are connecting to execute the individual, the command prompt character window is turned on. 2. Enter the following command, then press Enter: OSQL -U SA in the Password: Command Prompt Bill, if your password is blank, press Enter, or enter the current password. This command will use the SA account to connect you to the MSDE preset on the unit. If you want to use the "Windows Account Verification" connection, enter the following command: use osql -e3. Please enter the following command, then press Enter: sp_password @old = null, @new = 'complexpwd', @loginame = 'sa'
Go
Note: Please make sure you replace complexpwd using the new strength password. The strong password contains the combination of English digital elements and special flms, as well as size. You will receive the following information, indicating that your password has been successfully changed:
The password has been changed.
How to judge or change your verification mode
Important: This article contains information about modifying logins. Be sure to back up it before modifying the login and learn how to restore logins when there is a problem. For more information on how to back up, restore, and edit logins, follow the file numbers below to view the files in the "Microsoft Knowledge Base":
256986 Microsoft Windows Login Description
WARNING: Improper use of "login edit" may result in serious problems, and even reinstall the job system. Microsoft does not guarantee that you can solve problems caused by using the "login edit program". Please bear all the risks that use the "Login Editor".
If you are not sure how to verify your MSDE installation verification mode, you can check the corresponding login project. Depending on the preset, the value of the WindowsLoginmode login unit code is set to 1 for "Windows Account Verification". This value is 2 when "hybrid mode" is enabled.
• The location of the LoginMode subcode, depending on the MSDE is installed to preset MSDE to perform an individual or install it to perform an individual. If you install the MSDE to a preset performed individual, the LoginMode subcode is located in the following login code:
HKLM / Software / Microsoft / MSSQLSERVER / MSSQLSERVER / LOGINMODE
• If you install the MSDE to a name to perform an individual, the LoginMode subcode is located in the following login code:
HKLM / Software / Microsoft / Microsoft SQL Server /% InstanceName% / MSSQLSERVER / LOGINMODE
Note: You must set one before you switch the verification mode.
SA password to avoid exposure to a possible security vulnerability.
For more information, please press the file number below to see the files in "Microsoft Knowledge Base":
274773 FIX: IF you change Windows Security To Windows / SQL Security THE SA Password Is Blank
If you want to switch from the "hybrid mode" to the integrated (Windows) verification, please follow these steps:
1. If you want to stop MSSQLServer and all other related services (such as SQLServerAgent), open the [Service] small screener in the [Console]. 2. Turn on "Log in to the edit program". If you want to turn on "Log in to edit program", press [Start], then press [Execute], then enter: regedt32 Press [OK]. 3. Find any of the following subcodes (depending on how you install MSDE to execute individuals or install individuals or install them to implement individuals:
HKEY_LOCAL_MACHINE / SOFTWARE / Microsoft / MSSQLSERVER / MSSQLServer
- or -
HKEY_LOCAL_MACHINE / SOFTWARE / Microsoft / Microsoft SQL Server /
4. In the right pane, press the [LoginMode] subcode. 5. In the [DWORD editorial] dialog, set this machine code to 1. Please make sure the [HEX] option has been selected, then click [OK]. 6. Restart the MSSQLServer and SQLServerAgent services to make changes.
SQL Server Installation Security Best Measures The following items will make your system more secure and they are part of any SQL Server installation.
• Use a non-NULL password to ensure your SA login account security. Some pests will only endanger the SA login account without safety protection. For more information, please press the file number below to see the files in "Microsoft Knowledge Base":
313418 PRB: UNSECURED SQL Server with Blank (Null) Sa Password Leaves Vulnerability to A WORM
