Getting "The SQL server, configured during installation, not accessible. Symantec Installation Manager functionality is limited"

Products

• IT Management Suite

Issue/Introduction

Then SIM (Symantec Installation Manager) is launched while trying to upgrade to a newer version of ITMS and the following message is seen:

"The SQL server, configured during installation, not accessible. Symantec Installation Manager functionality is limited"

which causes SIM not to allow the customer upgrade or install. However, when the SMP Console is accessed you can connect just fine to the SQL server.

Environment

ITMS 8.x
SIM 8.x

Cause

It was necessary to add the FQDN information for the SQL Server in order to connect via SIM.

Resolution

Updated the following registry key 'SqlServerName' under HKLM>Software>Altiris>AIM>Configuration>NsConfiguration.

In this particular case the SQL server name was SQL-W2K12R2-01 and we had to add SQL-W2K12R2-01.example.com

Additional Information

199264 "Symantec Installation Manager (SIM) is experiencing problems connecting to the database. Getting "The SQL server, configured during installation, not accessible. Symantec Installation Manager functionality is limited" "