Ports used for Linked Server

  • We just set up a new server with SQL Server 2008R2 on Windows Server 2008 as a new DBA server. Our OPs team is asking me which ports are used to connect to the remote servers so that they can configure the firewall/switch properly (cannot ping some servers right now that I need to). This article http://support.microsoft.com/kb/287932 says the default port for SQL Server is 1433, which I knew, but not understanding if linking will treat it as a client I need to know if I have to have a larger range (1024-5000) opened. I'm not a network guru at this point and want to respond properly.

    So, I guess the question is... Which port(s) do I tell him I am using to connect to the remote servers.

    Thanks,

    Jared

    Jared
    CE - Microsoft

  • By default linked servers also use port 1433.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • Thanks!

    Jared
    CE - Microsoft

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

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