Managed to figure out what was wrong, the SQL database was the cause, it turned out to be a problem with the spn.
The spn was registered with service account and I was getting SSPI error
Reset the SPNs and set the SQL startup account to Local System and it had worked
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.