I’m a bit stuck. I have .net6 hangfire server connected to an Azure database server.
When I run a new job on the Development database it works fine.
When I run the same job on the Live database, by simply changing the database name in the config settings, it fails.
There’s no login issue, and another job on the same server works on both Dev and Prod databases.
I also notice that the Server Schema changes on the change of database base - Version 7 Schema becomes Unspecified Schema Version.
My developer says the server is failing before it gets to the SQL Search routine too.
Any thoughts on where I should look for the issue?