MSDE on WinXP Pro SP2 joined to a domain

Hi,
I have a problem that I cannot find a resolution to.
Recently, I got a laptop and I installed WinXP Pro SP2 on it.
I did this at home so was not near my office domain so I temporarily setup
the laptop as a workgroup computer instead of joining the domain.
Once installed, I then installed MSDE2000RelA.
Everything was working fine.
Then I took the laptop to work, joined the domain, and now MSDE can no
longer connect. All I get in the system tray is a computer tower icon with a
white circle on it. Hovering over that pops up "Cannot connect \\". There
should be a green arrow in the circle when services start.
I have tried uninstalling, re-installing, changing user permissions in group
policy for the guest account? - all sorts of things, but nothing fixes this
issue - and I desperately need MSDE to work on the laptop.
I think it has something to do with the laptop being on the domain, but I
don't know (and that doesn't really make sense to me either).
Can anyone point me to a solution?
Cheers,
Rob
hi Rob
Did u set DISABLENETWORKPROTOCOLS=0 parameter while setup?
by default the setup will take 1 (means disable).
just check out
Dil
|||Ah, no I didn't!
Do I have to reinstall or can I update a previous installation with this
setting?
Cheers,
Rob
|||hi Rob,
RobGT wrote:
> Ah, no I didn't!
> Do I have to reinstall or can I update a previous installation with
> this setting?
please run the Server Network Utility (svrnetcn.exe) to enable the desired
network protocol..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Perfect, thankyou.
It appears to now be working fine.
Shame I found it so difficult to locate this information (I searched online
for ages before coming here to ask the question!)
Thanks a million for resolving this so quickly for me!
Cheers,
Rob