Technical FAQs

StruxureWare Power Monitoring 7.0.1: SQL Server 2005 Express Edition Upgrade Guide

Goals and Symptoms

SturxureWare Power Monitoring requires a compatible version of SQL Server. If an existing ION Enterprise is using SQL Server 2005 Express on a compatible operating system, it is possible to replace SQL Server 2005 Express with a supported version of SQL Server. This is a prerequisite for an upgrade from ION Enterprise to StruxureWare Power Monitoring 7.0.1

Facts and Changes

Causes and Fixes

The attached pdf describes how to 'upgrade' your SQL Server version from SQL Server 2005 Express to SQL Server 2008 R2. This is only applicable for single server, stand-alone systems. It requires you to uninstall SQL Server 2005 Express, and then install a new instance of SQL Server 2008 R2.
Although an in-place upgrade from SQL Server 2005 Express to SQL Server 2008 R2 is supported by Microsoft, we do not recommend this approach. We recommend the procedure described in the attached pdf. There is an additional zip file attached to this article that includes files that will be needed during the procedure described in the attached pdf file.

Attachments

(Removed File URL: 207643_2AE2/forxpressupg.zip)(Removed Image URL: /PubResEXPORT.nsf/2b87ee90be777fc085257c28006ee4ef/64879eaae65b842ec1257a620010bdef/fl_block_5/0.14C?OpenElement&FieldElemFormat=gif)(Removed File URL: 207643_2AE2/SPM701-SqlExpress2005UpgradeGuide.pdf)(Removed Image URL: /PubResEXPORT.nsf/2b87ee90be777fc085257c28006ee4ef/64879eaae65b842ec1257a620010bdef/fl_block_5/0.68E?OpenElement&FieldElemFormat=gif)

(Removed Image URL: /PubResEXPORT.nsf/2b87ee90be777fc085257c28006ee4ef/64879eaae65b842ec1257a620010bdef/fl_block_5/0.42A6?OpenElement&FieldElemFormat=gif)

Last Revised: August 21, 2012

Internal

Document Change History

Date and Initials	Comments
2012-May-22 DRM	* Altered distribution level to public.

(Removed Image URL: /PubResEXPORT.nsf/2b87ee90be777fc085257c28006ee4ef/64879eaae65b842ec1257a620010bdef/fl_block_5/0.763E?OpenElement&FieldElemFormat=gif)

Last Revised: August 17, 2012

Public

Legacy KB System (APS) Data: RESL207643 V9.0, Originally authored by MaLi on 03/13/2012, Last Edited by JaMc on 08/22/2012
Related ranges: Power Monitoring 7.0