Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Missing Login properties after restore

Author  Topic 

snake
Starting Member

2 Posts

Posted - 2005-08-29 : 23:32:03
Hi all,

I need a favor .... please help. I am working on migrating from SQL server 7 to SQL server 2000, and I can't use the Copy Database Wizard for some reasons, so I wrote several scripts to do this.

1- create databases, just to provide a dummy database
2- create logins, I use the script from microsoft to transfer the
logins and passwords
3- restore databases, i got several databases in the same server
4- autofix the login sid mismatch, if any.
5- assign default database to logins

up to this moment, everything seems working fine, but when I check the properties in the Enterprise Manager, I found that, [ login(a) has access to 2 db (db1 & db2(default server) ) at source server, after I transfer (a) to destination, and assigning db2 as its default server], login(a) has no information on db1 when I check the property in Enterprise manager, however, login(a) has access and rights at db1, how can I the relation retrievable from Enterprise Manager ? Does anyone get any idea ?

Thanks a lot.

Felix.
   

- Advertisement -