Trying to save changes to a SQL databse, results in "Cannot open user default database. Login failed
- by Jacob Bellamy
I am building an MVC application with C# as my language which is hosted on Widows 7 IIS. A call to Add a new member to the database works, but when attempting to save the change I get the following error:
Cannot open user default database. Login failed.
Login failed for user 'IIS APPPOOL\myApplication'
The SQL table was added just by adding it within VS.