Hi @solomon olusanya ,
How did you connect to your SQL server instance? Using SSMS or others? Please follow below steps to troubleshot SQL server connection issue.
- Make sure SQL Server Service is running
- 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
- 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 Resolving could not open a connection to SQL Server errors or Troubleshoot connecting to the SQL Server Database Engine to get more information.
If you have some confuse about using SSMS connecting to SQL server. Please refer to MS document Lesson 1: Connecting to the Database Engine to get detail steps.
Use SSMS connect to SQL server.
Choose the SQL server instance that you want to connect.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".