Search code examples
sql-serverlocalremote-accessdatabase-backupssql-server-2019

Connect to SQL Server from another computer - SQL network-instance related issue (with error 258)


When I try to connect to SQL database from another computer using SQL Server Management Studio with Server Name [ my_ip_address,1433\MyServerName ] and SQL authentication, I get this error:

Cannot connect to XX.XXX.XXX.XXX,1433\MyServerName.

ADDITIONAL INFORMATION: 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 wait operation timed out.) (Microsoft SQL Server, Error: 258)

The wait operation timed out

I have done all of the needed steps:

  • Allowed remote connection in Server Properties window in SQL Management Studio
  • Enabled TCP/IP in SQL Configuration Manager (in SQL Server Network Configuration)
  • Set Inbound/Outbound enable connection (Domain, public, private) rules in Windows Firewall for ports TCP 1433

Solution

  • This tuto solved the problem for me: Allow SQL Server through Windows Firewall ( https://www.youtube.com/watch?v=3jVTUll4PXs) I had to add the paths of the sql server and sql server browser services to the allowed apps by the firewall.