SQLSRVR2008 and SQLSRVR2008R2 on same box

  • Named instances listen on a non standard port, either dynamic or static.

    The SQL Server Browser service tells the clients on which port the named instance is listening. If you cannot contact the UDP port 1434, you can't connect to the browser service and you don't know which port to attach to. First thing I would check is firewall rules.

    If you can connect to the named instance without specifying the instance name, two things could have happened:

    1) There's an alias in your native client configuration

    2) Somebody changed the port of the named instance to TCP 1433.

    Hope this helps

    Gianluca

    -- Gianluca Sartori

  • Got It. Thank you! That's what the firewall guys did probably (fix 1433 as the port for R2), when we complained that sql server is not accessible on that port.

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply