SQL Server Instance Connection Error

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.

Verify that the instance name is correct and that SQL Server is configured to allow remote connections.

(provider: TCP Provider, error: 0 – The remote computer refused the network connection.) (Microsoft SQL Server, Error: 1225)

Route Cause

Mainly, MSSQL Server instance service is not active at 2 places

1. Microsoft SQL Server Configuration Manager

2. Windows Services

Solution

1. Just note that which MSSQL version you have installed first based on that you need to open SQL Server Configuration Manager first as listed below

SQL Server 2016	C:\Windows\SysWOW64\SQLServerManager13.msc
SQL Server 2014	C:\Windows\SysWOW64\SQLServerManager12.msc
SQL Server 2012	C:\Windows\SysWOW64\SQLServerManager11.msc
SQL Server 2008	C:\Windows\SysWOW64\SQLServerManager10.msc

2. Check which one you have installed on your machine, and copy the file path

3. Go to Run –> paste –> Press Enter

4. SQL Server Configuration window gets opened.

5. At the left panel, click on “SQL Server Services” and right panel choose the instance you have installed, and right click start the service

6. Go to Run command type–> services.msc –> press Enter

7. Find the SQL server same instance and right click and start the service

8. Close all the application opened.

9. All done now, Open MSSQL server and connect as usual.

10. Good to go now

Published by arjunpremier