如何查找 SQL Server Management Studio 的服务器名称 [英] How to find server name of SQL Server Management Studio
问题描述
我安装了 Microsoft SQL Server 2008.
I installed Microsoft SQL Server 2008.
当我启动 SQL Server Management Studio (SSMS) 时,我会看到 Connect to Server
登录窗口,其中包含一个用于 Server name
的空白文本框.试了很多名字都解决不了.
When I start SQL Server Management Studio (SSMS), I get the Connect to Server
login window with a blank textbox for Server name
. I have tried a lot of names, but I couldn't solve it.
如何查找/获取服务器名称?
How can I find / get the server name?
推荐答案
打开 SQL Server 配置管理器
(在开始"菜单中搜索).单击SQL Server 服务
.SQL Server 的实例名称在SQL Server
服务的括号内.如果它显示 MSSQLSERVER,则它是默认实例.要在 Management Studio 中连接到它,只需键入 .
(点)或 (本地)
并单击连接.如果实例名称不同,则使用.\[实例名称]
连接(例如如果实例名称是SQL2008,则连接到.\SQL2008
).
Open up SQL Server Configuration Manager
(search for it in the Start menu). Click on SQL Server Services
. The instance name of SQL Server is in parenthesis inline with SQL Server
service. If it says MSSQLSERVER, then it's the default instance. To connect to it in Management Studio, just type .
(dot) OR (local)
and click Connect. If the instance name is different, then use .\[instance name]
to connect to it (for example if the instance name is SQL2008, connect to .\SQL2008
).
还要确保 SQL Server
和 SQL Server Browser
服务正在运行,否则您将无法连接.
Also make sure SQL Server
and SQL Server Browser
services are running, otherwise you won't be able to connect.
这是它在我的机器上的样子的屏幕截图.在本例中,我安装了两个实例:SQLExpress
和 SQL2008
.
Here's a screenshot of how it looks like on my machine. In this case, I have two instances installed: SQLExpress
and SQL2008
.
这篇关于如何查找 SQL Server Management Studio 的服务器名称的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!