MSDE Exorcism

Got some problems installing the MSDE I downloaded it from
http://www.microsoft.com/sql/msde/do...s/download.asp
and ran the setup with the following command:
setup SAPWD="testpw" INSTANCENAME="test"
It installs, however, the server is never visible by the SQL Server
Service Manager (although I can type it in manually, but starting it
just tells me It's already started). Nor is it visible by Enterprise
Manager (I installed the client tools to test this). It's not visible
from a Data Link dialog but I can type the name in and connect to it
Plus, here's some additional madness.
From the datalink manager, I can connect only if I use NT integrated
security. If I try something silly like the "sa" and "testpw" which I
passed to setup, I get the error: "Test connection failed because of an
error in initializing provider. Logon failed for user 'sa'. Reason: Not
associated with a trusted SQL Server connection."
Trying to connect from another machine is fruitless.
I've tried numerous things, reversing the parameters passed to setup,
checking the MDAC version 2.7 Re(something or other). Reinstalling,
rebooting, Standing on my head. prayers, Voodoo, stuffed animal
sacrifice. Nothing works.
Any pointers?
-- xavier
Hi Xavier,
Most likely you don't have network protocols enabled. Try running
svrnetcn.exe (from Start>Run) and check that tcp/ip is enabled. If not,
enable it and restart the MSDE/SQL service.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Xavier Pacheco" <xavier@._nospam_xapware.com> wrote in message
news:%23po8a%23ZhEHA.2340@.TK2MSFTNGP11.phx.gbl...
> Got some problems installing the MSDE I downloaded it from
> http://www.microsoft.com/sql/msde/do...s/download.asp
> and ran the setup with the following command:
> setup SAPWD="testpw" INSTANCENAME="test"
> It installs, however, the server is never visible by the SQL Server
> Service Manager (although I can type it in manually, but starting it
> just tells me It's already started). Nor is it visible by Enterprise
> Manager (I installed the client tools to test this). It's not visible
> from a Data Link dialog but I can type the name in and connect to it
> Plus, here's some additional madness.
> From the datalink manager, I can connect only if I use NT integrated
> security. If I try something silly like the "sa" and "testpw" which I
> passed to setup, I get the error: "Test connection failed because of an
> error in initializing provider. Logon failed for user 'sa'. Reason: Not
> associated with a trusted SQL Server connection."
> Trying to connect from another machine is fruitless.
> I've tried numerous things, reversing the parameters passed to setup,
> checking the MDAC version 2.7 Re(something or other). Reinstalling,
> rebooting, Standing on my head. prayers, Voodoo, stuffed animal
> sacrifice. Nothing works.
> Any pointers?
>
> -- xavier
|||And on top of that, if you want to log in with SQL Server authentication,
you have to chance the registry key
HKEY_local_machine\SOFTWARE\Microsoft\MSSQLSERVER\ MSSQLSERVER\LoginMode to 0
(or 2).
You can enable SQL Server authentication when you install MSDE, if you
provide the SECURITYMODE=SQL with setup.exe, together with the sa password.
Jacco Schalkwijk
SQL Server MVP
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:%23Pg%23EVehEHA.1888@.TK2MSFTNGP10.phx.gbl...
> Hi Xavier,
> Most likely you don't have network protocols enabled. Try running
> svrnetcn.exe (from Start>Run) and check that tcp/ip is enabled. If not,
> enable it and restart the MSDE/SQL service.
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Xavier Pacheco" <xavier@._nospam_xapware.com> wrote in message
> news:%23po8a%23ZhEHA.2340@.TK2MSFTNGP11.phx.gbl...
>
|||Greg Low [MVP] wrote:

> Most likely you don't have network protocols enabled.
Bingo! That did it. Thank you very much. . Where do I send the
check? Oh wait, no, you're an MVP, you get no money. Thanks!
- x
Xavier Pacheco
Xapware Technologies Inc
www.xapware.com
Author - Delphi for .NET Developer's Guide
http://www.amazon.com/exec/obidos/ASIN/0672324431/
|||Yup, I had already done that. Thanks for the tip.
- x
Xavier Pacheco
Xapware Technologies Inc
www.xapware.com
Author - Delphi for .NET Developer's Guide
http://www.amazon.com/exec/obidos/ASIN/0672324431/