You must use SQL Server 2005 management tools to connect to this server

[font=Arial][size=2]Today, I try to user SQL 2000([color=#ff6600][b]Enterprise Edition[/b][/color]) to connect SQL 2005([color=#ff6600][b]Enterprise Edtion[/b][/color]),but failed with the following message:[/size][/font]

[align=left][color=#ff0000][b][color=#0000ff]----------------------------------------------------------------------------------------------------------------------------------
[/color]SQL Server Enterprise Manager
[color=#0000ff]----------------------------------------------------------------------------------------------------------------------------------
[/color]A connection could not be established to 10.0.23.56.[/b][/color][/align][align=left][color=#ff0000][b]Reason: To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO)..[/b][/color][/align][align=left][color=#ff0000][b]Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the 10.0.23.56 node) and try again.
[color=#0000ff]----------------------------------------------------------------------------------------------------------------------------------[/color]
OK   
[color=#0000ff]----------------------------------------------------------------------------------------------------------------------------------[/color][/b][/color][/align][align=left]
then I try the following method to solve it :[/align]
[align=left][color=#0000ff][b]First try:[/b][/color]
I install the SQL Management Objects from the sql 2005 feature pack at [url=http://www.microsoft.com/downloads/details.aspx?familyid=DF0BA5AA-B4BD-4705-AA0A-B477BA72A9CB&displaylang=en][color=#0000ff]http://www.microsoft.com/downloads/details.aspx?familyid=DF0BA5AA-B4BD-4705-AA0A-B477BA72A9CB&displaylang=en[/color][/url].[/align][align=left][u][color=#ff0000][b]Download and Install[/b][/color][/u] the following software([color=#ff0000]red hightlight sections[/color]) [u][i][color=#ff0000][b]in the SQL 2000 side[/b][/color][/i][/u]:
==============================================
[b][color=#0000ff]Microsoft SQL Server 2005 Management Objects Collection[/color][/b]
The Management Objects Collection package includes several key elements of the SQL Server 2005 management API, including Analysis Management Objects (AMO), Replication Management Objects (RMO), and SQL Server Management Objects (SMO). Developers and DBAs can use these components to programmatically manage SQL Server 2005.[/align][align=left]Note: Microsoft SQL Server 2005 Management Objects Collection requires Microsoft Core XML Services (MSXML) 6.0 and Microsoft SQL Server Native Client, also available on this page.[/align][align=left]Audience(s): Customer, Partner, Developer[/align][align=left]
[color=#ff0000][b]X86 Package (SQLServer2005_XMO.msi) - 9529 KB
[/b][/color]X64 Package (SQLServer2005_XMO_x64.msi) - 14963 KB
IA64 Package (SQLServer2005_XMO_ia64.msi) - 18372 KB
=============================================
[color=#0000ff][b]Microsoft SQL Server Native Client[/b][/color]
Microsoft SQL Server Native Client (SQL Native Client) is a single dynamic-link library (DLL) containing both the SQL OLE DB provider and SQL ODBC driver. It contains run-time support for applications using native-code APIs (ODBC, OLE DB and ADO) to connect to Microsoft SQL Server 7.0, 2000 or 2005. SQL Native Client should be used to create new applications or enhance existing applications that need to take advantage of new SQL Server 2005 features. This redistributable installer for SQL Native Client installs the client components needed during run time to take advantage of new SQL Server 2005 features, and optionally installs the header files needed to develop an application that uses the SQL Native Client API.[/align][align=left]Audience(s): Partner, Developer[/align][align=left]
[b][color=#ff0000]X86 Package (sqlncli.msi) - 3516 KB[/color][/b]
X64 Package (sqlncli_x64.msi) - 6403 KB
IA64 Package (sqlncli_ia64.msi) - 8376 KB[/align][align=left]=============================================
[color=#0000ff][b]Microsoft SQL Server 2005 Backward Compatibility Components
[/b][/color]The SQL Server Backward Compatibility package includes the latest versions of Data Transformation Services 2000 runtime (DTS), SQL Distributed Management Objects (SQL-DMO), Decision Support Objects (DSO), and SQL Virtual Device Interface (SQLVDI). These versions have been updated for compatibility with SQL Server 2005 and include all fixes shipped through SQL Server 2000 SP4.[/align][align=left]Audience(s): Customer, Partner, Developer[/align][align=left]
[color=#ff0000][b]X86 Package (SQLServer2005_BC.msi) - 11258 KB[/b][/color]
X64 Package (SQLServer2005_BC_x64.msi) - 18552 KB
IA64 Package (SQLServer2005_BC_ia64.msi) - 23490 KB[/align][align=left]================================================[/align][align=left]but it still failed and with the another different message:[/align]
[align=left][color=#ff0000][b][color=#0000ff]----------------------------------------------------------------------------------------------------------------------------------[/color]
SQL Server Enterprise Manager
[color=#0000ff]----------------------------------------------------------------------------------------------------------------------------------[/color]
A connection could not be established to 10.0.23.56.[/b][/color][/align][align=left][color=#ff0000][b]Reason: [SQL-DMO]You must use SQL Server 2005 management tools to connect to this server..[/b][/color][/align][align=left][color=#ff0000][b]Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the 10.0.23.56 node) and try again.
[color=#0000ff]----------------------------------------------------------------------------------------------------------------------------------[/color]
OK   
[color=#0000ff]----------------------------------------------------------------------------------------------------------------------------------[/color]
[/b][/color][/align]
[align=left]up to now,I'm very puzzled with the following action:[/align][align=left]I used the Query Analaze of SQL Server 2000 to connect ,it  success without any problem![/align][align=left]but when I tried to Register the SQL Server in the Enterprise Management ,it still always with the [/align][align=left]"[b][color=#ff0000][SQL-DMO]You must use SQL Server 2005 management tools to connect to this server..[/color][/b]"

So amazed for me, who can do me a favor? please , I'll apprecaited for you. ^_^[/align]

[[i] 本帖最后由 123478388 于 2008-6-27 16:19 编辑 [/i]]

帮你顶

just now ,I checked  SQLDMO.DLL file in the SQL2000 Side,and its version 2000.085.1704.00, and I installed the SQL Native Client in SQL 2000 Side before I post the thread in the first time .but it still turn out to be the same error.
Service Pack Information:


SQL SERVER 2000 PC:Sql server 2000 + sp4

SQL SERVER 2005 PC:Sql 2005 +sp2

but after install native client in the sql server 2000 side, then I use "select @@version " in the query analyze,the result is:

" Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)   Feb  9 2007 22:47:07   Copyright (c) 1988-2005 Microsoft Corporation  Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)

", both sides ,the version content is the same. but problem still exists. can you continue help me ?

你的sql2000打了sp4的补丁没？

[quote]原帖由 [i]zengshaojie[/i] 于 2008-6-27 16:25 发表 [url=http://www.itpub.net/redirect.php?goto=findpost&pid=10788667&ptid=1012863][img]http://www.itpub.net/images/common/back.gif[/img][/url]
你的sql2000打了sp4的补丁没？ [/quote]
打了啊，３楼里我回复了。:rolleyes:

[attach]538737[/attach]
就是这个破Error，(怕大家看不清楚。文字)

问了一下
别人说查询分析器是可以
但是企业管理器就不行
因为检测不到服务器

[quote]原帖由 [i]zengshaojie[/i] 于 2008-6-27 17:03 发表 [url=http://www.itpub.net/redirect.php?goto=findpost&pid=10789345&ptid=1012863][img]http://www.itpub.net/images/common/back.gif[/img][/url]
问了一下
别人说查询分析器是可以
但是企业管理器就不行
因为检测不到服务器 [/quote]
我目前知道的也仅仅如此。。。。。不知道是确实就只能这样还是我还需要设置哪些。。。。:try:

嗯
再找找人问问
或查查资料吧

另：你怎么换个女人的头像阿
faint

不行的 得用2005的链接。
这个问题昨天有人问过了。

[quote]原帖由 [i]smthgdin[/i] 于 2008-6-27 19:08 发表 [url=http://www.itpub.net/redirect.php?goto=findpost&pid=10790805&ptid=1012863][img]http://www.itpub.net/images/common/back.gif[/img][/url]
不行的 得用2005的链接。
这个问题昨天有人问过了。 [/quote]
不明白“得用2005的链接”是啥意思。。。。:(