MSDE over the network

Please help! I've had this problem for FOREVER. It's driving me batty.
I'm installing MSDE in a networked environment. I'm using SQL-DMO to find all
instances of MSDE on the network. *Usually*, this works great.
Unfortunately, sometimes MSDE instances refuse to advertise on the network.
I can't register them in Enterprise Manager or see them with SQL-DMO. I'm
using setup.exe to install these instances, and I'm setting
DISABLENETWORKPROTOCOLS=0. I've run the svrnetcn.exe program, and each
vanished instance is in fact listening via TCP/IP and Remote Procedure Calls.
I've added each instance as an exception in the Windows Firewall on XP SP2.
Each disappeared instance has in fact been started. Local applications can
see these vanished instances, but networked applications cannot. There are no
other firewalls or packet filtering on the network. I'm behind a Microsoft
Wireless Base Station Router. Am I missing something?
This problem is about to drive me insane. I'm using the exact same
installation program and parameters to setup.exe, but some instances just
don't want to play on the network. Any help would be greatly appreciated.
Thanks in advance.
Rob Reagan
rob at digitallabsinc.com
Are any of the MSDE instances installed on XP SP2? If the MSDE instance does
not have SP3 installed then XP will block MSDE from broadcasting its status.
You can see warnings about this in the system event log. This is the same
with Windows Server 2003.
Jim
"Rob Reagan" <RobReagan@.discussions.microsoft.com> wrote in message
news:ED94255F-732F-4DFF-B994-CEAD94B90354@.microsoft.com...
> Please help! I've had this problem for FOREVER. It's driving me batty.
> I'm installing MSDE in a networked environment. I'm using SQL-DMO to find
all
> instances of MSDE on the network. *Usually*, this works great.
> Unfortunately, sometimes MSDE instances refuse to advertise on the
network.
> I can't register them in Enterprise Manager or see them with SQL-DMO. I'm
> using setup.exe to install these instances, and I'm setting
> DISABLENETWORKPROTOCOLS=0. I've run the svrnetcn.exe program, and each
> vanished instance is in fact listening via TCP/IP and Remote Procedure
Calls.
> I've added each instance as an exception in the Windows Firewall on XP
SP2.
> Each disappeared instance has in fact been started. Local applications can
> see these vanished instances, but networked applications cannot. There are
no
> other firewalls or packet filtering on the network. I'm behind a Microsoft
> Wireless Base Station Router. Am I missing something?
> This problem is about to drive me insane. I'm using the exact same
> installation program and parameters to setup.exe, but some instances just
> don't want to play on the network. Any help would be greatly appreciated.
> Thanks in advance.
> Rob Reagan
> rob at digitallabsinc.com
>
|||YOU ARE THE MAN! Thanks so much for that response.
"Jim Young" wrote:

> Are any of the MSDE instances installed on XP SP2? If the MSDE instance does
> not have SP3 installed then XP will block MSDE from broadcasting its status.
> You can see warnings about this in the system event log. This is the same
> with Windows Server 2003.
> Jim
> "Rob Reagan" <RobReagan@.discussions.microsoft.com> wrote in message
> news:ED94255F-732F-4DFF-B994-CEAD94B90354@.microsoft.com...
> all
> network.
> Calls.
> SP2.
> no
>
>