There are a couple of likely causes, search Stack Overflow for “EntityStates.Modified”, this might be required in your case. For me this was different, the cause was a table that didn’t have a primary key. Our code used to work then stopped working when we moved to Azure SQL Server. We were making a change... » read more
Azure .NET web apps connecting to an AWS SQL database kept throwing up this error sporadically, seemingly without any pattern. The full message was this: An unhandled exception occurred while processing the request. Win32Exception: An existing connection was forcibly closed by the remote host. Unknown location.SqlException: A connection was successfully established with the server, but... » read more
There’s a bunch of info on this already out there, but this is pretty specific – we have an existing set of Microsoft SQL Server databases on an AWS instance and I needed to connect to them in a new WebApp service. Here’s how I did it. This assumes you have an Azure account all... » read more
After our server people did some MS SQL database restores from some old backups to find some data, some .NET websites we had on the server started showing an error. (note I couldn’t see the error and had to disable custom errors from remote only, see here http://tech.ralpharama.co.uk/1/viewing-errors-remote-machine-after-sql-restores-broke-sites Server Error in '/' Application. Cannot open database... » read more