安装 SQL Server Management Studio 后，服务列表中的 SQL Server 服务不可用
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/25180252/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
SQL Server Service not available in service list after installation of SQL Server Management Studio
提问by Abb
I have Windows 7 Home edition SP1 installed on my system, and downloaded SQL Server 2008 R2 Management Studio and got it installed. But when I try to connect via .\SQLEXPRESS, SSMS shows error
我的系统上安装了 Windows 7 Home edition SP1，并下载了 SQL Server 2008 R2 Management Studio 并安装了它。但是当我尝试通过 .\SQLEXPRESS 连接时，SSMS 显示错误
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476.
与 SQL Server 建立连接时发生与网络相关或特定于实例的错误。服务器未找到或无法访问。验证实例名称是否正确以及 SQL Server 是否配置为允许远程连接。（提供程序：SQL 网络接口，错误：26 - 错误定位服务器/指定的实例）（Microsoft SQL Server，错误：-1） 如需帮助，请单击：http: //go.microsoft.com/fwlink?ProdName=Microsoft+SQL +Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476。
I go back to check the local services there I don't find any SQL Server service running.
我回去检查本地服务，我没有发现任何 SQL Server 服务正在运行。
What I have to do for this? DO I need to install any SQL service on my system? or how I should proceed?
我必须为此做什么？我需要在我的系统上安装任何 SQL 服务吗？或者我应该如何进行？
回答by
downloaded Sql server management 2008 r2 and got it installed. Its getting installed but when I try to connect it via .\SQLEXPRESS it shows error. DO I need to install any SQL service on my system?
下载Sql server management 2008 r2并安装。它正在安装，但是当我尝试通过 .\SQLEXPRESS 连接它时，它显示错误。我需要在我的系统上安装任何 SQL 服务吗？
You installed management studio which is just a management interface to SQL Server. If you didn't (which is what it seems like) already have SQL Server installed, you'll need to install it in order to have it on your system and use it.
您安装了管理工作室，它只是 SQL Server 的管理界面。如果您还没有（看起来是这样）已经安装了 SQL Server，那么您需要安装它才能在您的系统上安装并使用它。
http://www.microsoft.com/en-us/download/details.aspx?id=1695
http://www.microsoft.com/en-us/download/details.aspx?id=1695
回答by Vishal R
You need to start the SQL Server manually. Press
您需要手动启动 SQL Server。按
windows + R
窗户 + R
type
类型
sqlservermanager12.msc
sqlservermanager12.msc
right click ->Start
右键单击 -> 开始
