How to set up SQLServer database agent with dynamic port range

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

How to set up SQLServer database agent with dynamic port range

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

Resolution

Detailed Description and Symptoms

When setting up a new Database Agent, some MS SQLServer instances are set as named instances so ports are set dynamically. Per the documentation you would normally set the DB name and port number like so: dc2uc4:1433

However, with a dynamic port this doesn't work.

Solution

?Named instances can be handled for the server name like the following:
dc2uc4;instanceName=dc2uc4;integratedSecurity=true

The SQL Server browser service must be running as well.

You can also specify other jdbc properties in the server field of the sql job.