Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2011
    Posts
    12

    Unanswered: Problem With Mirroring

    hi,

    I have a database and I mirror it with another server, And it works well.
    In source server I have some Sql Server users and I want to mirror it to the destination server, for example if I change the password in source it is changed
    in destination, what is the best solution for that?!

    Tnx

  2. #2
    Join Date
    Sep 2011
    Posts
    31
    Quote Originally Posted by madadi028 View Post
    hi,

    I have a database and I mirror it with another server, And it works well.
    In source server I have some Sql Server users and I want to mirror it to the destination server, for example if I change the password in source it is changed
    in destination, what is the best solution for that?!

    Tnx
    when u create users in principal, they will be copied over to mirror. however their logins wont be, so essentially they will be useless.
    You can script the new logins from principal and re-create them on mirrored instance.

  3. #3
    Join Date
    Aug 2011
    Posts
    12

    Reply

    Thank you for your answer.

Posting Permissions

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