I've been struggling with the following issue for 3 days: I can access and use my SQL Express 2008R2 database flawlessly from SQL Server Management Studio. But I can only intermittently
access it from Visual Studio (ultimate edition with TF Server). Sometimes it works, sometimes it doesn't. I mostly see the error when I try to "Update Model from Database" within my Entity framework model, or when I try to access the database from
within Server Explorer.
Here is the error I see when I try to update my Entities form the Database: An error occurred while connecting to the database. The database
might be unavailable. An exception of type 'System.Data.SqlClient.SqlException' occurred. The error message is: 'Cannot open user default database. Login failed. Login failed for user 'Tim-PC\Tim'.'
I think the connection string is fine as I am able to connect
View Complete Post