We had one of our repository databases (on MS SQL Server) configured in the (Job Server) Server Manager with the SQL port on the database server address. (e.g. sqlserver001.mycompany.com, 1433).
Now this is a perfectly legitimate way to setup SQL server connections and everything worked fine until we discovered an issue. All our Batch Jobs are running fine but this is causing issues when using Real Time Jobs / Access Servers.
When defining our Real Time Service in the DSMC, the service fails to start because the command line prompt in generates doesn’t work with the comma-port suffix of the repository database server. (This is recorded in the error log of the real time service).
So, I changed the Job Server registration in the Server Manager and double checked the AL_MACHINE_INFO table of that repository to ensure that this entry is now no longer containing the comma-port suffix. I’ve also updated the CMC (IPS) entry to be sure and double checked the DSCONFIG.TXT in the DSCOMMONDIR and it also no longer contains the comma-port suffix.
Still, even upon re-creating the Real Time Service, I am still getting this error. Stopping and starting all the services does not help.
Could someone indicate please where Data Services is retaining this job server repository reference (including the comma and port number)??
ErikR 
(BOB member since 2007-01-10)