I'm trying some of the ASP.NET MVC tutorials and one of them has the following steps:
我正在尝试一些ASP.NET MVC教程，其中一个有以下步骤：
- Right-click on the "App_Data" folder, and choose "Add New item"
- 右键单击“App_Data”文件夹，然后选择“添加新项”
- Choose "SQL Server Database" under the "Data" category.
- 在“数据”类别下选择“SQL Server数据库”。
However, once I do that, I get the following message from Visual Studio:
但是，一旦我这样做，我从Visual Studio得到以下消息：
Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function proprely. Please verify the installation of the component or download from the URL...
与SQL Server文件（* .mdf）的连接要求SQL Server Express 2005正常运行。请验证组件的安装或从URL下载...
The thing is that I have SQL Server 2008 Developer Edition installed, and I would really rather not install any Express versions (2005 or 2008) if I don't have to. Is there a work-around for this issue?
问题是我安装了SQL Server 2008 Developer Edition，如果不需要，我真的不会安装任何Express版本（2005或2008）。这个问题有解决办法吗？
5 个解决方案
#1
5
Actually SQL express is a whole different database engine then SQL Server 2005. So yes if you want to use mdf files you'd need SQL Express.
实际上SQL Express是一个完全不同的数据库引擎，然后是SQL Server 2005.所以是的，如果你想使用mdf文件，你需要SQL Express。
#2
12
I ran into this problem too on 64-bit Windows 7 (using 64-bit SQL Server Express 2008).
我在64位Windows 7（使用64位SQL Server Express 2008）上遇到了这个问题。
There are two methods of fixing this problem referenced in the Microsoft Support Knowledge Base article:
有两种方法可以解决Microsoft支持知识库文章中引用的此问题：
1. Workaround
解决方法
To work around this problem, uninstall the 64-bit version of SQL Server Express 2008, and then install the 32-bit version of SQL Server Express 2008.
若要解决此问题，卸载64位版本的SQL Server Express 2008，然后安装32位版本的SQL Server Express 2008。
If you don't want to do the uninstall/install, then try the Hotfix method below.
如果您不想进行卸载/安装，请尝试下面的Hotfix方法。
2. Hotfix
2.修补程序
A supported hotfix is now available from Microsoft. However, it is intended to correct only the problem that this article describes. Apply it only to systems that are experiencing this specific problem.
Microsoft现在提供了受支持的修补程序。但是，它仅用于纠正本文所述的问题。仅将其应用于遇到此特定问题的系统。
Although the article itself doesn't include a link to the hotfix, you can get it here: http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=957944
虽然文章本身不包含到此修补程序的链接，您可以在此处获取：http：//support.microsoft.com/hotfix/KBHotfix.aspx？kbnum = 957944
#3
7
To illuminate masfenix's reply, SQL Express supports one feature that is not supported by full-blown SQL Server: a "user instance" database. With SQL Express installed and an mdf file in your App_Data folder, the application will dynamically attach and detach it as needed. For hobbyist or small business sites, this may be perfect. If you're running SQL elsewhere in the enterprise, you probably don't want to go this route and therefore the feature isn't useful to you.
为了阐明masfenix的回复，SQL Express支持一个完整的SQL Server不支持的功能：“用户实例”数据库。安装SQL Express并在App_Data文件夹中安装mdf文件后，应用程序将根据需要动态附加和分离它。对于业余爱好者或小型企业网站来说，这可能是完美的。如果您在企业中的其他位置运行SQL，则可能不希望使用此路由，因此该功能对您没用。
#4
2
I want to point out that I have both Developer edition and Express edition installed. And I still run into the same error. I think Express edition must be installed as a single instance.
我想指出我已经安装了Developer Edition和Express Edition。我仍然遇到同样的错误。我认为Express版必须作为单个实例安装。
#5
1
I have the same problem but I've sql 2008 express installed. any way to make it work with sql 2008 express so I don't have to install the 4th sql instance on my machine?? I already have sql 2005, sql 2008, sql 2008 express
我有同样的问题，但我已经安装了sql 2008 express。任何方式使它与sql 2008 express一起工作所以我不必在我的机器上安装第四个sql实例？我已经有sql 2005，sql 2008，sql 2008 express
what the F... :)
什么F ...... :)
#1
5
Actually SQL express is a whole different database engine then SQL Server 2005. So yes if you want to use mdf files you'd need SQL Express.
实际上SQL Express是一个完全不同的数据库引擎，然后是SQL Server 2005.所以是的，如果你想使用mdf文件，你需要SQL Express。
#2
12
I ran into this problem too on 64-bit Windows 7 (using 64-bit SQL Server Express 2008).
我在64位Windows 7（使用64位SQL Server Express 2008）上遇到了这个问题。
There are two methods of fixing this problem referenced in the Microsoft Support Knowledge Base article:
有两种方法可以解决Microsoft支持知识库文章中引用的此问题：
1. Workaround
解决方法
To work around this problem, uninstall the 64-bit version of SQL Server Express 2008, and then install the 32-bit version of SQL Server Express 2008.
若要解决此问题，卸载64位版本的SQL Server Express 2008，然后安装32位版本的SQL Server Express 2008。
If you don't want to do the uninstall/install, then try the Hotfix method below.
如果您不想进行卸载/安装，请尝试下面的Hotfix方法。
2. Hotfix
2.修补程序
A supported hotfix is now available from Microsoft. However, it is intended to correct only the problem that this article describes. Apply it only to systems that are experiencing this specific problem.
Microsoft现在提供了受支持的修补程序。但是，它仅用于纠正本文所述的问题。仅将其应用于遇到此特定问题的系统。
Although the article itself doesn't include a link to the hotfix, you can get it here: http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=957944
虽然文章本身不包含到此修补程序的链接，您可以在此处获取：http：//support.microsoft.com/hotfix/KBHotfix.aspx？kbnum = 957944
#3
7
To illuminate masfenix's reply, SQL Express supports one feature that is not supported by full-blown SQL Server: a "user instance" database. With SQL Express installed and an mdf file in your App_Data folder, the application will dynamically attach and detach it as needed. For hobbyist or small business sites, this may be perfect. If you're running SQL elsewhere in the enterprise, you probably don't want to go this route and therefore the feature isn't useful to you.
为了阐明masfenix的回复，SQL Express支持一个完整的SQL Server不支持的功能：“用户实例”数据库。安装SQL Express并在App_Data文件夹中安装mdf文件后，应用程序将根据需要动态附加和分离它。对于业余爱好者或小型企业网站来说，这可能是完美的。如果您在企业中的其他位置运行SQL，则可能不希望使用此路由，因此该功能对您没用。
#4
2
I want to point out that I have both Developer edition and Express edition installed. And I still run into the same error. I think Express edition must be installed as a single instance.
我想指出我已经安装了Developer Edition和Express Edition。我仍然遇到同样的错误。我认为Express版必须作为单个实例安装。
#5
1
I have the same problem but I've sql 2008 express installed. any way to make it work with sql 2008 express so I don't have to install the 4th sql instance on my machine?? I already have sql 2005, sql 2008, sql 2008 express
我有同样的问题，但我已经安装了sql 2008 express。任何方式使它与sql 2008 express一起工作所以我不必在我的机器上安装第四个sql实例？我已经有sql 2005，sql 2008，sql 2008 express
what the F... :)
什么F ...... :)