SQL Server (fix the problem) has successfully established a connection to the server, but an error occurred during the logon process. (provider:shared Memory provider, error:0-no process on the other end of the pipeline.)

http://blog.csdn.net/github_35160620/article/details/52676416

The following issue occurs if you connect to the database by using the newly created SQL Server user name and password. Reading this blog can help you solve this problem.

Shared Memory Provider, error:0 - 管道的另一端上无任何进程。)(Microsoft SQL Server，错误：233) 管道的另一端上无任何进程。

The action that is having the problem

Start SQL Server Management Studio First

We select authentication as SQL Server authentication. Enter the user name and password you just created:

However, it is still not available directly because of permissions issues. You will see the following error prompt box:

How to solve the problem

So now we still need to connect to the database through Windows authentication . On the inside, make the following settings.

Step 1.

On the server, click the right mouse button, select the properties inside.

The following window pops up:

Enter security . You can see now that the server is authenticated by default: Windows authentication Mode (W)

We selected server Authentication as:SQL Server and Windows authentication Mode (S).

Finally click OK , will pop up the following prompt box, prompting us to restart the SQL Server software, the settings will take effect.

Now shut down the SQL Server software again and reopen the software again.

Select Authentication as SQL Server authentication . Enter the user name and password you just created:

This time again there was a problem:

Step 2.

Let's turn off the SQL Server software first.

Open: services , management tools , Control Panel

Locate the SQL Server Browser service and start it.

Step 3.

Locate the SQL Server (SQLEXPRESS) service and restart it

Now, we start again:sql Server Management Studio.

Select Authentication as SQL Server authentication . Enter the user name and password you just created. Click Connect .

Now it's ready.

Problem solving

SQL Server (fix the problem) has successfully established a connection to the server, but an error occurred during the logon process. (provider:shared Memory provider, error:0-no process on the other end of the pipeline.)