SQL USER's ADMIN RIGHTS ON RESTORED DATABASE

Question

Thanks in advance for help.

 

Could someone please help me for SWL backup restoration and db by user

 

I restored SQL 7.0 database to SQL 2000. ( by creating empty db on SQL 2000 and restored  from SQL 7 backup) -- restore ok..

I need to use same SQL user which is admin for DB on  SQL 7,  for  SQL 2000 also. (  DB user is sql user not domain user)

I put mixed authentication mode ( windows and SQL) in SQL 2000 enterprises manager security tab setting.  

I can see DB user is available in DB user list on restored DB but can not access DB when I try to access from query analyser

I tried to create new login with same name as it was in SQL 7 and tried to give full admin access on SQL 2000 enterprise manager but I get error 21002:[ SQL DMO] User 'user' already exists.

 

Kind Regards

Sunod