Cant connect to MSDE on XPSP1

We are writing a setup program for a customer that requires a MSDE
installation.
Using the following flags for the MSDE setup.exe:
SAPWD = "password" SECURITYMODE=SQL
The setup complete successfully, we are restarting the installed machine
(SQL services restarts as well)
But we cannot connect to the MSDE from any enterprise manager
(Enterprise,Developer versions)
This happens only when the MSDE installed on a WindowsXP SP1 machine.
Can someone help us solve this problem?
Thanks,
Shif
Verify that the MSDE is listening on TCP/IP. Check the NT Application logs
after MSDE is started.
If it's only listening on Shared Memory, then only local connections will
succeed.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Hi,
How can i change this option AND in what menu should i look for it ?
Thank
Javier A. Junca Barreto.
Desarrollo de Sistemas
SICyA Software.
Web: www.sicya.com
Mail: desarrollo@.sicya.com
Tel: (57 1) 272 0738
|||MSDE doesn't ship with any utilities. So, you could change this via the
registry.
Check the following registry key on your server:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSDE Name Here
\MSSQLServer\SuperSocketNetLib
Add np and or tcp to the ProtocolList value.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.