asp.net mvc - How to add a new database under app_data with SQL Server Enterprise Edition -


I am a complete newbie in MVC, and now I stand at the beginning of it.

I checked the tutorial podcast, in which I found that I can add a new item of SQL Server database under app_data . But once I click on it, a msg papup to show in my desktop, no SQL Server 2005 or 2008 Express was installed.

But in fact, I have a SQL Server 2005 Enterprise already installed, why did this happen? And how do I add a SQL Server database if I get an Enterprise version?

Thank you very much.

ap_data folder only Adding works with SQL Server Express editions. There is nothing like this for enterprise versions to enable it.

If you have a SQL Server Enterprise, then you need to create your database and your DB object in that database (using SQL Server MGMT Studio or Visual Studio) and connect to that server Can not Put your MDF / LDF file in apa data with Enterprise Edition - it just will not work.

Or if you do not like this approach, you can always install SQL Server 2005/2008 Express on your machine and then "your MDF file with app_data ".


Comments