SBS 2003 Standard to Premium Upgrade -- HELP!!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Problem:
I just installed SQL2000 Standard. Whenever I try to use enterprise
manager
or access the Computer Management console I get the following error:

"Snap-in failed to initialize. Name: Microsoft SQL Enterprise Manager
CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}"

I am currently running SBS2003 Standard. I am trying to get ready for a

Microsoft CRM 3.0 installation, which requires SQL 2000 standard. I
had
recently got a copy of SBS 2003 Premium, which includes SQL. I read
somewhere
that the only difference between the two editions was the Premium
Technologies CD which includes SQL and ISA. I used this CD to install
SQL on
to my system.

The installation of SQL completed without any errors, however, I get
the
error previously mentioned whenever I try to open Enterprise manager or
the
Computer Mangement console.

Also, I am unable to install Service Pack 4 for SQL as the installation

never completes. In the middle of the installation it installation
wizard
dissappears without a trace. There is no acknowledgement that the
intallation
completed or finished. When I try to rerun the setup, it says another
installation is already running, presumably the one that dissappeared.

Can anyone help me with this problem???

.



Relevant Pages

  • KB948110 causes server breakdown
    ... I confirmed installation of the KB948110 update for SQL. ... problem was that POP3 Connection Manager service stopped working. ... SQL instance was not starting for Sharepoint and I ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... SQL Server 2005 failover cluster has been installed? ... drive of a SQL Server 2005 failover cluster installation? ...
    (microsoft.public.sqlserver.clustering)
  • Re: SBS 2003 Windows Update Question
    ... In lieu of fixing Microsoft, though, a CD-R copy of the installation ... media ain't a bad idea. ... the client has SQL 2000 installed but no media for it. ... and install SBS 2003 Premium with SQL 2000. ...
    (microsoft.public.windows.server.sbs)
  • Re: error while installing a new named instance
    ... SQL has issues with cluster installs when you have a login open on any of the remote nodes. ... And yet another is that teh remote node may not be able to "see" the installation source. ... Error Code: 0x80070002 ... Bootstrap\LOG\Files\SQLSetup0009_CLSNODE1_.NET Framework 2.0.log" to cab file ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQLSetup0001_xxxxxx_Core(Local).log
    ... Windows Error Text: User cancelled installation. ... Source File Name: datastore\cachedpropertycollection.cpp ... SQL Server 2005 Setup requires administrator permissions on every ... update permissions for the account ...
    (microsoft.public.sqlserver.clustering)