将 SQL Express 安装为 MSSQLSERVER 会导致什么问题？
与此反馈文档中的人员一样，选择“默认实例”选项在 SQL Server 2008 Express RTM 中没有任何效果，我不得不安装 SQL Server Express 2008 两次才意识到我在做什么。
即使您选择“默认实例”，安装也会默认为“SQLExpress”。如果我将 SQL Server Express 安装为实例“MSSQLSERVER”，将来可能会导致什么问题？
As with the people in this feedback doc, Selecting the "Default Instance" option in SQL Server 2008 Express RTM has no effect, I had to install SQL Server Express 2008 twice before I realised what was I was doing.
The installation defaults to "SQLExpress" even if you select Default Instance. What problems might I cause myself in the future if I install SQL Server Express as the instance "MSSQLSERVER"?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
我没有看到任何重大问题 - 您必须注意的唯一限制是，如果您需要在同一台服务器上安装“完整”版本的 SQL Server，则无法将其安装为默认实例，因为该实例名称默认为 MSSQLSERVER。
但即使将 SQL Server Express 安装为“MSSQLSERVER”，您仍然可以轻松地在不同的实例名称下安装 SQL Server 的完整副本 - 我没有看到这方面的任何问题。
I don't see any major problems - the only restriction you have to be aware of is that if you ever need to install a "full" version of SQL Server onto the same server, you cannot install it as default instance, since that instance name would default to MSSQLSERVER.
But even with SQL Server Express installed as "MSSQLSERVER", you can still easily install a full copy of SQL Server under a different instance name - I don't see any problems in that respect.
SQL Express本身没有问题。它可以作为默认实例进行安装、更新、卸载。但是，各种管理工具、开发工具、文档和示例都存在很多问题，这些工具（有时是硬代码）都假设 Express 实例将被命名为“SQLEXPRESS”。正如您已经发现的，此类“默认”的一个示例是计算机配置中的 LocalSqlServer 连接字符串。 Andomar 发现还有其他的，包括 VS 安装脚本等。
因此，虽然可以将 SQL Express 作为“MSSQLSERVER”，但开发平台中的许多工具不会将其视为 SQL Express 实例，因此最好顺其自然并拥有名为“SQLEXPRESS”的 SQL Express，以供 Visual Studio 和朋友使用。
There is no problem with SQL Express itself. It can be installed, updated, uninstalled just fina as a default instance. But there are plenty of problems with various admin tools, development tools, documentation and samples that all assume, sometimes in hard code, that the Express instance will be named 'SQLEXPRESS'. An example of such 'default' is the LocalSqlServer connection string in the machine configuration, as you already found out. There are other, including VS installation scripts and such, as Andomar found out.
So while is possible to have a SQL Express as 'MSSQLSERVER', it will not be considered as the SQL Express instance by many of the tools from development platform, so is better to go with the flow and have a SQL Express named 'SQLEXPRESS' for the benefit of Visual Studio and friends.
我曾经通过这种方式安装了 SQL Server Express 2005 的副本。后来，我安装了 Visual Studio 的测试版。结果是灾难性的：Windows 更新无法运行，两个产品的卸载程序都失败，我只能通过重新安装 Windows 来修复它。
现在也许它已在 SQL Server Express 2008 中修复，但除非确实有必要，否则我不会将其安装为 MSSQLSERVER。
I once installed a copy of SQL Server Express 2005 that way. Later on, I installed a beta version of Visual Studio. The result was disastrous: Windows Updates wouldn't run, the uninstaller for both products failed, and I could fix it only by reinstalling Windows.
Now maybe it's fixed in SQL Server Express 2008, but I would not install it as MSSQLSERVER unless it's really necessary.
这是我自己造成的一个问题：
需要什么数据库使 Silverlight 业务应用程序模板正常工作？
Here's one problem I caused myself:
What DB required to make the Silverlight Business Application template work?