A connection has been successfully established with the server, but an error has occurred during the login process

  
                  

A connection has been successfully established to the server, but an error occurred during the login process

The database is opened as soon as the

has successfully established a connection with the server, but it occurs during the login process Wrong solution (provider: shared memory provider, error: 0 - no process on the other end of the pipeline.)

Workaround:

1. It should be that the pipeline is not open on the server. Support, see someone on the Internet have the same problem, remote desktop into the SQL Server server try: Open & lsquo; program & rsquo; - & lsquo; all programs & rsquo; - & lsquo; Microsoft SQL Server 2005 & rsquo; - & lsquo; configuration tools & rsquo;- ‘SQL Server Configuration Manager & rsquo;, in the pop-up form, find & lsquo; SQL Server 2005 network configuration & rsquo;, & ldquo; MSSQLSERVER agreement & rsquo; under “ Named Pipes & rdquo; and “ TCP /IP & rdquo; Start and then restart Microsoft SQL Server 2005

2. Open the Configuration Tool -> "SQL Server Peripheral Application Configurator", after running, select "Services and Connections" Configuration for around & rdquo ;. First select Remote Connection -> Local Connection and Remote Connection -> Use TCP/IP only, click “ Apply & rdquo;. Second, select the service, stop the SQLEXPRESS service, and then restart it.

Copyright © Windows knowledge All Rights Reserved