August 10, 2009 at 12:49 pm
Dear All,
can i do mirroing without have domain.
i have 3 database server in the same workgroup can i do the mirroring.
thanks alot.
August 11, 2009 at 3:43 am
Yes you can use mirroring without a domain. But you might have to set it up using TSQL.
I remember that once you installed SP2, the wizard in SSMS won't accept a servername without domain suffix. Maybe this was fixed in SP3, but I can't check it right now.
[font="Verdana"]Markus Bohse[/font]
August 11, 2009 at 5:17 am
i installed SQL 2005 SP3 but i can't do mirroring and i get this error.
TITLE: Database Properties
------------------------------
One or more of the server network addresses lacks a fully qualified domain name (FQDN). Specify the FQDN for each server, and click Start Mirroring again.
The syntax for a fully-qualified TCP address is:
TCP://.[.]:
------------------------------
BUTTONS:
OK
------------------------------
August 11, 2009 at 6:58 am
That's exactly what I remembered.
But if you use TSQL scripts it should still work. This article should help you with it.
http://www.databasejournal.com/features/mssql/article.php/3832106/Database-Mirroring-Using-T-SQL.htm
[font="Verdana"]Markus Bohse[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply