Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2004
    Posts
    191

    Unanswered: Password for replication

    I have a server that I will need to uninstall SQL Server and then install it again because of missing files.

    I need to bring the back to the way it is or was. My problem is replication.
    Since I am new one knows the Administrative Link password. When I try to generate script for replication for the password it uses the 'N'.

    Is there a way to work around this problem? Please advise.

    Thanks

    Lystra

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Can't you go into the distributor properties and set a new password?

    -PatP

  3. #3
    Join Date
    Jul 2004
    Posts
    191
    But wouldn't I need to change it at 2 places?

    If I do change it will it interupt anything?

    Lystra

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    If you are going to trash your existing server, you'll interrupt things a bit in the process. Changing the password will have little additional affect.

    I'd take a systemic approach to your problem:

    1) Declare downtime
    2) Script, then remove replication completely
    3) Detach all of the databases from the affected server
    4) Rebuild the affected server
    5) Reattach the databases to the affected server
    6) Recreate replication from the script (this will reset the password to an empty string)
    7) Collapse in a heap for about 16 hours or so

    -PatP

Posting Permissions

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