This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
BMC Atrium Core - CMDB
BMC Atrium Core
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.
-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.