SQL Server 2008 on Windows Server 2008 Windows Firewall Question

Discussion in 'microsoft.public.sqlserver.setup' started by Guy, Sep 12, 2008.

  1. Guy

    Guy Guest

    What ports must be enabled, before installing iSQL Server 2008, on Windows
    Server 2008 when unstalling SQL Server 2008 Satndard Edition to avoid the
    Windows Firewall warning Message?

    I already added ports: SQL Server 1433 TCP and SQL Browser 1434 UDP, but get
    still the warning message.

    Thanks.
     
    Guy, Sep 12, 2008
    #1
    1. Advertisements

  2. 1433 is a default port number which is used by a Default Instance of SQL
    Server. However, Named Instances use Dynamic Ports instead of a Static Port
    by default. After installing Named Instances, I personally set a Static Port
    for each of them and create rules in Windows Firewall accordingly.

    To see which ports are being used by your SQL Server instances or change
    their port configuration, you can use SQL Server Configuration Manager
    (Start\Programs\Microsoft SQL Server 2008\Configuration Tools->SQL Server
    Network Configuration)
     
    Ekrem Önsoy, Sep 12, 2008
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.