Results 1 to 2 of 2

Thread: Valid user

  1. #1
    Kurian Thomas Guest

    Valid user

    Hello:
    I am getting an error:
    User id 12 is not a valid user in database Dest_db
    While using Database object transfer.

    Using mixed security on the source database.
    copy data and replace existing data options are selected.

  2. #2
    Craig Guest

    Valid user (reply)

    When you move security information from one server to another you must maintain the foreign key relationship between master..syslogins and userdb..sysusers. Recreate security on the destination server and this error will go away.


    ------------
    Kurian Thomas at 6/17/99 1:02:27 PM

    Hello:
    I am getting an error:
    User id 12 is not a valid user in database Dest_db
    While using Database object transfer.

    Using mixed security on the source database.
    copy data and replace existing data options are selected.

Posting Permissions

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