Using a SRV DNS entry to connect to SQL Server in .NET

Question

We have a cluster SQL Server and we use a SRV DNS entry to locate the service (i.e sql.mycompany.com).

MyCompany.com_tcp_http Service Location (SRV) [0][0][1433]sql.Mycompany.com

Now, how I can use the .NET SQLConnection to use this dns name (instead of the server name/IP)? Any ideas?
Should I use System.Net.Dns to translate it first?

You might try this at serverfault.com – Sam Jul 02 '09 at 16:26 — Sam, Jul 02 '09 at 16:26
Does using sql.mycompany.com for Server not work? – Sam Jul 02 '09 at 16:31 — Sam, Jul 02 '09 at 16:31

score -1 · Answer 1 · answered Oct 13 '14 at 12:11

-1

A .NET SQLConnection will not look up SRV records, only A records.

So yes, you will need to query your SRV record using System.Net.Dns yourself, parse and use the result in your connection string.

answered Oct 13 '14 at 12:11

nos

223,662
58
417
506

Using a SRV DNS entry to connect to SQL Server in .NET

1 Answers1