July 13, 2007 at 10:12 am
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
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
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
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
You can also specify the machine IP while configuring.
Regards..Vidhya Sagar
SQL-Articles
July 15, 2007 at 4:22 am
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
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
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