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

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

book

Article ID: 164870

calendar_today

Updated On:

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" "

Attachments

Symantec_Install_Package_2018_07_19_114803_SIM_8_1_6010.zip get_app
Symantec_Install_Package_2018_07_19_114803_SIM_8_1_6010.txt get_app
Symantec_Install_Package_2018_07_19_114803_SIM_8_1_6010.exe.zip get_app