This article is a mirror article of machine translation, please click here to jump to the original article.

Architect_Programmer_Code Agriculture Network»Architect › Database & Database › Microsoft SQL Server › (provider: Shared Memory Provider, error: 0 - The pipeline's ...
View: 11801|Reply: 1

(provider: Shared Memory Provider, error: 0 - There is no process on the other end of the pipeline.) ) (Mi...

[Copy link]
Posted on 4/14/2017 10:00:09 AM | | | |
Unable to connect to .

------------------------------
Additional information:

The connection to the server has been successfully established, but an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - There is no process on the other end of the pipeline.) (Microsoft SQL Server, Error: 233)

For help information, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

------------------------------

There are no processes on the other end of the pipeline.

------------------------------
Button:

Are you sure
------------------------------



Database version: SQL Server 2014

Start SQL Server 2014 Management Studio first

We select Authentication as SQL Server Authentication.

Enter the username and password you just created, and you will be prompted to log in failed.

But now it is still not possible to use it directly because of permission issues. You'll see the following error box:




Solution:

Connecting to the database via Windows authentication is required. Make the settings settings below inside.


Facing the server, right-click and select Properties.


Go to Security. You can see that the default in Server Authentication is Windows Authentication Mode (W)




We select Server Authentication as: SQL Server and Windows Authentication Mode (S).


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





Previous:.net/c# SendCloud Mass Mail [Source Code]
Next:.net/c# SendCloud free account mass messaging software

Related Posts
Disclaimer:
All software, programming materials or articles published by Code Farmer Network are only for learning and research purposes; The above content shall not be used for commercial or illegal purposes, otherwise, users shall bear all consequences. The information on this site comes from the Internet, and copyright disputes have nothing to do with this site. You must completely delete the above content from your computer within 24 hours of downloading. If you like the program, please support genuine software, purchase registration, and get better genuine services. If there is any infringement, please contact us by email.
Mail To:help@itsvse.com