A connection has been established with the server but an error occurs during logon. Provid

A connection has been established with the server but an error occurs during logon. The provider shared memory provider error0 has no processes on the other end of the MPs queue. Classification: sqlserver2010-05-0118: 5110060 people read comments (3) Collection Reports Server sqlserver remote connection sqlserverwindowse

A connection has been established with the server but an error occurs during logon. The provider shared memory provider has no processes on the other end of the error 0 pipeline. Category: SQL server 10060 people read comments (3) collect Reports server SQL server Remote connection sqlserverwindowse

AlreadySuccessfulAndServerCreateConnection HoweverInLoginProcessMediumOccurredError. ProviderShareMemoryProvideProgramError 0MPs queueOn the other endAnyProcess.

Category: SQL server 10060 people read comments (3) collect reports

ServerSQL server RemoteConnectionSqlserverwindowsexception

User 'sa'LoginFailed. This user and trusted SQL ServerConnectionNo association.
Note: An unhandled exception occurs during the execution of the current Web request. Check the stack trace information to learn about thisErrorAnd cause in the codeError.

Exception details: System. Data. SqlClient. SqlException: User 'sa'LoginFailed. This user and trusted SQL ServerConnectionNo association.

Note: An unhandled exception occurs during the execution of the current Web request. Check the stack trace information to learn about thisErrorAnd cause in the codeError.

Exception details: System. Data. SqlClient. SqlException: alreadySuccessfulAndServerCreateConnection,HoweverInLoginProcessMediumOccurredError. (Provider:ShareMemoryProvideProgram, Error: 0-MPs queueOn the other endAnyProcess.)

SourceError:

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. csRow:37

Stack trace:

[SqlException (0x80131904): alreadySuccessfulAndServerCreateConnection,HoweverInLoginProcessMediumOccurredError. (Provider:ShareMemoryProvideProgram, Error: 0-MPs queueOn the other endAnyProcess.)]
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

(After this problem is solved, the following problems will occur (encountered by yourself): the user "sa" fails to log on to SQLServerError18456, solution: http://hi.baidu.com/mengqing723/blog/item/f7e4b03dbdaf5d0abaa167c5.html)

The solution is as follows:

SelectServer(Right-click)-> properties-> Security->ServerChange authentication to "SQL SERVER and WINDOWS Authentication Mode"
ExpandServerOn the "Security"-> login name-> select the SA Login Account (right-click)-> Status-> login to enable

Solution:
1. Use Windows identityLoginManagement Studio, right-clickServerSelect properties to change the security options to SQL Server and Windows Authentication mode.

2. Choose Security>LoginSa user attributes are set in the name, and"Login", Which is disabled by default and enabled by default.




3. Open the configuration tool> "SQL Server peripheral application configurator". After running, select "service andConnection".
Select remoteConnection-> LocalConnectionAnd remoteConnection-> Only use TCP/IP and click "application ".
Then select the service to stop the SQLEXPRESS service and restart it.

Above