I get cannot open database error when trying to open the database?

Question

I am following this tutorial. I did everything according to the tutroial. However, I am getting an error when I am trying to open the database. It says "cannot open the database requested by the login". I am using visual studio 2012 express. The tutorial is using 2013. Could that be a problem? Here is my connection string.

<connectionStrings>
   <add name="SchoolContext" 
        connectionString="Data Source=(LocalDb)\v11.0;Initial Catalog=ContosoUniversity;Integrated Security=True;" 
        providerName="System.Data.SqlClient"/>
</connectionStrings>

The tutorial I am following. http://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-application

marc_s · Accepted Answer · 2013-11-26 19:52:56Z

1

If you have Visual Studio 2012 installed, you most likely don't have SQL Server 2012 Express which is needed for using the (localdb)\v11.0 feature.

If you have an earlier version of SQL Server Express installed, then you should try to use this connection string instead:

<connectionStrings>
   <add name="SchoolContext" 
        connectionString="server=.\SQEXPRESS;database=ContosoUniversity;Integrated Security=SSPI;" 
        providerName="System.Data.SqlClient"/>
</connectionStrings>

and then basically EF should create your database on your local SQL Server Express instance and use it from there.

answered Nov 26, 2013 at 19:52

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ahmed ilyas · Accepted Answer · 2013-11-26 19:40:16Z

0

you need to add the ASPNET/Network NT account into the list of users allowed to access the DB. ASP.NET apps use the NT Service account/ASPNET account by default on the app pool.

take a look here and scroll to the SQL Server section:

http://msdn.microsoft.com/en-us/library/ff647402.aspx

answered Nov 26, 2013 at 19:40

Ahmed ilyas

5,8328 gold badges46 silver badges78 bronze badges

Collectives™ on Stack Overflow

I get cannot open database error when trying to open the database?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related