Metricbeat (SQL Module) connection issue to MS SQL

Elastic Stack Beats
1

Hi Team,

We're trying to use metricbeat sql module to run custom query on MS SQL.

To connect to MS SQL using a domain account, what should we put in the "hosts" portion of sql.yml?

We've tried the following but can't seem to work:

**---------------------------------------------------------**
   - module: sql
         metricsets:
   - query
        period: 10s
        hosts: ["sqlserver://dbipaddress:50000"]
        username: domain\username
        password: password

     driver: "mssql"
     sql_query: "XXXX"
**----------------------------------------------------------**

We keep seeing error that says that it keeps trying to connect to localhost.

Is it the correct format to connect to MS SQL using a domain account for sql module?

Please advise. Thanks!

Regards.