Error connecting to database: (using class com.microsoft.sqlserver.jdbc.SQLServerDriver)

Version 2
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    BMC Atrium Core - CMDB


    COMPONENT:

    BMC Atrium Core


    APPLIES TO:

    AtriumIntegrator 9.x up to 9.1.03 (release version as of July 2017), however the same info should apply to future versions as well.



    DETAILS:

    -Go to Start->All Programs-> Microsoft SQL Server 2012-> Configuration Tool -> Click SQL Server Configuration Manager ->Expand SQL Server Network Configuration-> Protocol ->Enable TCP/IP Right box

    -Double Click on TCP/IP and go to IP Adresses Tap.

    -Check the port. It should be 1433 (default port).

    -If you have specified other port, then that should be used while making the DB connection in spoon.


    If this does not solve the issue then please replace the MSSQL DB 2012 - mssql jar file (sqljdbc41.jar or higher) in C:\Program Files\BMC Software\ARSystem\diserver\data-integration\libext\JDBC
    These jar files are available as a download from the vendor (Microsoft). Restart of Pentaho plugin is required.




     


    Article Number:

    000128169


    Article Type:

    Product/Service Description



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles