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 |
|
skillile
Posting Yak Master
208 Posts |
 Posted - 2002-07-02 : 11:00:46
|
| I have a SQL 7.0 db that I have restored to a new sql 7 box withnew master, msdb tables. The best that I see is that users werelogged in when the backup was done. As I restore the file the users show is sysusers but I can't remove them with sp_dropuseror sp_change...Any ideas.Thanksslow down to move faster... |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2002-07-02 : 12:45:55
|
| would the change_user SP mentioned below be of any help to you....take care I haven't tried it myself?....and note that it is discussed in terms of an upgrade to Sql2000....check with chadmat....http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=12403 |
 |
|
|
monkeybite
Posting Yak Master
152 Posts |
Posted - 2002-07-02 : 12:58:18
|
| If you restored the database to a different server, the users in your database no longer map to logins on the new server. You will need to do two things:1. Transfer or create logins on your new server that will map to the users in your database2. Syncronize the users to the logins using master.dbo.sp_change_users_loginYou'll find more info on how to do this in the forum listed above.-- monkey |
|
|
|
|
|
|
Orphaned users