Post reply

Database Mirroring in VMRC Plus

  • October 4, 2008 at 7:55 am

    #194379

    Hello room,

    I have setup three SQL Server 2005 SP2 in the Window Server 2003 SP2 that running in VMRC Plus.

    •SERVER027 \INSTP (Principal)

    •SERVER028\INSTW (Witness)

    •SERVER029\INSTM (Mirror)

    The TCP/IP protocols were enable and listener to port 14115.

    I tested a ping to all the servers and it was replied.

    Enclosed is my steps:

    1.Set the DBApps to Full recovery mode

    2.Backup the database and log DBApps

    3.Restored the database and log DBApps with norecovery in Mirror Server.

    Principal Server:

    Create endpoint [sqlMirroring]

    State=started

    As tcp (listener_port = 5024, listener_ip = all)

    For data_mirroring (role = partner, authentication = windows negotiate,

    Encryption = required algotithm RC4);

    Mirror Server:

    Create endpoint [sqlMirroring]

    State=started

    As tcp (listener_port = 5024, listener_ip = all)

    For data_mirroring (role = partner, authentication = windows negotiate,

    Encryption = required algotithm RC4);

    Witness Server:

    Create endpoint [sqlMirroring]

    State=started

    As tcp (listener_port = 5024, listener_ip = all)

    For data_mirroring (role = Witness, authentication = windows negotiate,

    Encryption = required algotithm RC4);

    Mirror Server:

    Alter database DBApps set set partner = ‘TCP://server029.myDomain.com:5024’;

    Error: The server network address "TCP://server029.MyDomain.com:5024" can not be reached or not exist.

    I re-test the ping

    From SERVER027

    -ping SERVER028, and SERVER029 and both repied.

    FROM SERVER028

    -ping SERVER027, and SERVER029 and both replied.

    FROM SERVER029

    -ping SERVER027 and SERVER028 and both replied

    Can anyone help and advice? Or anyone can direct me to an article or links sample step by step how to setup Database Mirroring SQL Server 2005 in VMRC Plus environment?

    Thanks,

    Edwin

  • October 5, 2008 at 12:30 am

    #880885

    I figured it out and it's working now.

    Please ignore this posted. 😀

  • October 7, 2008 at 4:41 am

    #881535

    What was the problem? Can you please share?

  • October 7, 2008 at 10:47 am

    #881813

    I forgot to issues:

    Authorization [MyDomain\UserName] on my create endpoint statement.

    Regards,

    Edwin 😀

Viewing 4 posts - 1 through 3 (of 3 total)

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