I've created the dll and registered the service type but while adding the service instance for the broker interact with MYSQL database we got error " Object reference not set to an instance of an object. Open connection".
Anyone Can please help on this?
FYR herewith attached the Screen shot.
You might need to debug the code while you are creating the service instance to see what the issue is. If you open the Visual Studio project for the MYSQL service broker on your K2 server and attach to the K2 server process you should be able to set break points and debug the code after you click the Next button.
Please check if anyone of this might be a bad actor:
1. Use service account as authentication mode and try register
2. The account you're trying to impersonate might not have the required authorization in the db
I hope this info is helpful.