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 .)
User 'sa 'Login Failed. This user is not associated with a trusted SQL Server connection.
Note: An unhandled exception occurs during the execution of the current Web request. Check the stack trace information for details about the error and the source of the error in the code.
Exception details: System. Data. SqlClient. SqlException: User 'sa 'Logon Failed. This user is not associated with a trusted SQL Server connection.
Note: An unhandled exception occurs during the execution of the current Web request. Check the stack trace information for details about the error and the source of the error in the code.
Exception details: System. Data. SqlClient. SqlException: 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 .)
Source error:
Row 35 :}
Row 36: if (con. State = System. Data. ConnectionState. Closed)
Row 37: con. Open ();
Row 38:
Row 39 :}
Source File: c: \ Inetpub \ wwwroot \ HomeMS \ App_Code \ DataBase. cs line: 37
Stack trace:
[SqlException (0x80131904): 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.)]
System. Data. SqlClient. SqlInternalConnection. OnError (SqlException exception, Boolean breakConnection) + 173
......................................
System. Web. UI. Control. LoadRecursive () + 49
System. Web. UI. Page. ProcessRequestMain (Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) + 3750
The solution is as follows:
First, select the SERVER (right-click)> Properties> Security> SERVER Authentication To "SQL SERVER and WINDOWS Authentication mode"
Next, expand "security"-> login name-> select the SA Login Account (right-click)-> Status-> login to enable
Solution:
1. log on to Management Studio as a Windows user, right-click the Server and select properties, and change the security options to SQL Server and Windows authentication modes.
2. Set attributes of the sa user in security-> logon name. The "Logon" field is displayed in the Status column. By default, this field is disabled and enabled.
3. Open the configuration tool> "SQL Server peripheral application configurator", and then select "service and connected peripheral application configurator ".
Choose remote connection> Local Connection and remote connection> only use TCP/IP and click "application ".
Then select the service to stop the SQLEXPRESS service and restart it.