RE: Login name is <none>

From: Yuan Shao (v-yshao_at_online.microsoft.com)
Date: 01/14/04 

Date: Wed, 14 Jan 2004 12:41:09 GMT

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.

Relevant Pages

  • RE: How do I set the login name for a user?
    ... If a database is created by a Microsoft Windows NT authenticated login ... database does not have a matching SID in the syslogins system table. ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ... a certain visitor in the Session, and use that value to start the right ...
    (comp.lang.php)
  • Re: conflicting object names in sql server 2000
    ... A login name of michael in the connection string does not mean the user name ... access to a particular database. ... My guess is that the login michael is dbo on one database and not dbo on ...
    (microsoft.public.sqlserver.server)
  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... the postgres user they are logged in as to one that can make ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ...
    (comp.lang.php)
  • RE: How to allow users to change their password?
    ... be set up to provide the Security dialog window for password changes. ... I'll have to login using their login ... > name/password first. ... See http://www.QBuilt.com for all your database needs. ...
    (microsoft.public.access.security)