Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Posts
    91

    Unanswered: URGENT!!! - SQL Server Authentication User - Missing Login Name

    Can someone please help me with troubleshooting my SQL Server authenticated user. One of the users that I created has a login name of <None>. I am unable to delete this user and recreate his login nor plug in a login name. I believe that there is a script to correct this problem but I am having trouble researching it. I am working under the gun to resolve this issue so anyones help with the issue is much appreciated.

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Just to clarify; is this a server login or a database user that has a login name of <None>. I'm guessing it is the latter. If so, it simply means that the database user name has somehow been unlinked from the syslogins table in the master database.

    Lookup sp_change_users_login in SQL BOL. You should be able to run it something like this:

    Code:
    -- Get a report of all unlinked db users in the db (must be run 
    -- separately for each db)
    sp_change_users_login 'report'
    go
    Code:
    -- Fix each user (I prefer to do it one at a time instead of using AUTO)
    sp_change_users_login 'update_one','[db_user_name]','[server_login]'

    Regards,

    hmscott
    Have you hugged your backup today?

  3. #3
    Join Date
    Nov 2005
    Posts
    91
    Thanks for the help hmscott!!!...This solved my problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •