Post reply

Sql 2005 database mirroring

  • July 17, 2009 at 2:41 am

    #223693

    Any inputs? I tried mirroring but i got this error that network address can't be reach...

  • July 17, 2009 at 3:09 am

    #1026065

    Can you post the complete error message and sp level of your sql server

    [font="Verdana"]Thanks
    Chandra Mohan[/font]

  • July 20, 2009 at 10:50 pm

    #1027410

    Error:

    Ther server network address "TCP://svrbdb:5022" can not be reached or

    does not exist. Check the network address nam and that ports for the local

    and remote endpoints are operational. (Microsoft SQL Server, error: 1418)

    And I'm susing mssql 2005 sp1.

    Thanks!

  • July 21, 2009 at 4:21 am

    #1027497

    I don't know whether your Principal and Mirror servers are on the same LAN, but if not and you have a firewall configured, check that your Principal server has access via the firewall to port 5022.

    If this does not apply then check that port 5022 (the default port for Database Mirroring) is not already being used for something else and if it is, specify another port number during mirroring setup.

    Regards

    Lempster

    (corrected port number from 5033 to 5022)

  • July 21, 2009 at 8:46 pm

    #1028064

    Hi appreciate your comments but the setup is in the same network and ip range. no firewall, no antivirus firewall, and i can telnet and ping the ip address, hostname, and ports. tried using other ports but still no luck.

  • July 22, 2009 at 3:15 am

    #1028160

    Hmm, ok. I notice that you are not using a fully-qualified TCP address, e.g. "TCP://svrbdb..com:5022".

    Try specifying a fully-qualified TCP address.

    Regards

    Lempster

  • July 22, 2009 at 7:17 am

    #1028289

    I didn't think Mirroring was supported until SP2.

    Tim White

  • July 22, 2009 at 7:09 pm

    #1028729

    so mssql sp1 really doesn't work for mirroring?

  • July 22, 2009 at 7:10 pm

    #1028730

    probably i will try doing mirroring in a domain environment...

  • July 23, 2009 at 3:58 am

    #1028822

    Herbie (7/22/2009)

    so mssql sp1 really doesn't work for mirroring?

    It does work in SP1. There have been improvements (performance-wise) in SP2 and SP3.

  • July 23, 2009 at 6:50 pm

    #1029399

    ah ok... i'll try configure mirroring in a domain environment coz probably the problem is on the authentication. in workgroup we need to setup certificates unlike domain its built-in account.

Viewing 11 posts - 1 through 10 (of 10 total)

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