Posted by Erland Sommarskog on 11/17/05 12:58

(Danieltbt05@gmail.com) writes:
> Hi, I have SP4. When i use netstat -an, there is no connection to my
> client machine. Do you mean both server and client can set up port as
> 1234 ? I also attached my errorlog, maybe can look at it ? Btw if both
> machine can ping by ip and name then it shouldn't be any connection
> problem right ? Thanks.

OK, here is an interesting tidbit:

> 2005-11-19 00:21:20.90 server SQL server listening on Shared Memory,
> Named Pipes.

Not a word on TCP/IP, even less a port number. This is how my errorlog looks
like:

2005-11-05 09:57:47.61 server SQL server listening on 172.16.18.28: 1433.
2005-11-05 09:57:47.61 server SQL server listening on 127.0.0.1: 1433.
2005-11-05 09:57:47.68 server SQL server listening on TCP, Shared Memory.
2005-11-05 09:57:47.68 server SQL Server is ready for client connections

So either you use the Server Network Utility and enable TCP/IP for the
server, and the restart the server. Or you use the Client Network Utitilty
on the client box and enable Named Pipes. I recommend the first opion.



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