000037332 - RSA Archer Installer failed with "Invalid Database Version" window

Document created by RSA Customer Support Employee on Apr 12, 2019
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000037332
Applies ToRSA Product Set: Archer
RSA Product/Service Type: RSA Archer (On-Premise)
RSA Version/Condition: 6.5
 
IssueError message received when SQL has been upgraded already. Install fails to continue.

Error Message: The RSA Platform is only compatible with SQL Server 2016 SP1 or Greater. Please ensure the database you have selected is a SQL Server SP1 database or greater and configured at Compatibility level 130 or greater.

User-added image
CauseWhen Microsoft SQL Server is upgraded in place, the compatibility level remains that of the previous version. This must be changed by a DBA with full admin rights. To check the SQL version, use the command on the Master database (or choose very top).

Select @@version

If this query returns version SQL 2016 SP1 or later, go to SQL Server manager and check the compatibility level. To do this, right-click on the instance database, choose properties, then options. Then look at the compatibility level. If it is not SQL 2016 SP1 or higher - change that. If it is dimmed out, you will need a DBA with full Admin to change it.



 

 
 
ResolutionChange this for both the instance and the config databases. Be sure to set the compatibility mode to 130 or higher. (That number will be in parenthesis next to the version)
(This screenshot is from SQL 2017.)

User-added image

Attachments

    Outcomes