Start a conversation

SQL 2005 Express support has ended (SQL 2008 R2 upgrade)

Extended support for SQL Server 2005 ended on April 12, 2016. If you are running SQL Server 2005 after this date you will no longer receive security updates and technical support.
This doesn't mean SQL will stop working. The last Service Pack update was released over a year ago and with that update SQL 2005 runs fine on Windows 7/8/10. However, to be safe we recommend an update to SQL 2008 Express R2 which takes less than 10 minutes to install (after download). This update also increases the storage limit from 4G in 2005 Express to 10G in 2008 Express.

Contact a DRS Support for assistance or download the installer below and follow these instructions.

1. Backup your RMS database on your server using backup option in Administrator or Manager, Utilities.

2. Close RMS on all PCs (Administrator, POS, Manager). Close all add-ins accessing the RMS database.

3. Run the SQL 2008 R2 installer on server, select upgrade option (not install), select current SQL instance, and follow the prompts to completion.

4. Run Store Operations Administrator, File, Connect, enter SQL password, Database, Reindex (wait for completion), then Database, Check (wait for completion), then File, Configuration, Test Database, OK, then close Administrator.

5. Run Windows Updates (if Windows 7/8) and install any SQL updates found.

Note: Repeat steps on any other PCs where SQL 2005 is installed (with a local database such as one for offline terminal mode) making sure to upgrade the local instance, not install a new instance. If you are not sure what this means, contact a DRS Support before proceeding.

SQL 2008 Express R2 download installer (x86):
This is the ONLY recommended version for use with RMS on Windows 7/8/10.
All other editions have reported problems.

IMPORTANT: DRS does not support RMS or DRS add-ins on SQL versions higher than 2008 R2.

Choose files or drag and drop files
Was this article helpful?
  1. Dave J

  2. Posted
  3. Updated