SQL server 2008 R2 mirroring

Posted on 2011-05-04
Last Modified: 2012-05-11
I just Installed a fresh OS and sql 2008 R2 on two boxes and uninstalled sql 2005 reinstalling sql 2008 R2 on a third.  The two fresh installs are my principal and mirror instances and the third box i had planned on using as a witness.  Every time i try to add the witness i get a message:

The ALTER DATABASE command could not be sent to the remote server instance 'TCP://server.domain:5022'.  The databas mirroring configuration was not changed.  Verify the the server is connected and try again. (microsoft sql server, error 1456)

The mirroring is actually working with out the witness but i would like to try and use a witness if possible.  After some research i have found some info about the issue but so far nothing seems to help.
Question by:IKtech
    LVL 18

    Accepted Solution

    try this

    I've used this to set up a mirroring and it worked pretty good.
    LVL 3

    Author Comment

    I've got the databases mirrored already i just wanted to add a witness.  Do I need to create these certs just to use a witness server?
    LVL 3

    Author Closing Comment

    I got to step three in the instructions and decided to remove the changes i had made.  After i removed the cert i created and the key i tried the mirroring again and it worked.  Don't know exactly what fixed it however it is working.  Thanks.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now