MSDE 2000

Hi all,
I was trying to install MSDE 2000 in a Windows 2000 server that joined AD as
a member server. I could install it from the SQL 2000 server CD but cannot
use the Service Pack 3 or 3a downloaded from Microsoft's website to perform
the upgrade. I keep getting an error in the event viewer saying that MS SQL
Desktop Engine -- installation operation failed. The event ID is 11708 and
the source is MsiInstaller. Does anyone has experience in performing upgrade
of this kind? Or you have idea of what the problem might be?
Also, does anyone know how to check the version of MSDE 2000 being
installed? I tried to find it from MS knowledge Base but cannot find
anything about it.
Thanks in a million.
EdHi!
Here is text from the http://www.microsoft.com/sql/downloads/2000/sp3.asp
site:
--
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) and SP3a
Users who have an existing instance of MSDE 2000 must know how their
instance of MSDE 2000 was installed to know how to patch it. In particular,
you must know the original package name for your instance of MSDE 2000. To
determine the original package name, see the article How To Identify Which
MSI File Was Used for an Existing MSDE Installation in the Microsoft
Knowledge Base.
If the original package name for your instance was SqlRun01.msi through
SqlRun16.msi, download the file SQL2KdeskSP3.exe to apply SP3a.
If the original package name for your instance was Sample.msi or
SampleUpg.msi, see the article How To Create Patch Files for the MSDE 2000
Sample.msi File.
If your original package name indicates the instance of MSDE 2000 was
installed by the Microsoft .NET SDK or Microsoft Application Center, see
Microsoft Products that include MSDE 2000 for instructions.
If the product code associated with your instance of MSDE 2000 is not
listed, then the instance was installed by the setup utility of an
application. You cannot use SQL2KdeskSP3.exe to apply SP3 to such MSDE
instances. Instead, you must get a patch file from the company who wrote the
application. If the application came from a company other than Microsoft,
you must contact that company for a patch file. If the application came from
Microsoft, refer to Microsoft Products that include MSDE 2000 which lists
the MSDE applications from Microsoft (this page will be updated with
information about how to upgrade these instances of MSDE 2000).
--
I guess you might have problems because you don't have he correct file to
install.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Ed" <edmond620@.hotmail.com> wrote in message
news:ucau%230WDEHA.3568@.tk2msftngp13.phx.gbl...
> Hi all,
> I was trying to install MSDE 2000 in a Windows 2000 server that joined AD
as
> a member server. I could install it from the SQL 2000 server CD but cannot
> use the Service Pack 3 or 3a downloaded from Microsoft's website to
perform
> the upgrade. I keep getting an error in the event viewer saying that MS
SQL
> Desktop Engine -- installation operation failed. The event ID is 11708 and
> the source is MsiInstaller. Does anyone has experience in performing
upgrade
> of this kind? Or you have idea of what the problem might be?
> Also, does anyone know how to check the version of MSDE 2000 being
> installed? I tried to find it from MS knowledge Base but cannot find
> anything about it.
> Thanks in a million.
> Ed
>