连接到 SQL Server Express - 我的服务器名称是什么? [英] Connecting to SQL Server Express - What is my server name?

问题描述

我刚刚从客户那里得到一台笔记本电脑来执行一些开发工作，我目前正在对其进行设置.安装了 Visual Studio 2010 以及 SQL Server Management Studio 2008 R2.我正在尝试打开 SQL Server Management Studio 以连接到数据库，但到目前为止运气不佳.我习惯于输入服务器名称，例如...

I was just given a laptop to perform some development from a client and I am currently in the process of setting it up. Visual Studio 2010 is installed as well as SQL Server Management Studio 2008 R2. I'm trying to open SQL Server Management Studio to connect to the database but so far am not having much luck. I'm used typing in for a server name something like...

localhost
(local)
SQLEXPRESS

这些都不起作用.

所以我的问题是:我如何知道我在这台机器上安装了什么类型的 SQL Server 和配置，以及如何发现我需要使用什么服务器名称才能正确连接到它?

So my question is: How can I tell what type of SQL Server installation and configuration I have on this machine, and how can I discover what server name I need to use in order to properly connect to it?

--添加--------------------------------------------

--Addition--------------------------------------------

我按照指示查看了服务，并找到了一些所示的实例.SQLEXPRESS 和 MSSQLSERVER.我尝试在这些配置中使用这两个选项登录...

I looked into the services as directed and found a few instances as indicated. SQLEXPRESS and MSSQLSERVER. I have tried to login with both of those options in these configurations...

SQLEXPRESS
MSSQLSERVER
computername\SQLEXPRESS
computername\MSSQLSERVER
.\SQLEXPRESS
.\MSSQLSERVER

这些都没有用.我还将服务的登录身份"属性从网络服务"更改为本地系统"并再次尝试.仍然没有成功.

None of these worked. I also altered the 'Log On As' property of the services from 'Network Service' to 'Local System' and tried them again. Still no success.

推荐答案

您应该能够在服务"面板中看到它.查找类似于 Sql Server (MSSQLSERVER) 的服务名称.括号中的名称是您的实例名称.

You should be able to see it in the Services panel. Look for a servicename like Sql Server (MSSQLSERVER). The name in the parentheses is your instance name.

这篇关于连接到 SQL Server Express - 我的服务器名称是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！