Forum Discussion

Clark_Kent's avatar
Clark_Kent
3 years ago

The TCP/IP connection to the host 192.168.3.23, port 1433 has failed (on default port)

Hi there! We have following issue: Our MSSQL server is running on dynamic ports, but in LM there is only default port specified in Properties section mssql.commvault.mssql_url  =  jdbc:sqlser...
  • Clark_Kent's avatar
    Clark_Kent
    3 years ago

    Hi all,

    in order to monitor MS SQL server database items we had to do a couple of changes.

    Firstly, there had to be created a new user in MS SQL management studio and there were necessary to allow SQL authentification. Then, appropriate rights were assigned to the user (on the database table level). Lastly, properties were assigned to property source - jdbc.mssql.pass, jdbc.mssql.user, mssql.commvault.mssql_url

    All that stuff was quite difficult and it was designed for engineers with advandced MS SQL and Logic Monitoring knowledge?

Clark_Kent's avatar
Clark_Kent
3 years ago

After some time of troubleshooting we have found out that LM shoud be able to find even dynamic ports (see https://www.logicmonitor.com/support/monitoring/applications-databases/microsoft-sql-server). However, we do not know how to implement following string into LM - auto.<instance name>.mssql_url.

If I add "auto.<instance name>.mssql_url." to Custom Properties, there is error message saying that it is not allowed. Where should be then this string added?

If there is no string specified (mssql.commvault.mssql_url), LM will trigger this alert - SQL Server Troubleshooter-MY_INSTANCE_NAME Missing JDBC connection string. Check login informations or manually add a connections string to mssql.commvault.mssql_url exitCode

What does it mean?