Re: SQL Server 2008 on Windows Server 2008 Windows Firewall Question
  Home FAQ Contact Sign in
microsoft.public.sqlserver.setup only
 
Advanced search
POPULAR GROUPS

more...

 Up
Re: SQL Server 2008 on Windows Server 2008 Windows Firewall Question         

Group: microsoft.public.sqlserver.setup · Group Profile
Author: Ekrem Önsoy
Date: Sep 12, 2008 14:50

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

"Guy" discussions.microsoft.com> wrote in message
news:C7E2A84D-3588-4771-9224-B6A93EC6F80A@microsoft.com...
> 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.
>
no comments
diggit! del.icio.us! reddit!