|
Posted by Danieltbt05 on 11/16/05 02:19
Hi, I don;t think I have any firewall installed but how to verify that
no firewall is installed ? 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 ?
Regards
Daniel
Erland Sommarskog wrote:
> (Danieltbt05@gmail.com) writes:
> > Yes I've check in my server the SQL service is running. No i tried to
> > connect from another machine. Server is Win2003 standard server and
> > client is Win2000 prof. Both netlib uses TCP/IP and port 1433. I
> > configure both named pipe to be the same. Each can ping each other
> > either by IP or host name. I never change any protocol, uses the
> > default TCP/IP. As far as i know there is no firewall between them,
> > unless there is the windows internal firewall security ? is it
> > possible? .
>
> I Windows Firewall is running on the machine with SQL Server, you will need
> to configure the firewall to permit connections to SQL Server.
>
> > Btw what is alias for ? by using alias i can find the
> > server host name but not IP . Thanks
>
> Aliases are good when connection by name does not work, and you don't want
> to use IP-address and port number all the time.
>
> --
> 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]
|