How to configure the CQS service to connect to a non standard SQL port

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.

1. Open SQL Server Configuration Manager.
2. Expand SQL Native Client Configuration
3. Right click on the right pane
4. Choose New Alias
5. Create a descriptive Alias name
6. On the Port No row enter the port which SQL is listening
7. On the Server row enter the name of the Server that hosts the NQCCDB database
8. Click ok.
9. Start the NetIQ Control Center Command Queue service