Post reply

database mirroring ... help !!!

  • July 13, 2007 at 10:12 am

    #372777

    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

  • July 13, 2007 at 10:20 am

    #719364

    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!

  • July 13, 2007 at 10:24 am

    #719366

    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

  • July 13, 2007 at 12:53 pm

    #719404

    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!

  • July 13, 2007 at 9:07 pm

    #719454

    You can also specify the machine IP while configuring.

    Regards..Vidhya Sagar
    SQL-Articles

  • July 15, 2007 at 4:22 am

    #719510

    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]

  • July 16, 2007 at 7:37 am

    #719680

     

    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

     

  • July 16, 2007 at 7:04 pm

    #719843

    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