Posted by Erland Sommarskog on 11/16/05 11:54

(Danieltbt05@gmail.com) writes:
> Hi, I don;t think I have any firewall installed but how to verify that
> no firewall is installed ?

Windows 2003 comes with Windows Firewall by default doesn't it? If it's
SP1, there is an applet in the Control Panel. If you don't have SP1, then
you have right-click the network connection, click Properties for TCP/IP,
and then look under the Advanced tab. (If memory serves.)

> Also i have check that port 1433 is not there on the server and client.
> Will SQL server only connect to this port or any other port number ?
> I've read that SQL will dynamically connect from port 1024 onwards, is
> it true ? If alias is not connected with ip address , port number and
> even name , then how does it connect to the server ?

A default instance of SQL Server listens to port 1433 by default. Non-
default instances typically uses other ports. When a client connects to
a non-default instance it first interrogates on UDP port 1434 to get the
actual port number. If that service is not available, for instance because
of a firewall, you can set up alias with the actual portnumber. I think you
also can specify the port number when you connect as SERVER,1234.

Finally, you did install service pack3 or 4 for SQL 2000, didn't you?
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]