| Author |
Topic |
|
stilltrying
Starting Member
2 Posts |
 Posted - 2008-10-29 : 16:21:17
|
| Hi,I am trying to set up mirroring on a machine with two seperate instances of Developer Sql Server 2005. One is the default instance and the second is named test1. I keep getting a message that I have to use a full FQDN. My machine is not part of a domain or workgroup. The database on both sides of the mirror is in full recovery mode. I am running on Vista.thanksstilltrying |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-29 : 16:35:39
|
| Do you have Service pack 1 or more installed in your machine for SQL server? |
 |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2008-10-29 : 16:40:00
|
| Are you uaing this TCP://<computer_name>.<domain_segment>[.<domain_segment>]:<port> |
|
|
|
stilltrying
Starting Member
2 Posts |
Posted - 2008-10-29 : 17:12:49
|
| Hi,Yes I have service pack 1 installed. If my machine name is devmachine with no domain segment what would the FQDN be?thanks |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-29 : 17:23:20
|
| Its Fully qualified domain name:Use Saurabh's approach |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-29 : 17:29:43
|
| Check in My computer-Properties. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-10-29 : 17:48:41
|
Try to edit Principal and Mirror after NOT directly starting mirroring in the wizard.Add a dot to the machine_name.Example: TCP://devmachine.:<port>I found this in a german forum and hope that helps.Webfred
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-29 : 21:29:18
|
| This has to be implemented in OS level first.You can specify Primary DNS suffix as local and make.local as domain_segment. |
|
|
|
parchk32
Starting Member
2 Posts |
Posted - 2008-11-11 : 15:59:55
|
| I have a similar situation. See below. So you are saying the I can create the primary domain suffix on server A as .local or .local.com? How is this then specified as a domain segment?I have a principal server (A) that is not part of a domain and a mirror server (B) that is part of a domain. A VPN provides communications between these two servers. Both servers have two instances of SQL Server installed on them. I am trying to configure the server network addresses for mirroring so that a database on server A on instance 1 (port 1450) is mirrored to server B on insrtance 1 (port 1439). The problem I am running into is on server A there is no primary domain suffix configured; therefore, I cannot specify a full qualified domain name (FQDN) in server network addresses. Also, since I am working on a server with multiple server instances, will I need to configure these servers in the hosts file with their unique ports? From all the reading I have done I beleive I need to use certificates; however, I still need to provide a FQDN and would like to know if anyone else has experienced this issue and what, if any, my options I have. Thanks in advance. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-11 : 16:23:16
|
| Yes. It is better to create certificates if domain differs. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-11 : 16:25:45
|
| like this:TCP://Hostname.local:port no |
|
|
|
|
fqdn on a test machine?