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 |
|
peddi_praveen
Starting Member
48 Posts |
 Posted - 2003-01-23 : 01:10:25
|
| hi all,Iam trying to restore a database using a backup to another server. I have restored successfully.After Restoration, i noticed that user to login mapping is missing in the database.I tried to re-map the user to the login and i had to drop the user and re-create the user and mapped to the login.I had encountered 2 problems in this approach.1.i had to change the (if any)object ownership of the user before dropping it and re-assign the ownership after mapping.2.'dbo' user is still not mapped to sa.still remains orphan.Need your help in right approach to solve this.thnx n regspraveen |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
|
|
adhik
Yak Posting Veteran
66 Posts |
Posted - 2004-01-17 : 10:47:40
|
| Hi Harshal,I am facing same problem.I visited your given link but that page is not available any more on that urlCan you help me?RegardsAdhik |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-01-18 : 19:10:12
|
| Have you tried Chad's script to Fix Orphaned Users? http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=12615--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
|
|
|
|
|
|
login mapping missing