I am looking to manage a SQL Server 2008 DB using Management Studio 2005. The reason for this is because our server is a 64-bit machine and we only have the 64-bit version of the software.
我希望使用Management Studio 2005管理SQL Server 2008数据库。原因是我们的服务器是64位计算机，我们只有64位版本的软件。
Is this possible?
这可能吗？
How about managing a SQL Server 2005 DB using Management Studio 2008?
如何使用Management Studio 2008管理SQL Server 2005数据库？
4 个解决方案
#1
21
UPDATE: You can use Cumulative update package 5 for SQL Server 2005 Service Pack 2 to connect to 2008.
更新：您可以使用SQL Server 2005 Service Pack 2的累积更新包5连接到2008。
FIX: 50002151 946127 (http://support.microsoft.com/kb/946127/) FIX: You may experience problems when you use SQL Server Management Studio in SQL Server 2005 to connect to an instance of SQL Server 2008
FIX：50002151 946127（http://support.microsoft.com/kb/946127/）FIX：您在SQL Server 2005中使用SQL Server Management Studio连接到SQL Server 2008的实例时可能会遇到问题
#2
13
The other question you asked was about managing 2005 servers with SSMS 2008 - and yes, you can do that. SSMS 2008 can manage 2008, 2005, 2000. I actually recommend that everybody use the latest SSMS 2008 client regardless of what server they're connecting to, because it has some nice perks and upgrades that work with all server versions that you connect to.
您问的另一个问题是使用SSMS 2008管理2005服务器 - 是的，您可以这样做。 SSMS 2008可以管理2008年，2005年，2000年。我实际上建议每个人都使用最新的SSMS 2008客户端，无论他们连接的服务器是什么，因为它有一些很好的额外优惠和升级，适用于您连接的所有服务器版本。
Be aware that SSMS 2008 has IntelliSense, but only when you connect to a SQL 2008 server. If you connect to a 2005 server, you don't get IntelliSense.
请注意，SSMS 2008具有IntelliSense，但仅在连接到SQL 2008服务器时才有。如果连接到2005服务器，则不会获得IntelliSense。
#3
3
I'm posting this to prevent people getting false hope (as I did). Where as you may be able to use SQL Server 2005 Management Studio to connect to SQL Server 2008, you cannot use SQL Server 2005 Management Studio Express. You get an explicit error message stating:
我发布这个是为了防止人们得到错误的希望（正如我所做的那样）。您可以使用SQL Server 2005 Management Studio连接到SQL Server 2008，但不能使用SQL Server 2005 Management Studio Express。您收到一条明确的错误消息，指出：
This version of Microsoft SQL Server Management Studio Express can only be used to connect to SQL Server 2000 and SQL Server 2005 servers. (Microsoft.SqlServer.Express.ConnectionDlg)
此版本的Microsoft SQL Server Management Studio Express只能用于连接到SQL Server 2000和SQL Server 2005服务器。 （Microsoft.SqlServer.Express.ConnectionDlg）
Hopefully that will prevent a couple of people from wasting their time trying just-in-case.
希望这会阻止一些人浪费时间尝试这种情况。
#4
-1
unless I'm mistaken and things have changed, you cannot use sql server 2008 to save a backup which restores to sql server 2005. I found this out the hard way :(
除非我错了并且事情已经改变，你不能使用sql server 2008来保存恢复到sql server 2005的备份。我发现这很难：{
#1
21
UPDATE: You can use Cumulative update package 5 for SQL Server 2005 Service Pack 2 to connect to 2008.
更新：您可以使用SQL Server 2005 Service Pack 2的累积更新包5连接到2008。
FIX: 50002151 946127 (http://support.microsoft.com/kb/946127/) FIX: You may experience problems when you use SQL Server Management Studio in SQL Server 2005 to connect to an instance of SQL Server 2008
FIX：50002151 946127（http://support.microsoft.com/kb/946127/）FIX：您在SQL Server 2005中使用SQL Server Management Studio连接到SQL Server 2008的实例时可能会遇到问题
#2
13
The other question you asked was about managing 2005 servers with SSMS 2008 - and yes, you can do that. SSMS 2008 can manage 2008, 2005, 2000. I actually recommend that everybody use the latest SSMS 2008 client regardless of what server they're connecting to, because it has some nice perks and upgrades that work with all server versions that you connect to.
您问的另一个问题是使用SSMS 2008管理2005服务器 - 是的，您可以这样做。 SSMS 2008可以管理2008年，2005年，2000年。我实际上建议每个人都使用最新的SSMS 2008客户端，无论他们连接的服务器是什么，因为它有一些很好的额外优惠和升级，适用于您连接的所有服务器版本。
Be aware that SSMS 2008 has IntelliSense, but only when you connect to a SQL 2008 server. If you connect to a 2005 server, you don't get IntelliSense.
请注意，SSMS 2008具有IntelliSense，但仅在连接到SQL 2008服务器时才有。如果连接到2005服务器，则不会获得IntelliSense。
#3
3
I'm posting this to prevent people getting false hope (as I did). Where as you may be able to use SQL Server 2005 Management Studio to connect to SQL Server 2008, you cannot use SQL Server 2005 Management Studio Express. You get an explicit error message stating:
我发布这个是为了防止人们得到错误的希望（正如我所做的那样）。您可以使用SQL Server 2005 Management Studio连接到SQL Server 2008，但不能使用SQL Server 2005 Management Studio Express。您收到一条明确的错误消息，指出：
This version of Microsoft SQL Server Management Studio Express can only be used to connect to SQL Server 2000 and SQL Server 2005 servers. (Microsoft.SqlServer.Express.ConnectionDlg)
此版本的Microsoft SQL Server Management Studio Express只能用于连接到SQL Server 2000和SQL Server 2005服务器。 （Microsoft.SqlServer.Express.ConnectionDlg）
Hopefully that will prevent a couple of people from wasting their time trying just-in-case.
希望这会阻止一些人浪费时间尝试这种情况。
#4
-1
unless I'm mistaken and things have changed, you cannot use sql server 2008 to save a backup which restores to sql server 2005. I found this out the hard way :(
除非我错了并且事情已经改变，你不能使用sql server 2008来保存恢复到sql server 2005的备份。我发现这很难：{