sql server login problems after restore

[Jake Kemsley]

I have an sql server DB which I populate on a local machine, using enterprise manager I backup the DB and zip it up and upload it to my server where I restore it. Every time I restore it I have to add a new login, which is rather annoying, and it wont let me delete the old login - so I have a list of redundent logins.

[Craig]

Your logins on master..syslogins must have the same suid as the userdatabase..sysusers suid.

You can do this manually by adding the logins to the master database on the receiving server in the same order as the source, or update them with SQL.

Good luck......Craig


------------
Jake Kemsley at 6/6/00 10:04:58 AM


I have an sql server DB which I populate on a local machine, using enterprise manager I backup the DB and zip it up and upload it to my server where I restore it. Every time I restore it I have to add a new login, which is rather annoying, and it wont let me delete the old login - so I have a list of redundent logins.