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 |
|
ramsfield
Starting Member
9 Posts |
 Posted - 2006-03-30 : 15:04:27
|
I have a database that has been running for some time without problems. We have recently built a new server and are in the process of moving the database from the old to the new. When I use the import / export wizard, the process starts fine but then fails with the error message quote:
User or role Fareed does not exist in the database
Although Fareed was a user at one time, he has been removed a couple of years ago. I can not find any references to this user. What is causing this error message and how can I make it go away so that I can use import / export? |
|
|
ramsfield
Starting Member
9 Posts |
Posted - 2006-03-30 : 15:18:18
|
| Although the user did not have an account, after running EXEC sp_dropuser 'Fareed' the error went away. |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-03-31 : 09:57:20
|
| When DB's move to other servers, the users assigned to them get different 'internal' numbers when recreated in the new server. This is a common problem. Search here for "orphan users" in the FAQ post by Kristen. |
|
|
|
|
|
|
Ghost user