Posted by Erland Sommarskog on 11/15/05 11:20

(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]