on Apr 12, 2019Article Content
| Article Number | 000037332 |
| Applies To | RSA Product Set: Archer RSA Product/Service Type: RSA Archer (On-Premise) RSA Version/Condition: 6.5 |
| Issue | Error 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.  |
| Cause | When 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. |
| Resolution | Change 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.)  |