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.
| Author |
Topic |
|
venkath
Posting Yak Master
202 Posts |
 Posted - 2006-10-09 : 09:33:05
|
| Hi allI have restored a database from one server ton another server, when i am trying to map the logins, i am getting the following errorUSE MASTERsp_change_users_login 'AUTO_FIX',ocs55ERROR:Server: Msg 15291, Level 16, State 1, Procedure sp_change_users_login, Line 88Terminating this procedure. The User name 'ocs55' is absent or invalid.How to resolve this issue..Thanks in advance |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-10-09 : 11:11:30
|
| sp_change_users_login changes the login for a user in the current database, so don't use master before you run it, use the database that you restored. |
 |
|
|
|
|
|
Unable to map the logins