SQL Server connections using mssql.<instance name>.mssql_url
For some SQL Servers due to how they are setup, we are setting the property mssql.<instance name>.mssql_url
I've noticed, when I do this, the Microsoft_SQLServer_Connections module then does not retrieve the SQL Server version and edition (e.g. Enterprise, Standard, Express), which is affecting some custom dashboards.
What's the best guidance to resolve this, would I need to create my own datasource?
Damian O'Brien
Posted 2 years ago·Last reply 2 years ago
3 comments
Damian O'Brien
OP2 years agoThank you for the helpful advice. I've set these properties, but I think I’ll need to submit a support ticket to take a closer look as advised. I believe the issue might be affected by the fact that, for compliance reasons, we have the SQL Server Browser service disabled. So, may require some specific attention.
Michael Raymond
·2 years agoAre you setting both 'mssql.sql_server_instances' and 'mssql.<instance name>.mssql_url'?
https://www.logicmonitor.com/support/monitoring/applications-databases/microsoft-sql-server#assign-properties-to-sql-server-resources
Michael Raymond
·2 years agoIdeally, this would all be automatic and set via the Microsoft_SQLServer_Connections PropertySource. If manually adding, you should be setting both properties.
If you are setting both, the modules are all up-to-date, and this is still not working as expected, I'd suggest submitting a support ticket so we can take a closer look.