The issue: I just restored a database backup file from somewhere. The users had a problem in a production environment and I want access to the same data to debug. The user (service account) created to access the DB is “Developer”. Why am I telling you this, well context can be useful sometimes So the restore is successful, yippee. I run my web app and it blows up with SQL login failed exceptions. Fail! I read the exception carefully, and oh it mentions “Developer” failed to log in, aha, that should ......