Submit My Question - Recent Questions - Recent Answer

Msdn Tech >> SQL Server >> Database Mirroring

Mirroring On Workgroup servers

I have 2 web servers in a workgroup both running SQl 2005 SP2. both servers have a user called sqluser which is the main login for sql on both boxes. When I use the mirroring wizard it creates the end points ok but does not like the fqdn of each server, these are called webserver1 and webserver2. Is the problem because of the name and lack of domain ? Can I add a user for server1 on server2 or do I need to use certificates to get Mirroring working in this type of environment ?

[482 byte] By [Sam] at [2008-1-1]

«« array of controls..
»» Windows Form OnLoad code doesn't execute

# 1

http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx and http://www.microsoft.com/sql/prodinfo/features/features-at-a-glance.mspx features at a glance.

fYI http://www.sqlserver-qa.net/SSQA-Effective%20Usage%20of%20SQL%20Server%202005%20Database%20Mirroring_show.ppt too.

SatyaSKJ at 2007-9-12 >

top of Msdn Tech,SQL Server,Database Mirroring...

# 2

I have the same problem.

My mirror database is not in a domain, therefore it doesn't have a FQDN.

Did you find a solution?

Thanks,

Joe.

JoeHelfman at 2007-9-12 >

# 3

Hi Sam/Joe,

When specifying the PARTNERS you have to use the Fully qualified computer names.

The fully qualified computer name of each server can be found running the following from the command prompt:

IPCONFIG /ALL

Concatenate the "Host Name" and "Primary DNS Suffix". If you see something like:

Host Name . . . . . . . . . . . . : A
Primary Dns Suffix . . . . . . . : corp.mycompany.com

Then the computer name is just A.corp.mycompany.com. Prefix 'TCP://' and append ':<port number>' and you then have the partner name.

regards

Jag

JagSandhu at 2007-9-12 >

# 4

when I issue an ipconfig /all

Code Snippet

Windows IP Configuration

Host Name . . . . . . . . . . . . : A
Primary Dns Suffix . . . . . . . :
Node Type . . . . . . . . . . . . : Unknown
IP Routing Enabled. . . . . . . . : No
WINS Proxy Enabled. . . . . . . . : No

The primary Dns Suffix is empty which is preventing me from using a FQDN.

I'm using certificate based authentication, and have had mirroring setup and working for a couple of months without a FQDN.

It's only when I removed and tried to re add mirroring that this cropped up.

Any suggestions?

KG at 2007-9-12 >

# 5

Hi K G,

Are you setting up mirroring using GUI or commands?

Does your server have a statis IP address. Try using the IP address when setting the partner.

regards

Jag

JagSandhu at 2007-9-12 >

# 6

Hi Jag

I'm using the GUI.

When I use the IP address, and press Start Mirroring it reverts back to the machine name, and asks me for a FQDN.

KG at 2007-9-12 >

# 7

Hi K G,

Could you try using the commands.

ALTER DATABASE db_name SET PARTNER = 'TCP://IPADDRESSORT'

Run it on the mirror first and then on the principal.

regards

jag

JagSandhu at 2007-9-12 >

# 8

Thanks Jag,

I've managed to resolve it using the GUI. I ran the "configure security wizard", and at the end opted "Do Not Start Mirroring".

I then edited the server names to be the ip addresses.

This allowed me to get mirroring work.

Thanks for your pointer on the IP address.

KG at 2007-9-12 >

# 9

Hi KG could you please mark the post as helpful, if you are satisfied with the help.

good luck

Jag

JagSandhu at 2007-9-12 >

SQL Server

Database Mirroring

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

it's Archive about 'Mirroring On Workgroup servers...'

Mirroring On Workgroup servers

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Site Classified