我如何知道要从SSMS连接的sql server数据库名称

Installed SSMS 2017 version. When I launch it first time, it asks for server name to connect to. I installed SQL server 2014 already. But I don't know the name of the server. I tried giving server name as "local". But it wouldn't accept. It says "Cannot connect to to local" Error: 53

已安装SSMS 2017版。当我第一次启动它时，它会要求连接服务器名称。我已经安装了SQL Server 2014。但我不知道服务器的名称。我尝试将服务器名称设为“本地”。但它不会接受。它说“无法连接到本地”错误：53

Since I installed SQL server on my local machine, "local" should be acceptable name as a server to connect to from SSMS.

由于我在本地计算机上安装了SQL Server，因此“本地”应该是可接受的名称，作为从SSMS连接的服务器。

server name?

服务器名称？

4 个解决方案

#1

。

localhost

本地主机

127.0.0.1

Any of these will connect to sql server running on your local machine.

其中任何一个都将连接到本地计算机上运行的sql server。

If you installed sql as a named instance, then .\myinstance, localhost\myinstance, etc

如果您将sql作为命名实例安装，那么。\ myinstance，localhost \ myinstance等

#2

You can use (.), or local or localhost.

您可以使用（。），local或localhost。

If you used named instance, follow the next:-

如果您使用了命名实例，请按照下一步： -

Use Browse for more, for getting the accurate server name as next screen shots;-

使用“浏览”获取更多信息，以获取准确的服务器名称作为下一屏幕截图; -

and under Database Engine, you will get the accurate server name

在数据库引擎下，您将获得准确的服务器名称

#3

If you have Db connection you can use this command

如果您有Db连接，则可以使用此命令

select @@servername + '\' + @@servicename

you can also check SQL Server Configuration Manager.

您还可以检查SQL Server配置管理器。

In Configuration Manager you need to find SQL Server Service. When you Double click the SQL Service and navigate through Service Tab, you need to see SQL Server Name

在Configuration Manager中，您需要查找SQL Server服务。双击SQL服务并在“服务”选项卡中导航时，需要查看“SQL Server名称”

#4

It should be localhost, just setup my SQL server last month and had to find this information aswell.

它应该是localhost，上个月只需设置我的SQL服务器，并且还必须找到这些信息。

#1

。