I copied it in as db_inputs.conf and saw most of it worked. So I used the gui to find where it thought it was broke. I then used the settings from the TA MS SQL to create a new input via the gui of DB Connect3. Below is a comparison if it helps people modify their existing configurations
from Splunk_TA_microsoft-sqlserver\default\sqlserver_dbx2.conf
## mssql:alwayson
[mi_input://:alwayson:dm_hadr_auto_page_repair]
connection = SQLServer
index = main
interval = 300
max_rows = 10000
mode = batch
output_timestamp_format = YYYY-MM-dd HH:mm:ss
query = SELECT *,CONVERT(varchar(128),SERVERPROPERTY('ServerName')) AS ServerName, db_name() AS DatabaseName FROM sys.dm_hadr_auto_page_repair
source = dbx2
sourcetype = mssql:alwayson:dm_hadr_auto_page_repair
ui_query_mode = advanced
disabled = 0
And as saved in splunk_app_db_connect/local/db_inputs.conf
[alwayson:dm_hadr_auto_page_repair]
connection = SQLSERVER
host = hostname/IP
index = main
interval = 300
max_rows = 10000
mode = batch
query = SELECT *,CONVERT(varchar(128),SERVERPROPERTY('ServerName')) AS ServerName, db_name() AS DatabaseName FROM sys.dm_hadr_auto_page_repair
source = DBX
sourcetype = mssql:alwayson:dm_hadr_auto_page_repair
ui_query_mode = advanced
And finally, in splunk_app_db_connect/local/inputs.conf
## mssql:alwayson
[mssql:alwayson:dm_hadr_auto_page_repair]
mode = batch
output_timestamp_format = YYYY-MM-dd HH:mm:ss
ui_query_mode = advanced
... View more