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

[Product_Support]

Issue

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

Product Line

EcoStruxure Building Operation

Environment

• WebReports
• Reports Server
• SQL Express

Cause

SQL Express 2008 R2 (for example) 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 beginning, it is important to understand the difference between the Instance name and the version of SQL 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 when upgrading to SQL Enterprise edition, the SQL instance name will still need to 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 EcoStruxure Building Operation WebReports being used. Please check the data sheet for the release 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  not using the default instance name, enter the correct instance name in place of SQLEXPRESS. PID is the product ID that came with the 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 Support 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. Verify the upgrade is successful by opening a Web Browser and entering the URL "http://localhost/Reports_SQLEXPRESS" It should now be possible to 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.