Friday, February 10, 2012

Can't connect from SQL Server 2000 Enterprise Manager

I have two servers, one have SQL Server 2000 and another has CTP2005. I am trying to register the newly installed CTP 2005 in Enterprise Manager of SQL Server 2000, but failed.
I have make sure that SQL Browser is started and TCP/IP protocol is enabled in the configuration manager. I stopped also all firewalls between the two servers. But I still cannot find the CTP. The error message seem to be some Japanese like "...SQL Server Management Studio...SQL Server Management Object(SMO)..." where ...are Japanese.
However, I have no problem registering SQL Server 2000 to SQL Server Management Studio.
Please help. Thanks.Enterprise Manager in SQL Server 2000 cannot manage SQL Server 2005 isntances. However, SQL Sever Management Studio in SQL Server 2005 can manage SQL Sever 2000 instances.|||Thats not entirely true. You will not be able to manage SQL server 2000 services from SQL server 2005 Management Console .

Microsoft documentation clearly specifies this:

"SQL Server 2000 services cannot be managed with SQL Server Management Studio or SQL Server Configuration Manager. Use SQL Server 2000 Enterprise Manager to change service accounts, Service Manager to start and stop services, Server Network Utility to manage server protocols, and Client Network Utility to manage client protocols and aliases"

No comments:

Post a Comment