Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help, No Accounts after Restore
Message
General information
Forum:
Microsoft SQL Server
Category:
Recovery
Miscellaneous
Thread ID:
00449322
Message ID:
00449868
Views:
16
Remember that database users are mapped to logins. Since you restored to another server, the logins probably don't exists. This is a common occurance and MS provides a system stored procedure to help get things worked out. Check out sp_change_users_login in the BOL.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform