MS SQL数据库连接错误求助：连接实例时遇网络/实例特定错误

Hey there, I’ve dealt with this exact MS SQL connection error countless times—here are the most reliable troubleshooting steps to get you connected:

• Check if the SQL Server service is running
  Open services.msc (press Win+R, type this command and hit Enter). Look for SQL Server (your instance name)—the default instance is usually SQL Server (MSSQLSERVER). If it’s stopped, right-click it and select "Start". Also set its startup type to "Automatic" so it runs on boot.

• Verify your instance name and port number

  • For the default instance, you can just use the server’s IP or hostname. For named instances, the format is hostname\instancename (e.g., DESKTOP-ABC123\SQLEXPRESS).
  • To confirm the port SQL Server is using: Open SQL Server Configuration Manager, go to SQL Server Network Configuration > Protocols for [your instance], right-click TCP/IP, select Properties, go to the IP Addresses tab, scroll to the bottom and check the "TCP Port" value (default is 1433 for default instances). You can also connect using hostname,port (e.g., DESKTOP-ABC123,1433).

• Ensure firewall allows SQL Server traffic

  • On the SQL Server machine, open Windows Defender Firewall with Advanced Security. Create an inbound rule that allows traffic on port 1433 (or your custom port) for TCP.
  • If you’re connecting from another machine, make sure the remote firewall also allows this port, or temporarily disable the firewall (only for testing!) to rule it out.

• Enable TCP/IP protocol in SQL Server Configuration
  Open SQL Server Configuration Manager, navigate to SQL Server Network Configuration > Protocols for [your instance]. Make sure TCP/IP is set to "Enabled". You’ll need to restart the SQL Server service after changing this.

• Check if remote connections are allowed
  Open SQL Server Management Studio (SSMS) on the server, right-click your server instance, select "Properties", go to the "Connections" tab, and make sure the Allow remote connections to this server checkbox is ticked.

• Validate your login credentials
  Double-check that you’re using the correct username and password. If you’re using Windows Authentication, ensure your user account has permissions to access the SQL Server instance. You can test this by logging into the server machine directly and connecting via SSMS with the same credentials.

• Test the connection with SSMS first
  Before using your application to connect, try connecting via SQL Server Management Studio from the same machine (and remotely if needed). If SSMS can’t connect, the issue is with the server setup, not your app code. If SSMS works, then the problem is likely in your connection string—double-check that it matches the instance name, credentials, and port correctly.

内容的提问来源于stack exchange，提问作者naweed