Share via

I am unable to connect to Microsoft SQL Server

Olamigoke Akinlalu 6 Reputation points
2021-03-26T14:15:04.897+00:00

TITLE: Connect to Server

Cannot connect to olamigoke-pc.

ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

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

No process is on the other end of the pipe

BUTTONS:

OK

SQL Server | Other

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AmeliaGu-MSFT 14,011 Reputation points Microsoft External Staff
    2021-03-29T06:19:29.817+00:00

    Hi @Olamigoke Akinlalu ,

    Are there any updates on this issue?
    What the authentication are you using? If you are using SQL Server login to connect to SQL Server, please login to the SQL server with windows authentication, then right-click the server name in the SSMS object Exploer-> Properties -> on the Security page, under Server authentication, please make sure to select “SQL Server and Windows Authentication Mode”.

    If you are using windows login, please go to SQL server configuration manager to ensure named pipes and TCP/IP is enabled. And turn off the firewall and antivirus software in the computer.
    Please refer to this article which might help.
    If you have any question, please feel free to let us know.

    Best Regards,
    Amelia

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.