无法从 SSMS 连接到 SQL Server express [英] Cannot connect to SQL Server express from SSMS

问题描述

我已经安装了 SQL Server Management Studio 2005.当我单击浏览更多"时我找不到我的服务器名称，但我知道我的服务器名称将与下图中的用户名相同.

I have installed SQL Server Management Studio 2005. I can't find my server name when I click browse for more but i know that my server name will be the same as the user name as in the picture below.

推荐答案

Use . or (local) or localhost for server name if您将服务器安装为默认实例.

Use . or (local) or localhost for server name if you installed the server as default instance.

如果您有 SQL Express，请使用 .\sqlexpress 或 localhost\sqlexpress.

Use .\sqlexpress or localhost\sqlexpress if you have SQL Express.

服务器名称语法为

Servername\InstanceName

如果实例是默认的，你只使用服务器名.
对于 SQL Express，实例名称默认为 sqlexpress.

If the instance is default you use just Servername.
For SQL Express, instance name is sqlexpress by default.

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