login access problem

• bryan99y

  SSCarpal Tunnel

  Points: 4672

  More actions

  June 28, 2002 at 7:02 am

  #64333

  [SQL Server 2000 Enterprise]

  I just restored a user database to another server. I am trying to give the login name for that databaase access to it. There is an error message that "the user already exists" (which it does. It came with the restore).

  I try to drop the user but it owns some user defined data types, which I can't seem to change the owner of. I would drop the login and recreate it but it is in use by another database.

  any ideas how I can give this login access?

• David Benoit

  SSC-Dedicated

  Points: 34562

  More actions

  June 28, 2002 at 7:16 am

  #431824

  Check out this article. It should help.

  http://www.sqlservercentral.com/columnists/nboyle/fixingbrokenlogins.asp

  David

  David

  @SQLTentmaker

  “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot