|
Home > Archive > Microsoft SQL Server forum > October 2005 > Server Listing for TCP connection
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Server Listing for TCP connection
|
|
| N. Graves 2005-10-27, 9:25 am |
| I'm having trouble with an ODBC User that can't connect to 2003
Windows Server with SQL2000.
The ODBC fails when he tries to contact with TCP client connection.
When I view the Network Connection it is displaying TCP is checked,
but when I view the error log is doesn't display that it is listening
for TCP.
Is there any way to prove that my TCP connections are working
correctly or a way to make sure that my SQL server is listening for
TCP?
Thanks for reading my note and any help with this issue is greatly
appreciated.
| |
| Erland Sommarskog 2005-10-27, 9:25 am |
| N. Graves (ngraves@REMOVEyahoo
.com) writes:
> I'm having trouble with an ODBC User that can't connect to 2003
> Windows Server with SQL2000.
>
> The ODBC fails when he tries to contact with TCP client connection.
> When I view the Network Connection it is displaying TCP is checked,
> but when I view the error log is doesn't display that it is listening
> for TCP.
>
> Is there any way to prove that my TCP connections are working
> correctly or a way to make sure that my SQL server is listening for
> TCP?
When you are saying Network Connection, do you mean the Server Network
Utility?
Note that if you make a change here, it does not have effect until
you restart the server.
And, of course, watch out for Windows Firewall.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
| |
|
| To test if you can connect via TCP to the server without worring about SQL
Security. Try
telnet ipaddressofserver port
example:
telnet myserver 1433
"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns96FAF41F024F
1Yazorman@127.0.0.1...
> N. Graves (ngraves@REMOVEyahoo
.com) writes:
>
> When you are saying Network Connection, do you mean the Server Network
> Utility?
>
> Note that if you make a change here, it does not have effect until
> you restart the server.
>
> And, of course, watch out for Windows Firewall.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp
>
|
|
|
|
|