MSDE Exorcism

From: Xavier Pacheco (xavier_at__nospam_xapware.com)
Date: 08/19/04 

Date: Wed, 18 Aug 2004 20:50:00 -0700

Got some problems installing the MSDE I downloaded it from

http://www.microsoft.com/sql/msde/downloads/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

Relevant Pages

  • Re: Inherited botched w2k3 SBS install, is this recoverable?
    ... continue installing rest of the SBS Components. ... Server Setup. ... Microsoft Windows Small Business Server Setup, ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: Fail to install MSDE (log attached)
    ... trouble getting MSDE installed. ... Setup failed to configure the server. ... file located in the install directory where you are installing MSDE. ...
    (microsoft.public.sqlserver.msde)
  • Re: SBS Setup Error
    ... Installing over the top of an existing installation, may or may not resolve a poorly installed setup. ... Send via Windows Mail on Vista Ultimate connected to SBS 2003 R2 ... I have reinstalled the SBS server over the top of the old version. ...
    (microsoft.public.windows.server.sbs)
  • Re: Corrupt Exchange installation
    ... Configured IP address and DNS ... Promoted server to global catalog ... Setup failed while installing sub-component System Attendant ...
    (microsoft.public.windows.server.sbs)
  • RE: Cant connect in to server!
    ... Cant access remote web workplace from outside server, ... Installing RRAS returned OK ... > address 3389 on the command line and paste the results to the newsgroup. ... > Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)