[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now


MSDE cannot connect via telnet 1433 - query analyser works fine

Posted on 2004-09-09
Medium Priority
Last Modified: 2008-01-09

MSDE installation with Entprise Manager and Query analyser from Eval copy.

DBs can be seen and edited on localhost.   Default port 1433 being used.  Query analyser works fine.

However asp application on host needs DSN-less access to SQL server via port.

I cannot even telnet into 1433 and see a response.

Yet there is no firewall and I know service is running?

Do you need to enable it somehow?  Maybe something odd with MSDE.

Any ideas?

Question by:bendecko
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +2
LVL 34

Assisted Solution

arbert earned 124 total points
ID: 12022740
What do you get when you telnet--you don't normally get a response--you can type a few keystrokes and then you're taken back to a dos prompt....

Is the host on the same network--is it the host that you tried query analyzer from?  Is the asp application connecting using the same user/password you connected with from Query Analyzer?


Accepted Solution

davee_jay earned 128 total points
ID: 12024487
I imagine that due to the Dynamic Port allocation (a new 'feature' in SQL 2K) MSDE is not bound to the 1433 port.

You can check the version of the client libraries on the webserver as follows (W2K Prof - Your O/S may differ slightly):

Start -> Settings -> Control Panel -> Administrative Tools -> Data Sources (ODBC) -> Add

- Select the SQL Server Driver (Can you post the complete version number for our reference as well pls.) - Click Next

- Enter name, desc and Server - Click Next

- Client Configuration -> TCP/IP
  - Server name should be the name you entered
  - There should be a checkbox - Dynamically determine port - this should be checked - Click OK

- Click Next and Next again Then Finish

- Test Datasource

N.B. If there is no checkbox as noted above then install the SQL 2K client connectivity libraries on the webserver (not EM or QA though!)

Let me know how you get on.

LVL 59

Assisted Solution

by:Julian Hansen
Julian Hansen earned 124 total points
ID: 12024921
Telnet won't return anything.

When you say Query Analyser works fine do you mean it works fine when you type in an IP address as opposed to the server name.

Does the script work when you use a server name instead of an IP?

When you use Query analyser - is it from the same machine as the asp script is running on?
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 124 total points
ID: 12025002
>>I cannot even telnet into 1433 and see a response.
if you run telnet IP_ADDRESS:1433 and do not get a response AND NO ERROR, this is fine, because this means that the port is open.
if you get an error, then there is a firewall or the line is not available.
to explain: MSDE SQL Service actually get's the telnet connection, but doesn't answer to it. Thus TELNET client get's no response, but no error neither, as it actually waits from the TELNET server (which MSDE is not) to return/request some data. That's the way async communication works...

As described above:
* Check if the MSDE indeed uses port 1433
* Check the client configuration of the ASP host is configured correctly
* check also that the ASP has the permissions on the SQL Server to connect!!!


Author Comment

ID: 12026010
Thanks for all these great responses.

All the action is on one machine.  Website, MSDE, Query analyser all.....  No network or firewall or anything to worry about.

I know for a fact that if i telnet into my other machine (where all is working) I don't get refused entry on 1433 - this tells me that SQL is running fine.    I appreciate I get no response c.f. a mailserver response.

How can I determine which port SQL is running on if its dyanmic? Can I bind it manually.  What about a commandline command to see the binding services and ports?

I must have the connectivity libraries installed as EM and QA work - on the *same* machine.   No?

This is the ASP code that connects to the DB:

conn.Open "DRIVER=SQL Server;SERVER="&sysServer&";CATALOG="&sysCatalog&";UID="&sysUsername&";PWD="&sysPassword

No port is specficed in this string.  Does it need one?

Its worked hundreds of time on SQL servers running the full version of SQL Server 2000.  This is the first time I'm playing with MSDE and it doesn't appear to be playing the game the same way.

Thank you for your continued assistance.

LVL 59

Expert Comment

by:Julian Hansen
ID: 12026130
Goto your registry

check the following key


Under this Key either change the DSQUERY key to DBMSSOCN

Or create a server entry for your server

Create a new REG_SZ value with your server name as the value
Enter the following data for this value


Try again

If this fails then try the following

Create a new ODBC connection to your database. On the second screen click the client confiruation button and change the connection type to TCP/IP. Proceed through the setup and at the end test the conection by pressing the test connection button - tell us what happens.

Expert Comment

ID: 12026479
Ah, okay the issue is clearer now.  You are right you must have the client libraries installed.

Please take a look at the SQL Server Network Utility and look at the enabled protocols.  I imagine TCP/IP is not in the list.  If this is the case, then it needs to be.  You can specify the default port here.

Let me know how you get on.

Also, can you post the driver version information (can be found as per my instructions above)

LVL 34

Expert Comment

ID: 12027773
Agree--since QA is on the same machine you can probably connect fine.  Like davee_jay said above, did you enable protocols when you installed MSDE?

Author Comment

ID: 12028009
Yeah good work.

The protocol were enabled, yes.     Security all etc, all OK.

I read on another board to set the port to 0!  This turned out to be a disaster cos EM couldn't then see the DB at all.  This was supposed to let the server choose its own port.  Which, thinking about it, it did because...

I rebooted and it fixed itself and ent manager was able to connect.  I checked the port then in Client utility and it was 3144.   I changed this to 1433 and restarted the services and now we all cool.   Telnet in and ASP can access the DB.

I suspect that an additional reboot ealier would have actually had the same effect.

However EXCELLENT help and very quick responses.  Thank you.  I can now get back to serious business of coding the thing.




Featured Post

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question