Re: Wrong MSDE installed

Anytime Greg. Hope it helps.

Any idea what it was being used for? I know a couple of common third party
products use the redistributable MSDE for their DB. (Backup Exec is one)

--
/kj
"Gregg Hill" <bogus@xxxxxxxxxxx> wrote in message
news:OkZagenJHHA.1240@xxxxxxxxxxxxxxxxxxxxxxx
Thank you!

And good night!

Gregg Hill


"kj" <kj@xxxxxxxxxxx> wrote in message
news:O$8rdVlJHHA.4244@xxxxxxxxxxxxxxxxxxxxxxx
Might want to have a look at;

http://support.microsoft.com/kb/320873/en-us

as you have determined to have MSDE not WMSDE.

--
/kj
"Gregg Hill" <bogus@xxxxxxxxxxx> wrote in message
news:%23ujGXpfJHHA.3552@xxxxxxxxxxxxxxxxxxxxxxx
My pleasure. I thought it was funny, too, and it just came to me as I
was typing. And my wife keeps telling me that I'm not funny...HA!

See my reply to David Copeland, coming in a few minutes

Gregg




"kj" <kj@xxxxxxxxxxx> wrote in message
news:eiTB4NfJHHA.4960@xxxxxxxxxxxxxxxxxxxxxxx
I picked up a new client whose previous IT guy was missing a few
letters in between the "I" and the "T" (namely DIO).

Oh that one made my day!! Thanks Gregg.

If he used the distributable version of MSDE you'll need to hack it out
of there. I'm pretty sure that all SBS needs are supplied by Wmsde
which are only included in the various products. (Montioring,
Sharepoint, WSUS).

--
/kj
"Gregg Hill" <bogus@xxxxxxxxxxx> wrote in message
news:ewlonBaJHHA.3264@xxxxxxxxxxxxxxxxxxxxxxx
Hello!

I picked up a new client whose previous IT guy was missing a few
letters in between the "I" and the "T" (namely DIO).

They have an SBS 2003 server, no service pack, and several things do
not work, such as SharePoint companyweb, Monitoring, and the setup
wizard. The wizard dies with a blocking error stating, "SQL Server
2000 needs SP3 for Windows Server 2003 compatibility."

I Googled myself into a hole, but did find where to look in the
registry to find what media was used to install MSDE. It has a version
of MSDE that did NOT come with SBS 2003. The idiot who installed the
SBS 2003 server installed an application called Total Service, and he
installed the MSDE from the Total Service installation CD instead of
using what was in SBS.

Now the setup wizard will not run for me to re-install monitoring.

How can I figure out what version of MSDE is running? I found a
suggestion to run "select @@version" but it does not tell me **where**
to run it. I am a SQL dunce.

How can I install the proper version of MSDE, and if I do, will it
kill the current version? Or should I recommend a complete rebuild of
the server, since I do not know what else this bright-eyed genius has
done?

Thank you for the help!

Gregg Hill











.

Relevant Pages

  • Re: Wrong MSDE installed
    ... They have an SBS 2003 server, no service pack, and several things do not ... to find what media was used to install MSDE. ... How can I install the proper version of MSDE, and if I do, will it kill ...
    (microsoft.public.windows.server.sbs)
  • Re: Wrong MSDE installed
    ... those folders are as you say on my SBS 2003 server that has been ... The setup wizard will not run because of the older version of MSDE. ... If I need to install an MSDE instance I always do it from the MSDE ...
    (microsoft.public.windows.server.sbs)
  • Re: Wrong MSDE installed
    ... what I assumed was the MSDE that comes with SBS. ... and install the demo to see if it works with SBS' install of WMSDE. ... The wizard dies with a blocking error stating, "SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: Wrong MSDE installed
    ... I was testing the install using SP3a to figure it out after SP4 had failed ... left off the server. ... cancelled to change something enough to think it has SP3 so the SBS Setup ... The setup wizard will not run because of the older version of MSDE. ...
    (microsoft.public.windows.server.sbs)
  • Re: Do I install SQL or MSDE
    ... Thanks for using the SBS newsgroup! ... difference of MSDE and SQL. ... In SBS 2003 environment, after you setup SBS 2003 server box successfully, ...
    (microsoft.public.windows.server.sbs)
Loading