Novell Home

My Favorites

Close

Please to see your favorites.

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

This document (7012576) is provided subject to the disclaimer at the end of this document.

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

Cause

This occurs because the SQL Server Browser service is disabled and is unable to be enabled. 

Disclaimer

This Support Knowledgebase provides a valuable tool for NetIQ/Novell/SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.

  • Document ID:7012576
  • Creation Date:07-JUN-13
  • Modified Date:07-JUN-13
    • NetIQAppManager

Did this document solve your problem? Provide Feedback