When you view the details of a database user in Microsoft SQL server 2000 you will see that the login name displays as "<none>".
This is also known as an "Orphaned User"
This usually occurs when a database is backed up from a server and restored to another server without restoring the master database.
As a result of this the actual login name that is stored in the master database does not exist and cannot be linked with the user account already existing in the database.
You will need to create the user account that is missing in the master database and then relink it to the user account in the database you restored.
It is recommended that the new user account that you create match the old user account name for simplicity and to easily inherit any objects that user account owned.
REMEMBER TO BACKUP YOUR DATABASE BEFORE PERFORMING ANY OF THESE STEPS
Last Updated: 05/27/2008 01:50 AMblog comments powered by Disqus