Can't connect to MSDE

I've got two machines: 1) SBS 2003 Server, and 2) WinXP Pro.
SQL Server 2000 is installed on the server box, as well as MSDE for the defa
ult
SharePoint and SbsMonitoring databases (SBS setup created those). The
workstation is running MSDE.
The problem is that I can only connect to the workstation's MSDE from the
workstation. EM on the server can see the MSDE instance (the worksation's
machine name appears in the Add SQL Server Registration dialog box), but tha
t's
as far as it can get. When I try to add the instance under a new registratio
n, I
get 'access denied or server doesn't exist' (paraphrased).
I also can't connect via EM to the workstation's MSDE from within a Win98
VirtualPC instance running on the workstation, although I can connect to the
server's instances (both SQL Server and MSDE instances) from within that
instance.
I've compared the property sheets of all the instances to which I can connec
t
from WinXP, and everything seems to be the same. Nothing shows up in my ISA
logs, so I don't think packets are being blocked. Just in case I created a
temporary packet filter allowing all packets from anywhere (risky, I know),
but
it still didn't work. Still nothing in the logs.
Does anyone know what this might be?
TIA,
JeffBy default MSDE doesn't listen to any netlibs. On a regular SQL Server, you
configure this using
"Server Network Utility". I'm not sure whether such comes with MSDE, but tha
t would be the place to
start. The name of the exe is svrnetcn.exe
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jeff Bowman" <write.to.me@.my.addess.com> wrote in message
news:%23Sv%23zABjFHA.3164@.TK2MSFTNGP15.phx.gbl...
> I've got two machines: 1) SBS 2003 Server, and 2) WinXP Pro.
> SQL Server 2000 is installed on the server box, as well as MSDE for the de
fault SharePoint and
> SbsMonitoring databases (SBS setup created those). The workstation is runn
ing MSDE.
> The problem is that I can only connect to the workstation's MSDE from the
workstation. EM on the
> server can see the MSDE instance (the worksation's machine name appears in
the Add SQL Server
> Registration dialog box), but that's as far as it can get. When I try to a
dd the instance under a
> new registration, I get 'access denied or server doesn't exist' (paraphras
ed).
> I also can't connect via EM to the workstation's MSDE from within a Win98
VirtualPC instance
> running on the workstation, although I can connect to the server's instanc
es (both SQL Server and
> MSDE instances) from within that instance.
> I've compared the property sheets of all the instances to which I can conn
ect from WinXP, and
> everything seems to be the same. Nothing shows up in my ISA logs, so I don
't think packets are
> being blocked. Just in case I created a temporary packet filter allowing a
ll packets from anywhere
> (risky, I know), but it still didn't work. Still nothing in the logs.
> Does anyone know what this might be?
> TIA,
> Jeff
>
>|||That did the trick, thanks for the tip! :-)
(BTW, Server Network Utility appears to be installed with Client Tools.)
Tibor Karaszi wrote:[vbcol=seagreen]
> By default MSDE doesn't listen to any netlibs. On a regular SQL Server, yo
u
> configure this using "Server Network Utility". I'm not sure whether such
> comes with MSDE, but that would be the place to start. The name of the exe
is
> svrnetcn.exe
> "Jeff Bowman" <write.to.me@.my.addess.com> wrote in message
> news:%23Sv%23zABjFHA.3164@.TK2MSFTNGP15.phx.gbl...