database mirroring ... help !!!

  • Hi

    Im trying to configure db mirroring on a win 2003 box with sql 2005 between two instances

    When I use the security wizard it selects the two instances etc and assigns separate ports for them.

    In the principle and mirroring box I see the equivalent of the following

    TCP://TSTSQL2005DBA:5022

    TCP://TSTSQL2005DBA:5023

    The principal is the default instance.

    When I try and start mirroring I get the "one or more of the server network addresses lacks a fully qualified domain name" message

    any ideas what I'm doing wrong ?

     

    thanks si

  • Your name needs to be MyDomain.MyServername.

    You cannot use just the server name.

    See BOL for the exact name.

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

  • thanks crispen

     

    when I use the configure database mirroring security wizard it doesnt present domain name and doesnt let me edit it in (maybe as theyre just instances on the same box ?)

     

    thanks Simon

  • I've had the  same issue before. You'll have to do it manually and not use the wizard.

    See BOL for the examples. It's rather easy.

     

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

  • You can also specify the machine IP while configuring.

  • you need to give the fully qualified domian name as follows,

    refer this link, http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1854090&SiteID=1

    [font="Verdana"]- Deepak[/font]

  •  

    thank you all for your kind help

    deepak do you have a version of that code that will work for two seperate instances on the same machine ?

    read BOL etc and maybe its as mirroring is a whole new concept with no real world experience at this current time but its just not sinking in

     

    thanks Si

     

  • just refer ,

    http://deepakinsql.blogspot.com/2007/07/how-to-configure-database-mirroring.html - for configuring dbmirroring

     http://deepakinsql.blogspot.com/2007/07/prerequisites-for-database-mirroring.html - prerequisites for mirroring

    revert if you have nay concerns

    yes you can make use of that code and give a try for 2 instances in a machine.coz i have installed 3 instances in my XP and configured mirroring.....

    just type ipconfig/all and provide the FQDN it shud workfine.......

    thanks

     

    [font="Verdana"]- Deepak[/font]

Viewing 8 posts - 1 through 7 (of 7 total)

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