locked
Unable to Connect SQL server remotely RRS feed

  • Question

  • Hi All,

    i have 2 SQL server A and B , B has a named instance called X and is configured to run with static port 1435. I am unable to connect server A from B with SSMS  connection string as B\X (with SQL authentication with valid user name and password). it throws an generic error message 

    TITLE: Connect to Server
    ------------------------------

    Cannot connect to A\X

    ------------------------------
    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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

    please note 1433 TCP and 1434 UDP ports are listening from server A to server B(checked with portquery tool)

    my question is do we need to open TCP port 1435 (with which named instance is configured) between A to B?

    Wednesday, February 22, 2017 12:10 PM

Answers

  • Hi,

    If your instance is running on port TCP 1435, then you need to open port TCP 1435 in the firewall.

    Port UDP 1434 is used by SQL Browser, it resolves instance names into port numbers.

    Wednesday, February 22, 2017 12:41 PM

All replies

  • If you have a named instance, the SQL Server is not listening to TCP port 1433.

    Please see:

    https://msdn.microsoft.com/en-us/library/ms177440.aspx


    https://social.technet.microsoft.com/wiki/contents/articles/2102.how-to-troubleshoot-connecting-to-the-sql-server-database-engine.aspx
    • Edited by Tom Phillips Wednesday, February 22, 2017 12:35 PM
    • Proposed as answer by Shanky_621MVP Wednesday, February 22, 2017 12:39 PM
    Wednesday, February 22, 2017 12:34 PM
  • Hi,

    If your instance is running on port TCP 1435, then you need to open port TCP 1435 in the firewall.

    Port UDP 1434 is used by SQL Browser, it resolves instance names into port numbers.

    Wednesday, February 22, 2017 12:41 PM
  • Thanks Lin...
    Monday, March 13, 2017 8:02 AM