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 |
|
Eve
Starting Member
4 Posts |
 Posted - 2002-11-07 : 10:47:32
|
| Hi everyoneWe are trying to move our databases from sql7 on NT4 server to sql7 on windows 2000 server. We tried to restore all the databases including the master database to the new server, that failed as we could not start sql on the new server after the restore. We had to rebuild the master database on the new server, I then backed up all the user databases and restored them to the new server. I created new logins however the user under each database was not restored and I could not recreate them as I was getting error messages. With the help of you guys I got a script that discoved the orphan users and that reinstated the users.My problem now is if I open the SA user or builtin\administrator property through security and logins and I try to click ok I get the following error message"error 21776:[SQL-DMO]the name 'dbo'was not found in users collection. If the name is qualified name, use[]to seperate various part of the name and try again".How do I move forward as I must have an error free server before I can complete the data transferthanksEve |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2002-11-07 : 12:26:11
|
| Dear Eve!It's a pretty situation you've got yourself into, but I think I have the answer. I found your error on the support page of MS, where it is specified as a BUG. On this page, you'l find a solution to your problem too.Go to [url]support.microsoft.com[/url] and type in the number of your error.Good luck! |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-11-07 : 12:51:58
|
| This helps me out too. I was always curious why the error came up but not curious enough because even though you get the error, you are still able to make the change. Now at least I know why. |
|
|
|
|
|
|
Error message in when closing sa user property