|
|
Posted by Danny on 10/26/05 14:18
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:Xns96FAF41F024F1Yazorman@127.0.0.1...
> 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/techinfo/productdoc/2000/books.asp
>
Navigation:
[Reply to this message]
|