URGENT: MSDE TCP Problem

From: Snehal Tiwari (snehaltiwari_at_yahoo.com)
Date: 04/27/04 

Date: 27 Apr 2004 03:33:06 -0700

I have installed MSDE 2000 on an XP Prof. box. I am able to connet to
this instance locally from the server, but when i try to connect to it
from other machines, i get an error stating

Server does not exist or access denied

I have traced this problem to msde not listening on port 1433 on my
server machine.
I have inspected the 'Server Error Log' and it says

SQL server listening on Shared Memory, Named Pipes.

What i know is TCP should be listed here, but problem is how do i get
it listed?

I have installed client tools from the sql server CD and using the
'Client Network Utility' i have enabled TCP/IP and Named Pipes
protocols. The port listed for TCP is 1433.

Using PortQry tool i have also checked that no other application has
taken up the 1433 port. I dont get any error during msde startup that
port is unavailable.

I dont seem to understand why msde is not listening on TCP 1433. Any
ideas on how i can force it to do that.

Thanking in advance for your inputs
Snehal

Relevant Pages

  • Re: MSDE vs Windows XP PRO firewall
    ... >>> MSDE does not require file level access, ... >>> and only requires port 1433 to remotely access the databases. ... >> a sql problem. ... There is no reason to expose a server to ports that are not ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Help with Master/Detail UI in ADPs
    ... No, MSDE is not limited to 5 concurrent users, it is limited to 5 concurrent ... The users whose connection to the server is idle at any moment don't count. ... and from the local temp table to the Detail table on the server for rows ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Unable to connect to SQL 2000 engine on other machine from SSM
    ... how SQLServer-Browser resolves portnumber of MSDE named instance. ... Windows 2003 Server ships with SSEE preinstalled (for ... port information to your client. ...
    (microsoft.public.sqlserver.connect)
  • Re: Unable to connect to SQL 2000 engine on other machine from SSM
    ... Upgrade MSDE to SP4: not ok. ... Windows 2003 Server ships with SSEE preinstalled (for ... > port information to your client. ...
    (microsoft.public.sqlserver.connect)
  • Re: MSDE and IIS - Web Hosting
    ... sites getting over 3M hits per month and MOST of those hits were on ... when going to Windows 2003 Server and running very SMALL sites using ... coding for MSDE instead of Access because it's really our only option. ... but not as well as SQL Server who knows. ...
    (microsoft.public.sqlserver.msde)