Making a UDL mirror aware
-
I'm looking for some help in making a UDL connector mirror aware. We've implemented a mirroring solution for a customer, moved all their replication to a Central Distribution Server, created mirror aware log reader agents, and updated all their .NET connection strings to contain the "Failover Partner" parameter. However, we've now discovered they use a UDL file to connect one of their major products to the database server.
In the "All" tab I've entered "Failover Partner=<servername\instance>" but this doesn't seem to be recognised as a parameter.
For UDL is it "Failover Partner", "Failover_partner" or "FailoverPartner" for the parameter name?
Cheers,
Andy
-
I am seeing it as "Failover Partner" in the All tab, but after adding a value and saving the UDL I see this as the connection string in the file (opened with Notepad):
Provider=SQLNCLI10.1;Integrated Security=SSPI;Persist Security Info=False;User ID="";Initial Catalog=database_name;Data Source=server_primary;Initial File Name="";Failover Partner=server_failover;Server SPN=""
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato -
Check connectionstrings.com all the info you need will be there
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
-
Thanks to both of you. I've tried it using details from ConnectionStrings and with "Failover Partner", neither seemed to work.
It looks like there's a SQL Server 2008 add on for UDL's that adds a mirroring awareness to the connector, we're currently trialing that...
-
Andeavour (4/10/2012)
Thanks to both of you. I've tried it using details from ConnectionStrings and with "Failover Partner", neither seemed to work.It looks like there's a SQL Server 2008 add on for UDL's that adds a mirroring awareness to the connector, we're currently trialing that...
Could you post a link and steps if it works for you so others finding this thread via a search engine can benefit?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply