Connect to server using ms sql server to database

[Analitika]

Hello,

I would like to ask how to connect to database server using Microsoft SQL server Management Studio. I have connection to database in odbc, and it works, whenever I try connect using microsoft sql server with same connection I am getting this error:

[v-yiruan-msft · Accepted solution]

Hi @Analitika ,

You can refer the following official documentation to connect to a SQL Server instance:

Connect to a SQL Server instance

The error message you’re seeing is quite common when trying to connect to SQL Server. It usually means that the client application can’t find the server or can’t establish a connection. You can refer the following official documentation to make troubleshooting and solve the problem:

A network-related or instance-specific error occurred - SQL Server | Microsoft Learn

• Check the server and instance name: Make sure the server and instance name you’re trying to connect to is correct.
• Check the SQL Server service: Make sure the SQL Server service is running. You can check this in the SQL Server Configuration Manager.
• Check the SQL Server Browser service: If you’re trying to connect to a named instance, make sure the SQL Server Browser service is running.
• Allow remote connections: Ensure that SQL Server is configured to allow remote connections.
• Check the network protocols: SQL Server uses TCP/IP and named pipes to communicate. Make sure these network protocols are enabled.
• Check the firewall: Your firewall might be blocking the connection. You may need to create an exception on the firewall for the SQL Server instance and port you are using.
• Ping the server: You can try pinging the server to check if DNS can be resolved correctly.

Best Regards