在本地计算机上安装 SQL Server Express 2008 R2 时未列出任何服务
我无法让本地计算机运行 SQL Server。我查看了 SQL Server 配置管理器，发现没有列出 SQL Server 服务。那是不对的。我还注意到SysWOW64文件夹中列出了两个管理器（我运行的是Win7）：SQLServerManager10.msc和SQLServerManager.msc。两者都没有显示任何服务。当尝试通过 SSMSE 连接时，我得到了标准：
A network related or instance specific error occurred while establishing a
connection to SQL server...
我尚未安装以前的版本，但确实尝试使用 Microsoft 的 Web 平台安装程序卸载并重新安装。有什么建议吗？
谢谢
I cannot get my local computer to run SQL Server. I looked in the SQL Server configuration manager and noticed that there are no SQL Server Services listed. That can't be right. I also noticed that There are two Managers listed in the SysWOW64 folder (I'm running Win7): SQLServerManager10.msc and SQLServerManager.msc. Neither show any services at all. When trying to connect via SSMSE, I get the standard:
A network related or instance specific error occurred while establishing a
connection to SQL server...
I haven't installed a prior version, but did try to uninstall and reinstall using the Web platform installer from Microsoft. Any suggestions?
Thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
我也遇到了同样的问题，正如 Brian 所说，我缺少 SQL Server Express。 So I download SQL Server 2008 R2 Express 我安装了它。现在一切正常。
请注意，我认为在安装 SQL Management Studio R2。现在，请注意，安装 SQL Management Studio R2 时，您并没有安装 SQL Server，并且您不会在 Sql Server 配置管理器中获得任何 SQL Server 服务 -> SQL 服务器服务。您还需要下载并安装 SQL Server Express。
I had the same problem and as Brian said, I was missing SQL Server Express. So I download SQL Server 2008 R2 Express and I installed it. now everything works fine.
Note that I thought I already installed it when I installed SQL Management Studio R2. Now, be aware that when installing SQL Management Studio R2, you are not installing SQL Server and you won't get any SQL Server Services in your Sql Server Configuration Manager -> SQL Server Services. You also need to download and install SQL Server Express.
SQL Server 是否列在服务中？ （开始->运行->Services.msc）
如果有，它正在运行吗？
Is SQL Server listed in services? (Start->Run->Services.msc)
If so, is it running?
这是一个实例错误，意味着您无法连接到该实例。该计算机上很可能没有安装实例。这意味着您没有正确连接到实例。再次连接到数据库引擎并检查服务器名称，并确保连接到正确的服务器名称或本地主机，具体取决于这是本地计算机还是服务器上。返回安装程序并查看是否有任何未安装的功能。尝试一下，看看是否有效。如果没有，则重新安装 SQL Server 并确保在重新安装之前删除所有文件夹并且没有留下任何内容。
That is an instance error, meaning you cannot connect to the instance. Most likely there is no instance installed on this machine. Meaning your not connecting correctly to the instance. Connect to the database engine again and check the server name and make sure your connecting to the correct server name or the local host, depending if this is a local machine or if this is on a server. Go back through setup and see if there are any features that didn't get installed. Try that and see if it works. If not then reinstall SQL Server and make sure all folders are removed and nothing is left behind before you reinstall.