SQL Server Express 的默认实例名称 [英] Default instance name of SQL Server Express
问题描述
我目前无权访问 SQL Server Express 安装，但我知道安装程序通常使用实例名称安装 SQL Server Express.SQL Server Express 安装的默认实例名称是什么?即，默认情况下如何访问此类安装?是 localhost\SQLEXPRESS$ 吗?2005 和 2008 服务器是否使用相同的名称?
I don't have access to a SQL Server Express installation at the moment, but I know that the installer usually installs SQL Server Express with an instance name. What is the default instance name for SQL Server Express installations? I.e., how do you access such an installation by default? Is it localhost\SQLEXPRESS$ ? Is the same name used for both 2005 and 2008 servers?
推荐答案
安装 SQL Express 时，您通常会得到一个名为 SQLExpress 的命名实例，正如其他人所说，您可以连接到 localhost\SQLExpress.
When installing SQL Express, you'll usually get a named instance called SQLExpress, which as others have said you can connect to with localhost\SQLExpress.
如果您想获得一个没有名称的默认"实例，您也可以这样做.如果您在安装时将 MSSQLServer 作为名称，它将创建一个默认实例，您只需指定 'localhost' 即可连接到该实例.
If you're looking to get a 'default' instance, which doesn't have a name, you can do that as well. If you put MSSQLServer as the name when installing, it will create a default instance which you can connect to by just specifying 'localhost'.
这篇关于SQL Server Express 的默认实例名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
