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>.
In the Datastore Wizard, when selecting a database server, also specify the port number in the Server field in the format as shown above.
- At Setup > Database, also specify the port number in the Database server field in the format as shown above.
- Click Connect.
- Perform a repair of all Dispatchers.
For IBM DB2 database server, you can only connect to an existing database.