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

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?