Upgrading SQL Express to a paid Edition of SQL for StruxureWare Reports Server

NOTICE

COMPLEX PROCEDURE REQUIRED.
The resolution of this article has many complex steps that may result in unforeseen results if not performed correctly. If you are at all unfamiliar with the requirements, please contact Product Support Services for assistance.

Issue

Upgrading SQL Express to a paid Edition of SQL for StruxureWare Reports Server

Product Line

SmartStruxure Solution

Environment

WebReports

Reports Server

SQLEXPRESS

Cause

SQL Express 2008 R2 is limited to 10 Gb of Storage and 1 Gb of Ram usage. Many sites need a larger, more robust database than this allows.

Resolution

NOTICE: Before you begin, you need to understand the difference between the Instance name and the version of SQL you are running.  The default instance name used in the the SQL Express version of SQL is SQLEXPRESS. This can be changed to anything during installation, but cannot be changed later.  This means that if you upgrade to SQL Enterprise edition, your SQL instance name will still be SQLEXPRESS. The instruction below assumes the instance name is SQLEXPRESS and will be typed in that manner.  
  1. Perform a full backup of the Enterprise Server and Reports Server before beginning any upgrade process. Save these files to an external drive.
  2. Purchase a supported edition of SQL for the revision of StruxureWare Building Operation WebReports that you are using. Please check the data sheet for the release you are using to obtain this information.
  3. Open the Command Prompt and Browse to the location of the installation files for SQL. This should be the folder containing the setup.exe file for the new version of SQL
  4. Enter the Command "setup /ACTION=editionupgrade /INSTANCENAME=SQLEXPRESS /PID=XXXXX-XXXXX-XXXXX-XXXXX"
    NOTE:If you are not using the default instance name, enter the correct instance name in place of SQLEXPRESS. PID is the product ID that came with your installation media. In some cases, this will be left out of the command string and entered later. (setup /ACTION=editionupgrade /INSTANCENAME=SQLEXPRESS)
  5. The SQL Installer will open. After the Setup Suport Rules operation runs, click OK
  6. Click Next
  7. Verify the Product Key and click Next.
  8. Accept the License Agreement and click Next
  9. Ensure that the correct instance of SQL is selected and click Next.
  10. After the Edition Upgrade Rules runs, click Next
  11. Review the Upgrade Summary and click Upgrade
  12. When Complete click Close
  13. Open the SQL Server Configuration Manager using the start menu and verify that the SQL Server (SQLEXPRESS) service is running and that the SQL Server Reporting Services service is running. If either are stopped, right click and select the start option.
  14. You can verify your upgrade is successful by opening your Web Browser and entering the URL "http://localhost/Reports_SQLEXPRESS" You will now see the option to directly edit reports in Report Builder.
  15. Log into the WebReports Interface. Notice that the initial report showing Database usage no longer runs.