已安装 SQL Server 2008，但运行版本仍为 2005 [英] SQL Server 2008 installed, though running version is still 2005

问题描述

不久前，我在一台已经安装了 Visual Studio 的 Sql Server 2005 express 的开发机器上安装了 SQL Server 2008.当我查看我的程序时，我看到Microsoft Sql Server 2008"，其中包含管理工作室等.我也可以看到MS Sql Server 2005".

A while back I installed SQL Server 2008 on a development machine which already had Sql Server 2005 express from Visual Studio. When I look in my programs, I see 'Microsoft Sql Server 2008', which contains the management studio, etc. As well I can see 'MS Sql Server 2005'.

当我在 Management Studio 2008 中运行查询以选择在我的机器上运行的版本时，它显示为 2005，让我摸不着头脑.当我查看配置管理器时，我看到的只是 SQLEXPRESS 实例正在运行...

When I run a query in Management Studio 2008 to select the version running on my machine, it comes up as 2005, and leaves me scratching my head. When I look in the configuration manager, all I see is the SQLEXPRESS instance running ...

考虑到已安装 2008，是否有任何快速"解决方案可以让 2008 而不是 2005 运行?

Are there any "quick" solutions to get 2008 running instead of 2005, considering 2008 is installed?

推荐答案

如果您使用 SQL Server 2005 配置管理器，您将只能看到 2005 和更低的实例.

If your using the SQL Server 2005 Configuration Manager you will only see 2005 instances and lower.

要查看 SQL Server 2008 的实例，您需要确保使用的是 SQL Sever 2008 配置管理器.

To view instances of SQL Server 2008 you will want to make sure you are using SQL Sever 2008 Configuration Manager.

最后一个选项是使用服务控制管理器查看所有服务.在这里，您需要查看您在机器上运行的 SQL Server 实例.

The final option would be to View All services using the Service Control Manager. Here you will need to look at what instances of SQL Server you have running on the machine.

这篇关于已安装 SQL Server 2008，但运行版本仍为 2005的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！