All of our SQLServer DBs have a primary and a fail-over. One the rare ocasion when we fail-over Splunk stops indexing data from these DBs because it's only configured to connect to the fail-over. Is there anyway to have Splunk connect to the fail-over automatically?
Are you using a virtual server name? https://technet.microsoft.com/en-us/library/ms143182(v=sql.90).aspx