Hi,
I am new to microsoft .net and SQLServer. I am using Visual C# express edition and SQLServer 2008 along with the Management Studio to learn the .net technology. I am facing strange problem as regards the database connection. When I run my C#
program and try to access SQLServer database it works fine. But when I open the Management Studio to have a look at the data, and then again run the Visual C# code, the code fails with the following exception
InnerException: System.Data.SqlClient.SqlException
Message=Cannot open database "CodeFirstSample.Model.ProductContext" requested by the login. The login failed.
Login failed for user 'COMPUTERXX\UserXX'.
The first conclusion might be that the Database allows connection to single user at a time. But when I checked the options for the database, the Restrict Access option is set to MULTI_USER.
Now here is the strange part. If I disconnect manageme ...
Go to the complete details ...