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

book

Article ID: 169582

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

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.

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

Cause

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.

Environment

SIM 8.1.5037

Resolution

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:

  1. Open SIM. Open the Altiris Log Viewer.

  2. While monitoring the NS logs, go to "Configure Database" in SIM.

  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.

Attachments