Monday, February 20, 2012

Register CTP to Enterprise Manager

Is it possible to register SQL Server 2005 to Enterprise Manager of SQL Server 2000? If yes, what are the components that need to installed on the machine having the Enterprise Manager?
Thanks.SQL 2000 Enterprise Manager cannot be used to manage a SQL 2005 server. Unfortunately you will need to reinstall SQL 2005 tools which can then be used to manage your SQL2000 as well as SQL 2005 installs|||If Enterprise Manager cannot find CTP 2005, how about applications that used to connect to SQL Server 2000 using a common connection string in ADO.NET 1.1?
I am afraid our application cannot switch to CTP 2005.
Any advice is appreciated. Thanks.|||Hello,

The ADO.NET 1.1 connection and application will work fine with SQL Server 2005.

The issue is for application that uses SQL Server 2000 DMO (DMO 8.0) to connect SQL Server 2005 will see similar error.

For example, SQL Server 2000 Query Analyzer will work fine with SQL Server 2005 as it do not uses DMO 8.0.

hth,
Rajesh Patel|||I see, I see.
Thanks.

No comments:

Post a Comment