Remote MSSQL Server Connection Issues

[bgbearcatfan]

I will start out by saying the latest release for the enterprise version appears to be working very well. Our issue is trying to run this release on a clustered Microsoft SQL instance that is on a separate system, instead of using a bundled Microsoft SQL express edition on the same box as the web apps.

When making adjustments to the config file to change "localhost\sqlexpress", to remoteserver\instance, the page loads and allows us to login and use most functions, but not all. And on the home screen when you first login, you get a perpetual spinning/loading circle. When i opened up the browser developer tools, we are seeing this:

1. GET http://myremotehost:5001/api/assessmentsforuser
2. Cross-Origin Request Blocked: The Same Origin Policy disallows reading the remote resource at http://myremotehost:5001/api/assessmentsforuser. (Reason: CORS header ‘Access-Control-Allow-Origin’ missing). Status code: 500.
3. Unable to get Assessments for myemail@mydomain.com: Http failure response for http://myremotehost:5001/api/assessmentsforuser: 0 Unknown Error

We've tried adding lines to the web.config files for, "Access-Control-Allow-Origin" value="*", but that just results in CORS conflicts. When setting the sql instance back to the express edition that resides on the same box with the web app, everything is functional again. It seems like something is hard-coded for localhost somewhere that I can't find.

Appreciate any guidance that you can provide.

Thanks!