SQL 2000. I've created a login for W2K Group Mydomain\Domain admins,
and gave it access to the DB. When I add it as a user, the login name
changes to <none>. I don't understand why. It does not happen to the
other logins.
If I am missing something basic, I would appreciate a pointer to a KB
or technet article or whatever, explaining what that is.
Thanks a lot,
PeterHi Peter,
My name is Michael and I would like to thank you for using Microsoft
newsgroup.
According to your description, I understand that you create a login in SQL
Server 2000 for domain account and add this login as a user of a specific
database. However, the login name changes to <none>. In other words, the
user in the database does not match any logins. If I have misunderstood,
please feel free to let me know.
Based on my experience, it seems that you experience the orphaned user.
Logins are associated to users by the security identifier (SID), and if the
SID is inconsistent after you move a database, SQL Server may deny the user
access to the database. This problem is known as an orphaned user.
The suggestions in the following articles should address your problem.
274188 PRB: "Troubleshooting Orphaned Users" Topic in Books Online is
Incomplete
http://support.microsoft.com/?id=274188
314546 HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546
Please feel free to post in the group if this solves your problem or if you
would like further assistance.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.|||Hi Michael,
Thanks for the reply.
You understand the problem correctly.
I think I might have orphaned users as well, but I believe I the
answer to this particular problem which involves domain admins group
was in KB 819261
Regards,
Peter
On Wed, 14 Jan 2004 12:41:09 GMT, v-yshao@.online.microsoft.com ("Yuan
Shao") wrote:
quote:|||Hi Peter,
>Hi Peter,
>My name is Michael and I would like to thank you for using Microsoft
>newsgroup.
>According to your description, I understand that you create a login in SQL
>Server 2000 for domain account and add this login as a user of a specific
>database. However, the login name changes to <none>. In other words, the
>user in the database does not match any logins. If I have misunderstood,
>please feel free to let me know.
>Based on my experience, it seems that you experience the orphaned user.
>Logins are associated to users by the security identifier (SID), and if the
>SID is inconsistent after you move a database, SQL Server may deny the user
>access to the database. This problem is known as an orphaned user.
>The suggestions in the following articles should address your problem.
>274188 PRB: "Troubleshooting Orphaned Users" Topic in Books Online is
>Incomplete
>http://support.microsoft.com/?id=274188
>314546 HOW TO: Move Databases Between Computers That Are Running SQL Server
>http://support.microsoft.com/?id=314546
>Please feel free to post in the group if this solves your problem or if you
>would like further assistance.
>Regards,
>Michael Shao
>Microsoft Online Partner Support
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and confers no rights.
Thanks for your feedback. Is this orphaned user problem resolved? Did you
mean you tried the workarounds mentioned in the following article and the
problem was resolved?
819261 BUG: Error 15023, 15024 or 21002 Occurs When You Try to Add a Domain
http://support.microsoft.com/?id=819261
If not, I would like you to try the suggestions(KB 274188 & KB 314546)
mentioned in my previous post to see if it fix the orphaned user problem.
I am looking forward to hearing from you soon.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.|||HI Michael,
Yes, this particular problem seems to be resolved by following the
workaround in that KB article, although I haven't had time to really
confirm it. Just looking at EM, it seems okay now.
What I was trying to say was I think there is a completely separate
problem with some other ophaned users and I will be looking at those
other articles next week. If they suggest using sp_change_users_login,
then please take a look on a problem I will post later on today on
with that sp in the subject.
Thanks,
Peter
On Thu, 15 Jan 2004 06:33:53 GMT, v-yshao@.online.microsoft.com ("Yuan
Shao") wrote:
quote:
>Hi Peter,
>Thanks for your feedback. Is this orphaned user problem resolved? Did you
>mean you tried the workarounds mentioned in the following article and the
>problem was resolved?
>819261 BUG: Error 15023, 15024 or 21002 Occurs When You Try to Add a Domain
>http://support.microsoft.com/?id=819261
>If not, I would like you to try the suggestions(KB 274188 & KB 314546)
>mentioned in my previous post to see if it fix the orphaned user problem.
>I am looking forward to hearing from you soon.
>Regards,
>Michael Shao
>Microsoft Online Partner Support
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and confers no rights.
No comments:
Post a Comment