MSSQL 2008 error message: failed to log on to sa

After logging on to the database in Windows, run the following command:

The code is as follows:	Copy code
EXEC sp_password null, "123456", "sa" Go Alter LOGIN sa ENABLE

The password is successfully modified!
Note: If the statement fails, restart the service and run the statement again.

 

Problem 1: a connection has been established with the server, but an error occurs during logon. (Provider: Shared memory provider, error: 0-there is no process on the other end of the MPs queue. Log on to management studio as a windows user, click site properties, and change the security options to windows and SQL mixed identity logon.

Problem 2: When you log on to SQL 2005 Enterprise Manager, windows Authentication is successful. However, when you log on using SQL server authentication, that is, the sa user name, the following error occurs: "provider: shared memory provider, error: 0-there is no process on the other end of the MPs queue ". Modify the settings as follows: since windows Authentication is successful, log on to the manager as this identity first, and then there is a server authentication in the server attribute, set to SQL server and windows authentication mode. Next, set attributes of the sa user in "security"> "logon". The "logon" field is displayed in the "status" column. The attribute is disabled by default and enabled. After the modification, restart the Enterprise Manager to log on with the sa user name. The problem persists.

After thinking for half a day, I had to restart the service after setting "SQL server and windows authentication mode. After the settings were completed, the enterprise manager was restarted and its service was not restarted. Therefore, find "SQL Server peripheral application configurator" and select "service and connection peripheral application configurator". Stop SQL server and start it again. This problem should be solved. Problem 3: a connection has been established with the server, but an error occurs during logon. (Provider: Shared memory provider, error: 0-there is no process on the other end of the MPs queue .) Server error in the "/cs" application. A connection has been established with the server, but an error occurs during logon. (Provider: Shared memory provider, error: 0-there is no process on the other end of the MPs queue .) if this error occurs, you can find a lot of information on the internet and there is no good solution. Finally, open the web. config

The code is as follows:	Copy code
<Add key = "SiteSqlServer" value = "server = (local); uid = csuser; pwd = xxx; Trusted_Connection = yes; database = communityserver"/>

Change

The code is as follows:	Copy code
<Add key = "SiteSqlServer" value = "Data Source =.; Initial Catalog = communityserver; Persist Security Info = True; User ID = csuser; Password = xxx"/>