Upgrading SQL Express to a paid Edition of SQL for EcoStruxure Reports Server
EcoStruxure Building Operation
- Reports Server
- SQL Express
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.
- Perform a full backup of the Enterprise Server and Reports Server before beginning any upgrade process. Save these files to an external drive.
- 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.
- 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
- 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)
- The SQL Installer will open. After the Setup Support Rules operation runs, click OK
- Click Next
- Verify the Product Key and click Next.
- Accept the License Agreement and click Next
- Ensure that the correct instance of SQL is selected and click Next.
- After the Edition Upgrade Rules runs, click Next
- Review the Upgrade Summary and click Upgrade
- When Complete click Close
- 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.
- 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.
- Log into the WebReports Interface. Notice that the initial report showing Database usage no longer runs.