Data base mirroring

  • Hi,

    when i configuring Database mirroring in Sql server 2005 standard edition & windows server 2008.

    work group environment.

    the below error is coming.

    Error: 1418 - Microsoft SQL Server - The server network address can not be reached or does not exist. Check the network address name and reissue the command.

    plz help me

    Subha

  • Check to see that the 'mirror' server is reachable from your 'principal' (ie rdp to it and go into ssms and try to connect).

    Ensure that the account you are trying to connect the mirror service with/as has apprpriate access to the mirror server (we use the same domain account as its our main sql service account).

    Try the above and let me know.

    Thanks,

    Adam

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • Hi,

    we are using work group(VM).

    Plz help me, very urgent.

    Subha

  • Did you try any of Adam's advice?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Hi Gail,

    i followed, but not getting,

    plz help me.

    Subha

  • subha.mcts2005 (12/7/2010)


    Hi Gail,

    i followed, but not getting,

    plz help me.

    Subha

    How do you mean, what dont you get?

    Can you connect to the SQL server instance that your mirror is to be based on from you principal SQL instance?

    Adam Zacks-------------------------------------------Be Nice, Or Leave

Viewing 6 posts - 1 through 5 (of 5 total)

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