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.
You have selected an unsupported SQL instance of Microsoft SQL Server for currently selected Platform. Select a different server in order to continue.
SIM 8.1.5037
Working as expected. SIM has some validation checks to verify supported versions of SQL Server. See HOWTO9965 for the list of what SQL Server versions are supported depending on the SMP version that you are trying to install or upgrade.
In this particular scenario, the repair was on SMP 7.5 SP1. However, the SQL Server was upgraded to a version that was not supported for the SMP version being used (such as SQL Server 2014 which is not supported in SMP 7.5 or 7.5 SP1).
In order to determinate and validate what SIM sees as the currently SQL Server version installed so you can compare against the ITMS Support Matrix ( HOWTO9965 ), please try the following:
Open SIM. Open the Altiris Log Viewer.
While monitoring the NS logs, go to "Configure Database" in SIM.
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
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.