Upgrading SQL Express to a paid Edition of SQL for StruxureWare Reports Server
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.
- 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 StruxureWare Building Operation WebReports that you are using. Please check the data sheet for the release you are using 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 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)
The SQL Installer will open. After the Setup Suport Rules operation runs, click OK
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.
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.
Log into the WebReports Interface. Notice that the initial report showing Database usage no longer runs.