question

OlamigokeAkinlalu-9386 avatar image
0 Votes"
OlamigokeAkinlalu-9386 asked AmeliaGu-msft answered

I am unable to connect to Microsoft SQL Server

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-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Are you using Windows authentication or SQL authentication?

Are you in a domain or a workgroup?

Is the SQL Server instance on a) your local machine b) on a VM on your local machine or c) on a different machine in your environment?

0 Votes 0 ·

1 Answer

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi @OlamigokeAkinlalu-9386,

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.