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
It may be that you don't have any network protocols enabled for MSDE. Run
the tool svrnetcn.exe (you'll find it in C:\Program Files\Microsoft SQL
Server\80\Tools\Binn) and check to make sure that you have the necessary
protocols enabled.
Jim
"Shif Arad" <shif@.inter.net.il> wrote in message
news:Om8nd%23vJEHA.2604@.tk2msftngp13.phx.gbl...
> 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
>
Tuesday, February 14, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment