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"
Upgrade to ITMS 8.1
SIM 8.1.4504
It was necessary to add the FQDN information for the SQL Server in order to connect via SIM.
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
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" "