Specify alternative ports for Microsoft SQL Server and IBM DB2

Microsoft SQL Server and IBM DB2 database servers can be configured to listen on a different port than the default one (1433 for Microsoft SQL Server, 50000 for IBM DB2). This different port number needs to be specified in Ivanti Automation from the moment a different port number is specified on the database server.

  • When using Microsoft SQL Server, separate server name and port number with a comma (,), as in: <dbserver>, <port number>.
  • When using IBM DB2, separate server name and port number with a colon (:), as in: <dbserver>: <port number>.

New environments

In the Datastore Wizard, when selecting a database server, also specify the port number in the Server field in the format as shown above.

Existing environments

  1. At Setup > Database, also specify the port number in the Database server field in the format as shown above.
  2. Click Connect.
  3. Perform a repair of all Dispatchers.

For IBM DB2 database server, you can only connect to an existing database.