如何连接到 SQL Server 2008 Express 的本地实例 [英] How to connect to local instance of SQL Server 2008 Express
问题描述
我刚刚在我的 Vista SP1 机器上安装了 SQL Server 2008 Express.我以前在这里有 2005 年，并且在旧的 SQL Server Management Studio Express 中使用它很好.我能够毫无问题地连接到我的 PC-NAME\SQLEXPRESS 实例(不，PC-NAME 不是我的计算机名称；-).
I just installed SQL Server 2008 Express on my Vista SP1 machine. I previously had 2005 on here and used it just fine with the old SQL Server Management Studio Express. I was able to connect with no problems to my PC-NAME\SQLEXPRESS instance (no, PC-NAME is not my computer name ;-).
我卸载了 2005 和 SQL Server Management Studio Express.然后我在我的机器上安装了 SQL Server 2008 Express，并选择让它安装 SQL Server Management Studio Basic.
I uninstalled 2005 and SQL Server Management Studio Express. I then installed SQL Server 2008 Express on my machine and elected to have it install SQL Server Management Studio Basic.
现在，当我尝试连接到 PC-NAME\SQLEXPRESS(使用 Windows 身份验证，就像我一直做的那样)时，我收到以下消息:
Now, when I try to connect to PC-NAME\SQLEXPRESS (with Windows Authentication, like I always did), I get the following message:
无法连接到 PC-NAME\SQLEXPRESS.与 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
当我安装 SQL Server 2008 时，我让它使用 SQLEXPRESS 作为本地实例名称.据我所知，通过 SQL Server 配置管理器，SQL Server 被配置为允许远程连接.
When I installed SQL Server 2008, I had it use SQLEXPRESS as the local instance name. As far as I can tell, through SQL Server Configuration Manager, SQL Server is configured to allow remote connections.
当我转到它提到的帮助链接时，帮助页面建议如下:
When I went to the help link it mentions, the help page suggests the following:
- 确保在服务器上启动了 SQL Server Browser 服务.
- 使用 SQL Server Surface Area Configuration 工具使 SQL Server 能够接受远程连接.有关 SQL Server 表面区域配置工具的详细信息，请参阅服务和连接的表面区域配置.
嗯，据我所知，我的系统上没有 SQL Server Browser 服务(在 MMC 中找了一个，找不到).
Well, as far as I can tell, there is no SQL Server Browser service on my system (looked in MMC for one, couldn't find one).
并且 SQL Server 表面区域配置工具在 SQL Server 2008 中不存在.微软的帮助文档做得很好；-)
And the SQL Server Surface Area Configuration tool doesn't exist in SQL Server 2008. So good job there with your help documentation, Microsoft ;-).
我现在不知道该做什么.升级到 2008 后，我希望今天能完成很多工作(与我一起工作的人毫无问题地启动并运行了它，并告诉我这很容易 - 他在数据库方面也做得更好，我是).有谁知道可能有什么问题?我真的很感激.如果我不能在几个小时内完成这项工作，我将回到 SQL Server 2005(如果这甚至可以工作，嗯......).
I'm at a loss for what to do right now. I had a lot of work I was hoping to get done today after upgrading to 2008 (the person I'm working with got it up and running with no problem and told me it would be easy - he's also far better with database stuff that I am). Does anyone have any idea what might be wrong? I'd really appreciate it. If I can't get this working in a few hours, I'm going back to SQL Server 2005 (if that will even work, gah...).
我尝试关闭 Windows 防火墙，但没有帮助.另外，我注意到我的 SQL Server 2008 安装目录树下没有Data"目录 - 我安装时可能设置错误吗?
I have tried turning Windows Firewall off, and that did not help. Also, I noticed that I do not have a "Data" directory under my SQL Server 2008 install directory tree - could I have possibly set something up wrong when I installed it?
推荐答案
哈哈，天哪，我想通了.不知何故，我在安装 SQL Server 2008 时没有安装数据库引擎.我不知道我是怎么错过的，但这就是发生的事情.
Haha, oh boy, I figured it out. Somehow, someway, I did not install the Database Engine when I installed SQL Server 2008. I have no idea how I missed that, but that's what happened.
这篇关于如何连接到 SQL Server 2008 Express 的本地实例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
