You have to unregister IQ Bot from the Control Room if the IQ Bot URL changes because of installation or uninstallation of IQ Bot, or when a load balancer is added.

1. Using the sysadmin role, run two separate SQL queries in different databases.
2. Run the first SQL query in the Control Room database to delete the following data:

   • DELETE FROM [CRDB-NEW].[dbo].[APP_USER] WHERE [type]='IQBOT'

   • DELETE FROM [CRDB-NEW].[dbo].[USERS] WHERE user_type='APP'

   • DELETE from dbo.ACTIVEMQ_ACKS

   • DELETE from [CRDB-NEW].dbo.ACTIVEMQ_ACKS

   • DELETE from dbo.ACTIVEMQ_MSGS

3. Run the second SQL query in the IQ Bot configuration database to delete the following data:

   • DELETE FROM [Configurations].[dbo].[Configurations] where [key]='controlRoomVersion'

   • DELETE FROM [Configurations].[dbo].[Configurations] where [key]='appRegistered'

   • DELETE FROM [Configurations].[dbo].[Configurations] where [key]='controlRoomUrl'

   • DELETE FROM [Configurations].[dbo].[Configurations] where [key]='appId'