使用 SQL Server Management Studio 访问 SQL Server 2008 R2 Express
好吧，也许我有点愚蠢，而且我的谷歌搜索没有找到适合初学者的清晰的逐步用户案例。
我刚刚在我的 Win 7 Pro 64 位 SP1 计算机上安装了具有高级服务的 SQL Server 2008 R2 Express 数据库 [从此处下载 http://www.microsoft.com/express/Database/InstallOptions.aspx]。 （实际上我已经删除并安装了它 3 次，以检查我是否丢失了任何配置）。我基本上将所有设置保留为默认设置，除了调用实例 SQLEXPRESS （全部大写与默认 SQLexpress）我上次安装时将其设置为“Windows 身份验证模式”，仅使用与我现在正在选择运行（无论如何，这台机器上只有一个用户）。
完成后我重新启动了机器，我可以看到服务
- SQL Server (SQLEXPRESS) ->开始->自动
- SQL Server 代理 (SQLEXPRESS) -> ->手动
- SQL Server 浏览器 -> ->手动
- SQL Server 报告服务 (SQLEXPRESS) ->开始->自动
- SQL Server VSS 编写器 ->开始->自动
..所以看起来还可以。
作为安装过程的一部分，它还安装了 SQL Server Management Studio 2008 R2，当我尝试连接时，我选择：
Server: Database Engine
Servername : \SQLEXPRESS
Authentication: Windows Authentication
User name: (selected for me and not alterable) machinename\username
Password: (also blank greyed out)
我点击连接并收到以下消息。
无法连接到 \SQLEXPRESS。
与网络相关或特定于实例的 建立时发生错误 连接到 SQL Server。服务器 未找到或无法访问。 验证实例名称是否为 正确并且 SQL Server 是 配置为允许远程 连接。 （提供商：SQL 网络 接口，错误：25 - 连接 字符串无效）（.Net SqlClient 数据提供者）错误号：87
严重性：20
状态：0
好的，假设我没有输入用户名或密码，并且我确定服务器实例名称 - 并且它正在运行......我做错了什么？
OK maybe I'm being stupid somehow, and my googleing has not found a clear step by step user case for beginners.
I have just installed into my Win 7 Pro 64-bit SP1 machine SQL Server 2008 R2 Express Database with Advanced Services [downloaded from here http://www.microsoft.com/express/Database/InstallOptions.aspx]. (Actually I have removed and installed it 3 times now to check I'm not missing anything config wise). I have left basically all settings as default, with the exception of calling the Instance SQLEXPRESS (all caps vs default SQLexpress) my last installation I have left set as 'windows authentication mode' with only the same user as I am running now selected (only one user on this machine anyway).
After completion I have restarted the machine, I can see the services
- SQL Server (SQLEXPRESS) -> Started -> Automatic
- SQL Server Agent (SQLEXPRESS) -> -> Manual
- SQL Server Browser -> -> Manual
- SQL Server Reporting Service (SQLEXPRESS) -> Started -> Automatic
- SQL Server VSS Writer -> Started -> Automatic
.. So it seems to be up OK.
As part of the installation process it also installed SQL Server Management Studio 2008 R2 and when I try and connect I am choosing:
Server: Database Engine
Servername : \SQLEXPRESS
Authentication: Windows Authentication
User name: (selected for me and not alterable) machinename\username
Password: (also blank greyed out)
I hit connect and get the following message.
Cannot connect to \SQLEXPRESS.
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: 25 - Connection
string is not valid) (.Net SqlClient
Data Provider)Error Number: 87
Severity: 20
State: 0
OK, so given I am not entering a username or password, and I'm certain of the server instance name - and that it is running ... what am I doing wrong?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
以下是通过 SSMS 连接到 SQL Server 的一些故障排除提示：
.\sqlexpress或localhost\sqlexpress或(local)\ sqlexpress。它不区分大小写。您似乎在连接对话框的服务器名称字段中缺少主机名。Here are a few troubleshooting tips for connecting to SQL Server via SSMS:
.\sqlexpressorlocalhost\sqlexpress, or(local)\sqlexpress. It's not case sensitive. It appears you're missing the hostname in the server name field in the connection dialog.