1

Getting an error in SQL Server 2000 Enterprise manager - Please see in the attached screenshot!

Kindly help how to overcome the issue

enter image description here

Christian.K
  • 47,778
  • 10
  • 99
  • 143
venkat
  • 5,648
  • 16
  • 58
  • 83
  • One screenshot is sufficient. Also note, that you can easily copy/paste the message text of a Windows message box by pressing `Cltr+C` while the message box has focus, thus not needing a screenshot at all. – Christian.K Apr 20 '12 at 08:59

2 Answers2

3

You have to install the backward compatibility package. You can download it from here.The file is called SQLServer2005_BCxxx.msi

David Brabant
  • 41,623
  • 16
  • 83
  • 111
1

You're trying to access a SQL Server 2005 instance using SQL Server 2000's Enterprise Manager, which isn't possible. You need to install a copy of SQL Server Management Studio - the 2008 R2Express version should be fine, or you can dig out the 2005 version

MartW
  • 12,348
  • 3
  • 44
  • 68
  • Hello, Seems you are not understand my issue properly. I'm not trying 2005/2008 instances in 2000 SQL. As David said `Backward compatibility` Package is needed for that issue/error. – venkat Apr 20 '12 at 12:02
  • That backward compatibility package is so that SQL Management Studio 2005 can fully interact with SQL 2000 instances, especially DTS packages. Your screenshot shows the SQL Server Enterprise Manager which comes with SQL Server 2000, and that it is trying to connect to an instance of SQL Express which only exists with SQL Server 2005+. – MartW Apr 20 '12 at 13:13
  • Your heading, however, mentions SQL-DMO which is covered by the compatibility package. – MartW Apr 20 '12 at 13:17