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

Products

• IT Management Suite

Issue/Introduction

The customer launched SIM (Symantec Instalaltion Manager) while trying to upgrade to ITMS 8.1 and he sees at the top of it a message saying:

"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 customer checks his Console he is able to connect just fine to his SQL server.

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

Environment

Upgrade to ITMS 8.1
SIM 8.1.4504

Cause

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

Resolution

Update 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.MyDomain.com

 

Additional Information

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