blocks|key|334463|text|打开CMD|type|unstyled|depth|inlineStyleRanges|entityRanges|data|334464|运行此命令|334465|SQLCMD+-L|code-block|syntax|javascript|334466|您将获得SQL+Server实例列表|334467|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Open CMD

Run this

<pre><code>SQLCMD -L
</code></pre>

You will get list of SQL Server instance

blocks|key|116925|text|默认服务器名称是您的计算机名称，但您可以使用“”。(点)而不是本地服务器名称。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|116926|您应该考虑的另一件事是，您可能已经安装了sql+server速成版。在这种情况下，您必须输入".\sqlexpress“作为服务器名称。|116927|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

the default server name is your computer name, but you can use "." (Dot) instead of local server name. 

another thing you should consider is maybe you installed sql server express edition. in this case you must enter ".\sqlexpress" as server name.

blocks|key|334554|text|启动->命令->+(写命令)+SQLCMD+-L第一行是服务器名称，如果服务器名称是(本地)服务器名称是:您的comand\SQLEXPRESS|type|unstyled|depth|inlineStyleRanges|entityRanges|data|334555|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

start -> CMD -> (Write comand) SQLCMD -L first line is Server name if Server name is (local) Server name is : YourPcName\SQLEXPRESS

blocks|key|116972|text|我第一次也遇到了这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|116973|在“连接到服务器”对话框中，验证默认设置，然后单击“连接”。若要连接，“服务器名称”框必须包含安装了SQL+Server的计算机的名称。如果数据库引擎是命名实例，则“服务器名称”框还应包含格式为:+computer_name\instance_name的实例名称。|116974|例如，我像这样解决了这个问题:我输入了服务器名称:+Alex-PC\SQLEXPRESS|116975|那么它应该是有效的。有关更多信息，请参阅http://technet.microsoft.com/en-us/library/25ffaea6-0eee-4169-8dd0-1da417c28fc6|offset|length|116976|entityMap|0|LINK|mutability|MUTABLE|url|http://technet.microsoft.com/en-us/library/25ffaea6-0eee-4169-8dd0-1da417c28fc6^0|0|0|0|K|27|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@$H|V|I|W|1|X]]|A|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]]]

I also had this problem first time.

In the Connect to Server dialog box, verify the default settings, and then click Connect. To connect, the Server name box must contain the name of the computer where SQL Server is installed. If the Database Engine is a named instance, the Server name box should also contain the instance name in the format: computer_name\instance_name.

So for example i solved the problem like this: I typed in the server name: Alex-PC\SQLEXPRESS

Then it should work. for more see <a href="http://technet.microsoft.com/en-us/library/25ffaea6-0eee-4169-8dd0-1da417c28fc6" rel="noreferrer">http://technet.microsoft.com/en-us/library/25ffaea6-0eee-4169-8dd0-1da417c28fc6</a>

blocks|key|117079|text|Step1:确保系统上安装了SQLEXPRESS和LocalDB。请转到SQL+SERVER配置管理器=>+SQL+Server服务|type|unstyled|depth|inlineStyleRanges|entityRanges|data|117080|如果未列出SQL+Server服务，请安装以下组件(+64位操作系统)+1.+SqlLocalDB+2.+SQLEXPR_x64_ENU+3.+SQLEXPRADV_x64_ENU+4.+SQLEXPRWT_x64_ENU|117081|Step2:打开Management+Studios进入。(点)作为服务器名称，然后单击连接在此处输入图像描述；否则，输入.\SQLEXPRESS作为服务器名称，然后单击连接|117082|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

Step1: Ensure SQLEXPRESS and LocalDB installed on your system
Go to SQL SERVER Configuration Manager => SQL Server Service

If nothing listed for SQL Server services, install below components (for 64 bit OS) 
1. SqlLocalDB
2. SQLEXPR_x64_ENU
3. SQLEXPRADV_x64_ENU
4. SQLEXPRWT_x64_ENU

Step2: Open Management Studios
Enter . (Dot) as server name and click on Connect
 [enter image description here][2]
Else
Enter .\SQLEXPRESS as server name and click on connect

blocks|key|334632|text|只需键入.\sqlexpress作为服务器名称|type|unstyled|depth|inlineStyleRanges|entityRanges|data|334633|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

simply type .\sqlexpress as the Server Name

blocks|key|117250|text|键入sp_helpserver会给出一个列表。正如其他人所指出的，有多种方式，其中一些带有别名之类的。这个存储的proc可能会返回多行，但可以让您更接近您的答案。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|117251|entityMap^0|2|D|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Typing <code>sp_helpserver</code> will give you a list. As others have noted, there are multiple ways, some with alias' and such. This stored proc may return multiple lines but could get you closer to your answer.

blocks|key|117185|text|1.您可以运行以下命令。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|117186|EXEC+xp_cmdshell+'reg+query+"HKLM\Software\Microsoft\Microsoft+SQL+Server\Instance+Names\SQL"'；|117187|去|117188|您可以使用Registry读取实例名称。Ingore空值。|117189|2.使用内置标准报表。|117190|选择实例-->右键单击-->报告-->标准报告-->服务器仪表板|117191|📷|atomic|offset|length|117192|​|117193|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/1a855d8091cc42059b96ae6ed2957d55.png|imageAlt^0|0|0|0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|12|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|13|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|14|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|15|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|16|8|@]|9|@]|A|$]]|$1|L|3|M|5|N|7|17|8|@]|9|@$O|18|P|19|1|1A]]|A|$]]|$1|Q|3|R|5|6|7|1B|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z|10|-4]]]]

1.you can run following command.

EXEC xp_cmdshell 'reg query "HKLM\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL"'; 
GO 

you can read instance name using Registry. Ingore null values.

2.using inbuilt standard Report.

select instance--> right click->Reports-->Standard Reports-->server Dashbords <a href="https://i.stack.imgur.com/uXBy0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uXBy0.png" alt="enter image description here"></a>

blocks|key|334717|text|请确保已安装SQL+Server。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|334718|如果没有，请访问此链接并下载。https://www.microsoft.com/en-us/sql-server/sql-server-downloads|offset|length|334719|一旦成功安装了SQL+server。您将获得服务器名称。参考下图：|334720|​|334721|📷|atomic|334722|334723|entityMap|0|LINK|mutability|MUTABLE|url|https://www.microsoft.com/en-us/sql-server/sql-server-downloads|1|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/5cbc9af0a2a001f84115dcf102b9a879.png|imageAlt^0|0|F|1R|0|0|0|0|0|1|1|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|12|8|@]|9|@$D|13|E|14|1|15]]|A|$]]|$1|F|3|G|5|6|7|16|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|17|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|18|8|@]|9|@$D|19|E|1A|1|1B]]|A|$]]|$1|M|3|I|5|6|7|1C|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]]|O|$P|$5|Q|R|S|A|$T|U]]|V|$5|W|R|X|A|$Y|Z|10|-4]]]]

Make sure you have installed SQL Server.
If not, follow this link and download.
<a href="https://www.microsoft.com/en-us/sql-server/sql-server-downloads" rel="nofollow noreferrer">https://www.microsoft.com/en-us/sql-server/sql-server-downloads</a>
Once SQL server is installed successfully.
You will get server name.
Refer to the below picture:
<a href="https://i.stack.imgur.com/XluRS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XluRS.png" alt="enter image description here" /></a>

blocks|key|117326|text|尝试使用a。或localhost作为服务器名，可能会工作几次。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|117327|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Try using a . or localhost as server name, might work a few times.

blocks|key|117041|text|我的问题是，当在添加引用向导中连接到SQL数据库时，查找SERVERNAME。我是通过以下方式找到它的:在SQL+management+studio中运行一个查询(SELECT+@@+servername+)，reusl是我的servername。我把它放在我的服务器名称框中，它工作得很好。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|117042|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

my problem was that when connecting to SQL Database in the add reference wizard, to find the SERVERNAME. i found it by: running a query(SELECT @@SERVERNAME) inside SQL management studio and the reusl was my servername. I put that in my server name box and it worked all fine.

I installed Microsoft SQL Server 2008.

When I start SQL Server Management Studio (SSMS), I get the <code>Connect to Server</code> login window with a blank textbox for <code>Server name</code>. I have tried a lot of names, but I couldn't solve it.

How can I find / get the server name?

How to find server name of SQL Server Management Studio

SQL数据库

SQL Server

数据库

服务器

我安装了Microsoft SQL Server 2008。当我启动SQL Server Management Studio (SSMS)时，我会看到一个空白的Server name文本框的Connect to Server登录窗口。我试过很多名字，但都解不出来。如何查找/获取服务器名称？

问如何查找SQL server Management Studio的服务器名称
EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何查找SQL server Management Studio的服务器名称EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何查找SQL server Management Studio的服务器名称
EN