Newbie: MSDE no longer listens to outside request. Event id 19011.

Hi
I've had a MSDE 2000 instance running a couple of months without any
problems. Now all of a sudden I can only connect to it from localhost.
When I restart the sql-server using the Service Manager it gives a
warning in the event log with event-ID 19011. Error code 1355.
Also I have a bunch of informational events with event-id 3 and
something about some missing file. I'm not sure if the two event-types
have something to do with each other, though.
I believe my problems started after installing a very simple program
called Dyndns Updater. Looking in the install-log I found that it only
installs the main exe, some txt-files and a normal run-parameter in the
registry. To me it seems unlikely that it should interfere with MSDE in
any way. Uninstalling doesn't help either.
All other services on my server are working normally from another computer.
I'm kind of stuck here, not wanting to uninstall/reinstall MSDE.
Any pointers?
Regards
Ådne Hovda
GTR AS
NORWAYHow about firewalls? Are you running MSDE on Win XP and have you installed
SP 2 recently? The Windows Firewall will, by default, prevent responses to
inbound traffic from Ports 1433 (TCP) and 1434 (UDP). If this is your
problem, try opening up these two ports on your Windows Firewall.
Thx
"Ådne Hovda" <aadne@.hovda.no> wrote in message
news:eK4kSdRFFHA.392@.TK2MSFTNGP14.phx.gbl...
> Hi
> I've had a MSDE 2000 instance running a couple of months without any
> problems. Now all of a sudden I can only connect to it from localhost.
> When I restart the sql-server using the Service Manager it gives a warning
> in the event log with event-ID 19011. Error code 1355.
> Also I have a bunch of informational events with event-id 3 and something
> about some missing file. I'm not sure if the two event-types have
> something to do with each other, though.
> I believe my problems started after installing a very simple program
> called Dyndns Updater. Looking in the install-log I found that it only
> installs the main exe, some txt-files and a normal run-parameter in the
> registry. To me it seems unlikely that it should interfere with MSDE in
> any way. Uninstalling doesn't help either.
> All other services on my server are working normally from another
> computer.
> I'm kind of stuck here, not wanting to uninstall/reinstall MSDE.
> Any pointers?
> Regards
> Ådne Hovda
> GTR AS
> NORWAY|||Michael C# wrote:
> How about firewalls? Are you running MSDE on Win XP and have you installed
> SP 2 recently? The Windows Firewall will, by default, prevent responses to
> inbound traffic from Ports 1433 (TCP) and 1434 (UDP). If this is your
> problem, try opening up these two ports on your Windows Firewall.
Sorry, I forgot to specify.
We have a pretty simple network of 6 machines, no internal firewalls.
MSDE runs on W2KSP4. I've tried both with and without firewall on the
client-machines that all run XPSP2. It doesn't seem to be a
firewall-related problem. Also, I checked that IP-filtering is turned
off on the server.
Looking deeper into the logs, I found that the program I before
mentioned has definetely nothing to do with it, as I see the same error
(19011) at least two more times, exactly one and two weeks ago, to be
specific.
Ådne|||What is the size of the MDF file, or the LDF ?
If I remember properly, the max size is 2Gb, and if I am still right, the
2Gb apply to the physical file, to the size of the active pages.
Chris
"Ådne Hovda" <aadne@.hovda.no> a écrit dans le message de news:
eFSW7zRFFHA.1564@.TK2MSFTNGP09.phx.gbl...
> Michael C# wrote:
>> How about firewalls? Are you running MSDE on Win XP and have you
>> installed SP 2 recently? The Windows Firewall will, by default, prevent
>> responses to inbound traffic from Ports 1433 (TCP) and 1434 (UDP). If
>> this is your problem, try opening up these two ports on your Windows
>> Firewall.
> Sorry, I forgot to specify.
> We have a pretty simple network of 6 machines, no internal firewalls.
> MSDE runs on W2KSP4. I've tried both with and without firewall on the
> client-machines that all run XPSP2. It doesn't seem to be a
> firewall-related problem. Also, I checked that IP-filtering is turned off
> on the server.
> Looking deeper into the logs, I found that the program I before mentioned
> has definetely nothing to do with it, as I see the same error (19011) at
> least two more times, exactly one and two weeks ago, to be specific.
> Ådne|||Chris V. wrote:
> What is the size of the MDF file, or the LDF ?
> If I remember properly, the max size is 2Gb, and if I am still right, the
> 2Gb apply to the physical file, to the size of the active pages.
The total size of all databases in the instance is 58MB...
This is very strange: All of a sudden it just started working again! I
can now connect from all clients. I haven't changed anything.
Hm. This problem might not be MSDE related after all. Still I'm
wondering what those error messages mean, though.
Anyway, thanks for your help, guys.
Ådne