Access Sql 2005 from sql 2000

Hi,

I access the sql 2000 db's . Now, the dbs have been moved to 2005. Is it possible to connect to sql 2005 db from sql enterprise manager 2000. Or let me know if I have to upgrade to 2005 to access the same.

I get the error message To connect to the server you must use sql server management studio or sql server management objects(SMO) when trying to access the server from sql enterprise manager 2000.

Usually it is not possible to access higher version dbs from a lower version.

Please help me out as soon as possible as this is very urgent.

Thanks & Regards,

K. Sripriya

Hi Sripriya K,

You will have to upgrade to sql 2005 management studio to manage sql 2005 database's
|||Priya you cannot access your SQL 2005 databases from SQL 2000 enterprise manager but vice-versa is possible......Yes you need to have SQL 2005 to access the same.......also you cannot restore sql 2005 dbs backup file in sql 2000.....and you also cannot perform detach and attach sql 2005 dbs in sql 2000|||If you are using SQL Express then you need the install SQL Management Express seperately, from there you can access your sql.
Download SQL Mangament Express

If you have other edition then you will have management studio installed already.
Goto run, type sqlwb, press enter.. You will get management studio to connect to sql 2005 server.

You cant use EM to connect to a Sql 2005 machine, but you can use query analyser to connect to sql 2005 server.