Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Server & Application Monitor (SAM) > Error: Server and Application Monitor requires SQL 2008 or higher

Error: Server and Application Monitor requires SQL 2008 or higher

Created by Tiarnan Stacke, last modified by MindTouch on Jun 23, 2016

Views: 12 Votes: 0 Revisions: 6

Overview

The following error occurs while upgrading to SAM 6.2 or later:

Solarwinds Server & Aplication requires SQL 2008 or higher

Environment

SAM version 6.2 and later

Cause 

The following can cause this error:

  • The Orion Database is hosted on SQL 2005
  • The Database is hosted on SQL 2008 and later, but set to 2005 Compatibility Mode

Resolution

Note: Confirm the SQL Server meets the required SQL Server Version outlined in Requirements for Solarwinds SAM

1. Open the SQL Server Management Studio.

2. Connect to the SQL Server hosting the Orion Database.

3. Expand the Database.

4. Right-click the SolarWinds Orion Database, and then select Properties. 

5. Go to Options in the left pane, Set the Compatibility mode to 2008/2012.

 

 

 

Last modified

Tags

Classifications

Public