Issue:

Database was a restored backup from another machine. “Connection to underlying database could not be established.” ERROR messages occur.

 

Resolution:

When database was restored, older credentials were not compatible with the new mssql instance. It is necessary to remove and readd the user altogether from the db and sql instance.