Can't connect to SQL Server Mamagment studio v18.12

Question

TITLE: Connect to Server

---

Cannot connect to GEORGEHP\MSSQLSERVER01.

---

ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

Answer 1

See MS Support: https://learn.microsoft.com/en-US/troubleshoot/sql/database-engine/connect/resolve-connectivity-errors-overview

Answer 2

Hi @Georgilvanov-9945

you should tell us a little bit more about your problem... or post a screenshot...

That error is more of "common" one and nothing special...
Where is your SQL Server?
Is TCP enable?
Which user do you try?
Has that user the right permission?
Is there a firewall in between?
A Typo?

As Olaf already stated... a good start would be that troubleshooting assistant.

I hope my answer is helpful to you,

Your
Bjoern Peters

If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!

Answer 3

Hi @Georgi Ivanov This article provides some steps to help you troubleshoot this error, which are provided in order of the issues from simple to complex.

You can also refer to this article which include some steps to isolate the issue. SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

Best regards, LiHong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 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.