Environment
NetIQ AppManager 7.0.x
NetIQ AppManager 8.0.x
NetIQ AppManager 8.2
Situation
Typically the SQL Browser service will allow SQL to listen for connections requesting access to a SQL instance on a non-standard port, however in some environments the SQL Browser service may be disabled. In this case a SQL Client connection Alias needs to be created.
Resolution
Install the SQL Server Client tools on the machine hosting the NetIQ Control Center Command Queue Service.
-
Open SQL Server Configuration Manager.
-
Expand SQL Native Client Configuration
-
Right click on the right pane
-
Choose New Alias
-
Create a descriptive Alias name
-
On the Port No row enter the port which SQL is listening
-
On the Server row enter the name of the Server that hosts the NQCCDB database
-
Click ok.
-
Start the NetIQ Control Center Command Queue service
Cause
This occurs because the SQL Server Browser service is disabled and is unable to be enabled.