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
 General SQL Server Forums
 New to SQL Server Programming
 after restore...issues.

Author  Topic 

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-05-09 : 15:36:02
after restoring a .bak from another server.
on EM->DB->users->permissions
i get error 21776 the name 'asdfa'was not found....

also the login name on this same window says <none>.

anyone know how to fix it?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-09 : 15:44:00
Create sql login on target server then remap db user with sp_change_users_login.
Go to Top of Page
   

- Advertisement -