I’m attempting to install Pods 18.104.22.168 on Windows Server and using a MSSQL database and while trying to activate the plugin, I’m greeted with the error “Cannot setup SQL tables; SQL: DROP TABLE IF EXISTS
wp_STSCpodsrel; Response: Array.” After adding drop permissions for my WordPress user and trying to activate the plugin again, I was taken to the initial WordPress installation page. Being unable to access any pages but the WordPress installation page, I manually disabled Pods in the WordPress database and then tried activating again. Unfortunately, this now seems to cause issues where this error message is the only thing that shows on the entire site until I manually enter the database and remove Pods from the active plugins list again.
I’ve had no issues with Pods in the past, but this is my first time installing it on MSSQL so I’m assuming this is what’s causing the problem. Does anyone have any suggestions as to how I might be able to get this working?