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