Post reply

Mirroring issue

  • February 6, 2012 at 10:00 pm

    #254960

    Hi All,

    I am trying to add a witness server for High availability but not able to add & even i tried witness server as a mirror server than also i am not able to configure. When i doing this activity getting error (Attachment). I check the below things

    1. Service pack (all server same)

    2. SQL Service & agents all are running in domain

    3. Surface configuration (TCP & Pipe name selected)

    And i am able to connect through Instance name As well as IP also but not able to configure mirror or witness.

    Please advice me what shall i do for this...

    Thanks in Advance...

    Satish

  • February 7, 2012 at 12:06 am

    #1443547

    Have you created and configured the mirroring endpoint on the witness instance?

    How are you adding the witness, via the GUI or T-SQL?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • February 7, 2012 at 12:09 am

    #1443550

    Hi,

    I tried both T-SQL & GUI.....

  • February 7, 2012 at 12:16 am

    #1443552

    Hi

    1): Make sure that on Mirror Server the database is restored with NO RECOVERY option (This is the most common problem).

    2): Make sure that from Principal the latest LOG backup is restored to mirror server. (Attempt this one more time even though the full backup has been restored recently).

    3): Check if you can telnet to your ports using command TELNET ServerName Ports like “telnet SQLServerName 5023?.

    4): Make sure your firewall is turned off.

    5): Verify that the endpoints are started on the partners by using the state or state_desc column the of the sys.database_mirroring_endpoints catalog view. You can start end point by executing an ALTER ENDPOINT statement.

    6): Try the following command as one of the last options.

    GRANT CONNECT ON ENDPOINT::Mirroring TO ALL

    7): Delete the end points and recreate them.

  • February 7, 2012 at 12:33 am

    #1443559

    Hi

    Point 1 & 2 is not an issue..

    3):I am able to do telnet 5022 but “telnet SQLServerName 5023? not happening

    4): Already firewall is turned off.

    5): Mirroring655362642TCP4 DATABASE_MIRRORING0STARTED03ALL13NEGOTIATE01RC4Verify that the endpoints .

    6): Getting error :- Error syntex near all

    Let me know what shall i do........

  • February 7, 2012 at 1:34 am

    #1443578

    saidapurs (2/7/2012)

    5): Mirroring655362642TCP4 DATABASE_MIRRORING0STARTED03ALL13NEGOTIATE01RC4.

    Which instance is this result set from?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • February 7, 2012 at 3:09 am

    #1443622

    Hi,

    All updates from PRIMARY instance......

    Thanks & Regards

    Satish

  • February 7, 2012 at 3:12 am

    #1443623

    Hi,

    I want to say one thing i am able to configure mirroring without witness but not able to configure witness.

    Assume :- 1 is Primary, 2 is Mirror & 3 is Witness...

    in this case i tried to use 3 as a mirror server but their also failed, if i use 2 as a mirror it's working fine....

  • February 7, 2012 at 3:27 am

    #1443630

    saidapurs (2/7/2012)

    Hi,

    All updates from PRIMARY instance......

    Thanks & Regards

    Satish

    Execute the query you were given against the witness instance and post back the results

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • February 7, 2012 at 3:49 am

    #1443638

    Hi Perry,

    I am getting same error...

    Thanks & Regards

    Satish Saidapur

  • February 7, 2012 at 4:26 am

    #1443655

    saidapurs (2/7/2012)

    Hi Perry,

    I am getting same error...

    Thanks & Regards

    Satish Saidapur

    You're getting an error running the following against your witness instance?????

    select * from sys.database_mirroring_endpoints[/Code]

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • February 7, 2012 at 9:27 pm

    #1444273

    Hi Perry,

    After executing the query i am getting below details...

    1. PRIMARY SERVER :-

    Mirroring655362652TCP4DATABASE_MIRRORING0STARTED01PARTNER13NEGOTIATE01RC4

    2. Witness Server :-

    Mirroring6553612TCP4DATABASE_MIRRORING0STARTED03ALL13NEGOTIATE01RC4

  • February 8, 2012 at 1:03 pm

    #1444738

    Let's start with basics

    do the SQL server services on each instance run under the same domain account or a different domain user account?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • February 8, 2012 at 11:31 pm

    #1444879

    Hi Perry,

    All are under same domain...

    I tried from 1st it self....

    I logged in in Primary server & logging primary Database than connect Mirror & witness server through Instance name it is connecting fine (Mean not a port issue).

    Then i tried to configure Mirroring with witness server it's giving error as attached in 1st mail but i am able to configure mirroring without witness...

    Please advice me is it server issue or N/W issue or SQL issue??

    Thanks & Regards

    Satish Saidapur

  • February 9, 2012 at 12:35 am

    #1444901

    Ok, which ports are you using for principal, mirror, witness?

    what did this mean below

    saidapurs (2/7/2012)

    3):I am able to do telnet 5022 but “telnet SQLServerName 5023? not happening.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 1 through 15 (of 20 total)

You must be logged in to reply to this topic. Login to reply