Error: You have selected an unsupported SQL instance of Microsoft SQL Server for currently selected Platform.

Products

• IT Management Suite

Issue/Introduction

While trying to run a repair or an upgrade via Symantec Installation Manager (aka SIM), the following message is displayed:

You have selected an unsupported SQL instance of Microsoft SQL Server for currently selected Platform. Select a different server in order to continue.

Environment

SIM 8.1.5037

Cause

Working as expected. SIM has some validation checks to verify supported versions of SQL Server. See the following KB article for a list of SQL Server versions are supported depending on the SMP version that you are trying to install or upgrade:

 

Resolution

In this particular scenario, the repair was on ITMS 7.5 SP1 but this would be the same for any ITMS version. In this case, the SQL Server was upgraded to a version that was not supported for the ITMS version being used.

In order to determinate and validate what SIM sees as the currently SQL Server version installed so you can compare against the Support Matrix of Symantec Management Platform and Altiris Solutions, please try the following:

1. Open both the SIM. and the Altiris Log Viewer.

2. While monitoring the NS logs, go to "Configure Database" in SIM as shown here:
   
   

3. You should see some entries like this in the NS logs:

   Wizard (in mode 'ReconfigureDatabase') navigating Next to step 'ShowDBSettingsView'

   VerifyConnection: Server: YourSMPserver.mydomain.com

   VerifyConnection: AuthType: Windows

   VerifyConnection: Detected Server: SQL2014

   VerifyConnection: Detected Version: 12.0.5203.0

   VerifyConnection: Detected Type: SQLServer2014

4. With those NS logs entries, you should be able to validate what version of SQL Server SIM is detecting and now you should be able to compare if it is actually a supported version or not.