|
|
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
Navigation:
[Reply to this message]
|