Mirroring with Witness

Discussion in 'microsoft.public.sqlserver.replication' started by M.McDanold, Aug 9, 2006.

  1. M.McDanold

    M.McDanold Guest

    I am having trouble setting up database mirroring with a witness. Setting up
    mirroring without a witness is working fine. But when I try to set up a
    witness, using either the Wizard or direct T-SQL, error 1456 appears, “The
    alter database command could not be sent to remote server
    TCP://MyFileServer.abcde.local:5022â€

    Server A and Server B are running SQL Server 2005 Enterprise ed.
    Server C is an installation of SQL Express running on a remote file server.

    All 3 SQL Server servers run in the same domain and the endpoints have been
    set up and connection permissions granted.

    Querying the sys.database_mirroring_endpoints on each server yields these
    results:

    Server EndPoint Role ConnAuthority
    Encrpt?

    Server A Started Partner Negotiate
    No
    Server B Started All Negotiate
    No
    Server C Started Witness Negotiate
    Yes

    I have used command prompt “netstat –abn†to confirm that the witness is
    listening on the designated port (and no other processes are using that port).

    So everything I can check looks OK, but I can’t get the mirroring to start.

    Any ideas?
     
    M.McDanold, Aug 9, 2006
    #1
    1. Advertisements

  2. Open the Surface Area Configuration Manager and connect to the SQL Express
    Edition. By default Express Edition is set to local only connections. You
    need to change it to local and remote connections. Then you will be able to
    connect to it and configure it as a witness.
     
    Michael Hotek, Aug 11, 2006
    #2
    1. Advertisements

  3. M.McDanold

    M.McDanold Guest

    Hi Mike,

    I appreciate your comments back to me. Unfortunately we had already tried
    what you suggested. As it turns out the solution for us was to change the
    default end-point port of 5022 to something else and it worked just fine.
    I'm not sure why MS did not document this and suggest changing it. Again,
    many thanks for replying to my post.

    Mat
     
    M.McDanold, Aug 28, 2006
    #3
  4. M.McDanold

    Ross Grant Guest

    Ross Grant, May 26, 2010
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.