1

I want to connect to my SQL server installed on a windows server 2012, that is running on a VPS(Virtual Private Server) remotely, I have done the following steps:

  • Enabling SQL Server to allow remote connections
  • SQL Server Configuration Manager>SQL Server Network Configuration>Protocols For MSSQLSERVER>TCP/IP Set Enabled
  • Create a new Inbound Rule for port 1443 in windows firewall

Still I cannot connect to SQL server remotely via SQL server management studio.

Thanks

2

In addition to using SQL Server Configuration Manager to enable TCP/IP connections, you need inbound tcp port 1433 and optionally udp port 1434 open at the firewall for SQL Server to accept inbound connections.

1433 is the default T-SQL tcp endpoint, and udp port 1434 is used by the SQL Server Discovery Protocol to locate SQL Server ports by the instance name, for example SQLSERVER\MYINSTANCE. If you are not using a named instance, 1434 is not required.

See this Microsoft Docs page for further details.

  • 1
    thanks your answer @Max Vernon, i googled my problem and i found if using named instance we don't need to use instance name after Server IP Address and i should use IP address with sql server user name and password to connect sql server – Edalat Feizi Aug 6 '17 at 19:22
  • The default port for SQL Server is 1433. The admin connection is 1434. I've never seen a "default" usage of 1432... – SQL_Hacker Aug 7 '17 at 12:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.