Hi Tharun,
Could you successfully connect to your SQL server instance using local SSMS?
Please follow below steps to troubleshot SQL server connection issue,
- Make sure SQL Server Service is running, you can check this from SQL server configuration manager or windows service.
- If a named instance, make sure SQL Server browser service is running. Make sure the instance name is spelled correct and there is actually such an instance on your target machine.
- Make sure SQL Server is configured to allow remote connections if this is a remote connection.
- Examine the SQL Server error log for messages confirming that SQL is listening on the expected network interfaces and ports.
- Test server connectivity with PING from the client machine.
- Test port connectivity using TELNET to the server and port (from step 4) from the client machine. For example,
TELNET <server-name> 1433
- Check firewall settings if step 5 or 6 connectivity test fails.
If you have some confuse about the steps, please refer to MS document A network-related or instance-specific error occurred while establishing a connection to SQL Server to get more information.
If the answer is helpful, please click "Accept Answer" and kindly upvote it.