Databse Mirroring

avatar

Hi there,

we are trying to configure RDM for Database Mirroring.

We enter the Mirror-Server-Hostname in the field "Failover Partner" but then RDM throws an error saying, that "Initial Catalog" also needs to be specified.
But there is no field for "Initial Catalog" and if we enter a complete SQL-Connection-String into the "Failover Partner" field, RDM wont save the information.

How does DB Mirroring work?

All Comments (7)

avatar

David Hervieux

avatar

I know what Initial Catalog means, but I dont know where to enter it in RDM Datasource Configuration.
As you can see here, I cant enter an Initial Catalog:
http://i.imgur.com/DWUloow.png

avatar

Hi,
the initial catalog is the database name in the Connection tab page. It's need to be the same database on the two different partners.

David Hervieux

avatar

Hi,

OK I managed to configure the DB Mirroring, but I think there is a bug:
The Instances and Database have the exact same name on both servers. Then I enter the Failover-Partners FQDN and when I click "Test Server" I get the message, that initial catalog needs to be specified when using Failover-Partner.
However "Test Database" is succesful und when i trigger a manual Failover, RDM still seems to work.
So theres just a bug on "Test Server" when using a Failover Partner.

avatar

Hi,

I have the same problem. I must enter string "ServerName;Initial Catalog=RDMStore;" in the field Failover partner and than db and server tests works.

The field failover partner is empty when I open Advanced Settings again. This is a bug.
edited by MajklIP on 1/8/2014
edited by MajklIP on 1/8/2014

avatar

Hi,
What's the name of your main DB? We build a connection string and it seems that you add the Initial Catalog in the string with injection

David Hervieux

avatar

This is now in the current beta

David Hervieux