Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    268

    Unanswered: sp_change_users_login

    Hi All,

    I am trying to run this stored procedure and I am getting a following error message:

    Server: Msg 15291 Terminating this procedure. The User name 'bleach' is absent or invalid.

    Can you tell me how I can fix it? Thanks.

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    More context is needed to answer your question. My first guess is that you are running this command in the wrong database. Ie, you are logged into the master database (your default database), trying to correctly associate a db user to a login in another database.

    What is the full command that you are trying to run (include parameters)?

    Regards,

    hmscott

    Quote Originally Posted by inka
    Hi All,

    I am trying to run this stored procedure and I am getting a following error message:

    Server: Msg 15291 Terminating this procedure. The User name 'bleach' is absent or invalid.

    Can you tell me how I can fix it? Thanks.
    Have you hugged your backup today?

Posting Permissions

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