Re: MSDE and Sql Server 2005

=?Utf-8?B?QSBMYWtl?= <ALake@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:4F8AB845-1E4E-4FCE-B021-BAD63DEBC854@xxxxxxxxxxxxx:

netstat -a shows listening on Port 1217 (changed ffrom default 1433)
but clients cannot connect.

I can connect locally using the management express tool.

Which I suspect is not using TCP/IP to connect.

a) Try to connect to 127.0.0.1:1217 (i.e. via TCP/IP) using one of the
ISQL/OSQL/SQLCMD utilities on the server.

b) If (a) works, try to connect the same way but use the assigned IP
address instead of the loopback address.

c) If (b) works, repeat (b) but from a different computer (but preferably
on the same subnet as the server).

d) If (c) works, repeat (b) but from one of the client computers.


The application that uses the MSDE works on the local server, but
clients fail to connect.

"Chris.Cheney" wrote:

=?Utf-8?B?QSBMYWtl?= <ALake@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:93A44FA5-7F64-45B1-91DA-938702D5F04D@xxxxxxxxxxxxx:

Well, I've applied SP4, checked the port is open and clients still
cannot connect even with their firewalls disabled.

Looks like this server will not act as a server!

Is there _still_ nothing listening (netstat -a) on the relevant port?

If MSDE is listening on that port, can you access MSDE locally via
loopback (127.0.0.1)?



.

Relevant Pages

  • Re: really simple question
    ... > I'd like to test developing in SQL on my peer network before installing ... > the application on my clients' servers. ... I am using VB.Net and MSDE as ... in the first scenario, only 1 MSDE server is available, every client will ...
    (microsoft.public.sqlserver.msde)
  • SQL 2000 and MSDE/Express/Compact edition..
    ... desktop app with MSDE 2000 backend to 300 clients enabling them to ... work offline then sync with our SQL server. ... isnt going to be possible with 300 external clients.. ...
    (microsoft.public.sqlserver.replication)
  • Whos blocking these ports? Please help...
    ... server - one is called Vicomsoft Internet Gateway (proxy server, ... IG basically takes over the TCP/IP routing and does this using ... Each of these ports uses a NIC in the server. ... All the clients are assigned IPs ...
    (microsoft.public.win2000.security)
  • Re: how to setup a secondary NIC on a domain controller
    ... slow because the server has performance issues? ... > clients at my site as well as folder redirection. ... > IPX is faster than TCP/IP. ... > The reason I am asking about a secondary NIC on the mail server is because ...
    (microsoft.public.win2000.networking)
  • Re: What event does application call when it is ended abnormally?
    ... When Server has error, it needs to be restarted, after that all clients need ... that the host has closed that connection or that there is no session ... WSAECONNABORTED if the TCP/IP stack has given up on the connection because ...
    (microsoft.public.vc.mfc)