3 Replies Latest reply on Aug 31, 2017 1:22 PM by Anderson Alves Amaro

    Tip: Configuring External DB connection for MS SCOM integration

    Steffen Gruebler
      Share This:


      Cannot connect to MS SQL Server 2012 (AlwaysOn) with Windows Authentication

      Using FreeTDS tsql CLI, we receive error: "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication."



      For Windows Authentication, configure "Other database" as documented in Moviri Integrator for TrueSight Capacity Optimization - Microsoft SCOM - BMC TrueSight Capacity Optimization 10.5 - BMC …  and select net.sourceforge.jtds.jdbc.Driver as the JDBC driver.

      We had to append useNTLMv2=true in the JDBC URL, so it looks like follows:


      (substitute *** with respective host, database and Domain names)


      Hope this tip saves some time to those running into a similar situation.