How to link your Scheduling Service if a database copy doesn't correct it automatically?

After copying a production database to an acceptance database, depending on the script used after restoring the database, it is possible to overwrite the Scheduling Service settings with wrong keys / settings.

  1. What is a failsafe way to correct your Scheduling Service if this happens?

  2. Right now, my Scheduling Service is disconnected (according to the application, not sure whether this is the case on the server) and every attempt at reconnecting to the Scheduling Service gives me the message “Error while registering to the scheduling service: You are not authorized”. What can I do to fix this?

There is a way to force re-pairing.
Simply remove the false information (all 3 certificates). Then click on the Generate key pairs button again to create new private and public keys for yourself (or enter the ones you have backed up). Click the “Get certificate from scheduling service” button to get the correct certificate. Then hit save and re-pair your application.

I have tried this already, without success. I am able to get a new certificate, but after saving the Pair button still gives me the “Unauthorized” message.

After correcting the certificates, use the “Change URL” button and choose the option “Restored (from another database)”
Also make sure your url is correct (http://localhost/applicationname/Services/NovuloSchedulingServiceWebservice.asmx)
Ususally this does the trick.

I’m running to a similar problem. This conversation starts with a lot of prior knowledge on how and where to generate the keys. Is there any step by step documentation available to get to point of the buttons mentioned in this thread?

Hey Gertjan,

The quickest way to restore the connection to the Scheduling service after a database restore is as follows:

  1. Open the application where the database was restored and login
  2. Go to Application maintenance → Settings → Scheduling Services
  3. Open the default Scheduling service
  4. Click on the button ‘Change URL’
  5. Choose the option ‘Restored (database of other application)’ as the reason
  6. Change the URL to the correct URL (usually only requires changing the application name)
  7. Press OK to save your changes

This should automatically update the certificates mentioned by Helena.