Application Server Solutions for Microsoft IIS and ASP.NET
       solutions   products   partners   company   support   downloads         store
ServletExec Self-Help: FAQ
Back to Search >  Back to Search Results

Faq ID 230
Product JTurbo
Category Connection, Debugging
Question How can I know whether or not my SQL Server is listening on a TCP/IP port ?
Answer Go to:
Start - Programs - Microsoft SQL Server - Server Network Utility (in the Microsoft SQL Server 7.0 program group).
On the general property sheet, Add or select TCP/IP under Network libraries. Enter the port number and the proxy address (if nesessary) and click OK.
By default, Microsoft SQL Server uses port 1433.
However, it can be configured to listen on any port number. To make sure that the RDBMS server is listening on the machine name and port number you specified use:
telnet <hostname or ip address> <port number>
If the connection is refused then the hostname or the port number may be incorrect, or possibly your networking is setup to block traffic on that port (a network firewall for example).

Note that with Win2003 the network libraries for SQL 2000 are disabled by default until you apply SP3/SP3a. This fact is mentioned on a
Google Group Forum
Thanks to Peter Hradecky for locating this information and confirming that it works.



   
company media information terms of use privacy policy contact us