You must have instance name for sql server 2000..

Try to connect SQL sever 2000 instance. It must be your named instance because you have installed SQL 2005 first as default instance.

Did you uninstall SQL server 2005 and install SQL 2000 on same server?

Did you rebooted your server after uninstallation?

Make sure the compability level is 80.

Thanks for the reply Dan.

That mean we just need to coordinate with microsoft on paper?

Thanks,

sshah

Thanks mark..

I unchecked that check box and restart SSMS and i can see all the system databases.  Thanks again!!!

sshah

I use SP_help_revlogin for login transfer.

Below is a link from which you can get this SP.

http://support.microsoft.com/kb/246133/

Thanks,

Sshah

This is really great and once again thanks..

Yes. some short of script or SP or anything which can truncate all the tables including login info and i will get database structure back.

Thanks so much ...

Article has cleared all the doubt.

BCP and Bulk insert method is good to avoid transaction log.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ba-bz_4fec.asp