connect db SQL Analyzer from SQL 2008 DB

• SQL Galaxy

  One Orange Chip

  Points: 29479

  More actions

  April 17, 2010 at 7:54 am

  #220616

  Hi friends,

  I can able to registered SQLserver2000 in SQL 2008 box.

  Is it possible for connecting thru Query Analyzer from sql 2008 database? pl. suggestion me.

  Is it required addtional patch in SQL 2000 box?

  Thanks

• shen-dest

  SSCrazy

  Points: 2498

  More actions

  April 19, 2010 at 2:03 am

  #1153629

  hi,

  you can definitely register SQL2000 instances in SQL2008 via SSMS and also SQL2k8 Query Analyzer to connect sql2000 databases.

  open a sql2008 QA right click in QA select Connection->Change Connection and enter sql2000 host and login infos.

  Regards,
  MShenel

• Ananda-292708

  Ten Centuries

  Points: 1339

  More actions

  April 19, 2010 at 2:17 am

  #1153639

  i can connect from SQL 2000 QA to a SQL 2008 instance with out any issue. From enterprise manager you cannot connect to SQL 2005 or 2008