User ' sa ' login failed. Reason: No workaround for connecting to a trusted SQL Server

User ' sa ' login failed. Reason: The solution for not connecting to a trusted SQL Server is as follows:

I. Control Panel-SERVICE-"MS SQL server-" Login-"Local System account-" Restart MS SQL SERVER
Using Windows Authentication Login Query Analyzer--"Execute sp_password null,sa new password, ' sa '

Two. " Unable to connect to server, user XXX login failed.
This error occurs because SQL Server uses the Windows only authentication method,
Therefore, users cannot connect using SQL Server's login account (such as SA). The workaround is as follows:
1. Use Enterprise Manager on the server side and select "Use Windows Authentication" to connect to SQL Server
Operation Steps:
In Enterprise Manager
--Right click on your server instance (that's the one with the green icon)
--Edit SQL Server Registration properties
--Select "Use Windows Authentication"
--Select "Use SQL Server Authentication"
--Login name input: SA, password enter the password for SA
-Determine
2. Set up to allow SQL Server login
Operation Steps:
In Enterprise Manager
--Expand SQL Server Group, right-click the name of the SQL Server server
--Select "Properties"
--and then select the Security tab
--under Authentication, select SQL Server and Windows.
--OK, and restart the SQL Server service.
In the above workaround, if you failed to connect to SQL Server using Windows authentication in step 1th,
Then fix the problem by modifying the registry:
1. Click "Start"-"Run", input regedit, enter Registry Editor
2. Expand the registry key sequentially and browse to the following registry keys:
[HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\MSSqlServer]
3. Locate the name "LoginMode" on the right side of the screen, double-click to edit the double byte value
4. Change the original value from 1 to 2 and click "OK"
5. Close Registry Editor
6. Restart the SQL Server service.
At this point, the user can successfully use SA to create a new SQL Server registration in Enterprise Manager.
However, you still cannot use Windows Authentication mode to connect to SQL Server.
This is because there are two default logon accounts in SQL Server:
BUILTIN\Administrators
< machine name >\administrator was deleted.
To recover both accounts, you can use the following methods:
1. Open the Enterprise Manager, expand the server group, and then expand the server
2. Expand Security, right-click Login, and then click New Login
3. In the Name box, enter BUILTIN\Administrators
4. On the Server Roles tab, select System Administrators
5. Click "OK" to exit
6. Use the same method to add < machine name >\administrator login.
Description
The following registry key:
Hkey_local_machine\software\microsoft\mssqlserver\mssqlserver\loginmode
Determines what authentication mode SQL Server will take.
1. Means using Windows authentication mode
2. Indicates the use of mixed mode (Windows authentication and SQL Server authentication).

----------------------
Tips:In addition, in the actual website project of 51aspx, some database connection information is written in several documents, also need to revise each one, especially note that write in. cs/vb the database settings are modified to remember after compiling to be effective!