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.)

Source: Internet
Author: User
Tags microsoft sql server management studio sql server management sql server management studio

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.)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.