I can't connect to Microsoft SQL Server

Bella Hamilton 1 Reputation point
2021-09-27T09:23:10.927+00:00

Hello

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/laina-finance.fi

Thank you

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,654 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,656 Reputation points
    2021-09-27T10:20:48.677+00:00
    0 comments
  2. Stratos Matzouranis 36 Reputation points
    2021-09-27T11:53:38.247+00:00

    Have you tried to connect via SQL login and not an Active Directory Account?

    0 comments
  3. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2021-09-28T02:53:39.863+00:00

    Hi BellaHamilton-5865,
    Welcome to Microsoft Q&A.
    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 Explorer-> 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 also check the similar thread which might be helpful.

    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.