Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
parchk32
Starting Member
2 Posts |
 Posted - 2008-11-11 : 15:49:14
|
| 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. |
|
|
SimpleSQL
Yak Posting Veteran
85 Posts |
Posted - 2008-11-12 : 00:06:16
|
| First you would need to use certificates. Second, the FQDN you give will be domain name of the server and the port number. For multiple instances on the machine, the domain name will be same but the port number where the endpoints are listening will be different.Please review following links which has exact answer plus example of what you are looking forhttp://msdn.microsoft.com/en-us/library/ms191140.aspxhttp://msdn.microsoft.com/en-us/library/ms189921.aspx |
 |
|
|
|
|
|
Database Mirroring Across Non-trusted Domains