C# – Entity Framework Cannot Open Database Requested By the Login – The Login Failed For User

asp.net-mvccentity-frameworknetsql server

I've just uploaded my website to a server and getting an error called "cannot open database requested by the login the login failed login failed for user".

In my global.asax file on Application_Start method, I have this :

Database.SetInitializer<MyContext>(null);

So I created my database manually and after used script to create tables. But when I want to login, it gives me an error.

On my database my tables, username and password for login page seem fine. Just can't connect to the database.

My connectionstring is:

 <add name="MyDatabase" connectionString="Data Source=serveradress;Initial Catalog=MyDatabase;User ID=username;Password=password;MultipleActiveResultSets=True;App=EntityFramework" providerName="System.Data.SqlClient" />

I'll be grateful for advice.

Best Answer

I've just solved the problem. The problem is "typical programmers problem". I needed to write MyDatabase but I wrote MyDatabse. I'm trying to solve this problem since at 11 o'clock. Thank you for your all replies.

Related Solutions

Entity-framework – How to view the SQL generated by the Entity Framework

For those using Entity Framework 6 and up, if you want to view the output SQL in Visual Studio (like I did) you have to use the new logging/interception functionality.

Adding the following line will spit out the generated SQL (along with additional execution-related details) in the Visual Studio output panel:

using (MyDatabaseEntities context = new MyDatabaseEntities())
{
    context.Database.Log = s => System.Diagnostics.Debug.WriteLine(s);
    // query the database using EF here.
}

More information about logging in EF6 in this nifty blog series: http://blog.oneunicorn.com/2013/05/08/ef6-sql-logging-part-1-simple-logging/

Note: Make sure you are running your project in DEBUG mode.

C# – Entity Framework The underlying provider failed on Open

Seems like a connection issue. You can use the Data link properties to find if the connection is fine. Do the following:

Create a blank notepad and rename it to "X.UDL"
Double click to open it
Under connections tab choose the server name/enter the name use the correct credentials and DB
Click OK to save it.

Now open the file in Notepad and compare the connection string properties.

Best Answer

Related Solutions

Entity-framework – How to view the SQL generated by the Entity Framework

C# – Entity Framework The underlying provider failed on Open

Related Topic