Oracle/MSSQL/MySQL

The Server was not found or was not accessible: A network-related or instance-specific error occurred while establishing a connection to SQL Server

SQL-Error

SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. You can use SSMS to query, design, and manage your databases and data warehouses, wherever they are on your local computer, or in the cloud. Please see some related MSSQL guides I have written. What are the differences between various Editions of Microsoft SQL Server, and how to install MSSQL Server 2019 Developer Edition and SSMS on Windows, and how to download and install Microsoft SQL Server 2019 Express edition and SSMS.

You may run into the following error "a network-related or instance-specific error occurred while establishing a connection to SQL Server. The Server was not found or was not accessible" 
- Note: There are multiple causes for this failure, but in my lab, it was because the SQL Server Service isn't running. Below is the follow error that was prompted.
Screenshot-2021-06-19-at-13.25.14

Click launch the services.msc via the run command, or from the Server Manager, under Tools, or from the Administrative Tools. There are many other ways to launch this tool.
– As you can see below, the service isn’t running.

Screenshot-2021-06-19-at-13.25.53

To resolve this issue, we need to have the service started. To do this, right click on the SQL Sever server and click on start or use the start button on the extended sidebar etc.

Screenshot-2021-06-19-at-13.28.16

Now that the service has started, launch the SSMS once again and try to connect to the SQL Server.

Screenshot-2021-06-19-at-13.29.38

As you can see, we have eliminated the error and can now access the SQL Server.

Screenshot-2021-06-19-at-13.30.17

I hope you found this blog post helpful. If you have any questions, please let me know in the comment session.

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x
Kindly subscribe to TechDirectArchive
This is default text for notification bar