Login creation

• Rem70Rem

  SSCertifiable

  Points: 6166

  More actions

  October 15, 2009 at 1:43 pm

  #205643

  Hi,

  I am trying to create a new login like this:

  CREATE LOGIN [AAA\Sales] FROM WINDOWS WITH DEFAULT_DATABASE=[SalesINt], DEFAULT_LANGUAGE=[us_english]

  and I am getting this error:

  The server principal 'AAA\Sales' already exists.

  This login doesn't currently exist. AAA\Sales is a active directory distribution group. When I try to do the same thing on a different server, it works.

  How I can create this user on my production database?

  Thanks,

• Sylvain Coutu

  Ten Centuries

  Points: 1077

  More actions

  October 30, 2009 at 12:47 pm

  #1073331

  Did you create the database from a backup and restore operation or attached detach?

  If so it is possible that the user exist in your database but not on master. That would be why would get this error.

  So try to remove the login in your database even if it is not showing in SSMS. Then reissue the create statement.

  There's a way to remap logins when they are out of sync.

  http://msdn.microsoft.com/en-us/library/ms174378(SQL.90).aspx