无法连接到SQL Server Management Studio [英] Cannot connect to SQL Server Management Studio

问题描述

说实话，我正在撕头发.

tearing my hair out to be honest at this stage.

我在笔记本电脑上安装了SQL Server 2008 Express.我一直试图登录到SQL Server Management Studio，但没有成功.昨天我什至进行了全新安装，但仍然没有任何乐趣.在安装时，我选择使用Windows身份验证安装默认实例，我已在配置管理器中启用了远程连接.

I have an installation of SQL Server 2008 express on my laptop. I've been trying to login to SQL Server Management Studio without success. I even did a fresh install yesterday and still no joy. On installation I selected to install the default instance with windows authentication, I have enabled remote connection in configuration manager.

我登录时收到的错误消息如下:

The error message I get when I log in is as following:

与网络相关或特定于实例的网络 建立A时发生错误 与SQL Server的连接.服务器 找不到或无法访问. 验证实例名称为 正确，并且该SQL Server是 配置为允许远程 连接. (提供者:SQL Network 接口，错误:25-连接 字符串无效)(Microsoft SQL 服务器，错误:87)

A network related or instance specific error occured 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: 25 - connection string is not valid)(Microsoft SQL Server, Error:87)

我尝试使用谷歌搜索，所能看到的只是对那些遇到错误26(在执行全新安装之前得到的错误)的人的帮助.

I've tried googling it and all I can see is help for people who get error 26 (which I was getting before I did the fresh install.

登录设置为:

服务器类型:数据库引擎 伺服器名称:TARAW-PC \ MSSQLSERVER 身份验证:Windows身份验证

Server Type: Database Engine Server Name: TARAW-PC\MSSQLSERVER Authentication: Windows Authentication

推荐答案

可以检查您的sql服务是否正在运行.

Can you check if your sql services are running.

在开始时->运行，键入net start mssqlserver

In your start -> Run, type net start mssqlserver

然后尝试登录

这篇关于无法连接到SQL Server Management Studio的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！