MOM 2005 SP1 – upgrading SQL server from 2000 to 2005


 

Upgrading from SQL 2000 to SQL 2005 to support MOM 2005 SP1:

1. Backup your MOM SQL server databases (OnePoint and Systemcenterreporting). Backup your Microsoft SQL Server Reporting Services databases.
2. Backup the SRS encryption key.

3. Stop the MOM Service on all management servers.

4. Upgrade the database servers and reporting servers to SQL 2005.

5. Upgrade the servers with SQL SP1 or greater.

6. Finally you need to apply the following hotfixes to complete the upgrade process:

File Name: MOM2005-SP1-KB913812-X86-ENU.MSI
Knowledge Base (KB) Article: KB913812
Overview: Unable to discover computers in AD after upgrading to .NET Framework 2.0


http://www.microsoft.com/downloads/details.aspx?FamilyId=F53F1EF3-A7A0-4C45-AEFC-7C1EC5DCCAA6&displaylang=en

This updates the following files. If your files are newer – no need to apply:

 

File name

File version

File size

Date

Time

Dasclient.dll

5.0.2911.31

101,104

08-Feb-2006

19:32

Dasclient.tlb

Not applicable

5,720

08-Feb-2006

19:32

Discoveryengine.dll

5.0.2911.31

109,296

08-Feb-2006

19:32

Nativewrappers.dll

5.0.2911.31

33,008

08-Feb-2006

19:32

Updatemom.exe

Not applicable

118,784

18-Oct-2004

13:52

Utils.dll

5.0.2911.31

150,256

08-Feb-2006

19:32

 

File Name: MOM2005-SP1-KB915785-X86-ENU.msi
Knowledge Base (KB) Article: KB915785
Overview: MOM 2005 SP1 Hotfix for malformed XML error message with SQL 2005 Reporting Server


http://www.microsoft.com/downloads/details.aspx?FamilyId=E5FC1871-1286-461D-BFCD-D32CF426E8C3&displaylang=en

The above is run on the DW server – it updates the database.

File Name: MOM2005-SP1-KB913801-X86-ENU.MSI
Knowledge Base (KB) Article: KB913801
Overview: MOM 2005 SP1 Hotfix for deadlocks with SQL 2005
http://www.microsoft.com/downloads/details.aspx?FamilyId=596710CC-CF17-476F-A30C-8973612F4AC7&displaylang=en

This updates the following files. If your files are newer – no need to apply:

 

File name

File version

File size

Date

Time

Dasserver.dll

5.0.2911.30

4,041,968

04-Feb-2006

01:20

 

7. After the required hotfixes are installed without error launch the MOM Administrator Console and verify that it is operating as expected.

Comments (0)

Skip to main content