How to install SQL Server client components needed for the CMM products.

For CDB\Visualizer to function correctly, when connecting to a SQL Server database, the SQL Server ODBC Driver and the SQL Server Bulk utility must be installed on the same Windows machine where Visualizer and\or CDB are installed.  The SQL Server client components can be installed from the full SQL Server installer package however that package tends to be 2-3 Gigabytes in size which can be too large to deal with. 

A SQL Server client only installer is not available; instead Microsoft offers individual feature downloads for SQL Server.  One of the feature downloads is for the Microsoft ODBC Driver for SQL Server.  This is the driver that should be used to set up the ODBC data source for a SQL Server database.  Another feature download is for the SQL Server Command Line Utilities.  This package includes the SQL Server bulk utility program (BCP.exe) which is required for Automator populate.  The third package mentioned below is the SQL Server Management Studio.  This is not required but this includes a graphical user interface that can be used to run SQL, browse the db objects (tables, indexes, etc.) and manage the user databases.  

The SQL Server Management Studio (SSMS) package includes the ODBC driver but not the Command Line Utilities, so if this package is installed only the command line utilities will need to be installed in addition to SSMS.    

Download links for the current versions (as of 12/31/2021) are provided below.  
 

Microsoft ODBC Driver for SQL Server 

https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15

If the Windows OS is 64 bit select the _x64 download.
If the Windows OS is 32 bit select the _x86 download. 

Note: The 64 bit download will install both the 32 bit and 64 bit ODBC drivers.  CDB and Visualizer require the 32 bit ODBC driver.


Microsoft Command Line Utilities for SQL Server

https://docs.microsoft.com/en-us/sql/tools/bcp-utility?view=sql-server-ver15

If the Windows OS is 64 bit select the _x64 download.
If the Windows OS is 32 bit select the _x86 download.

Note:  CDB and Visualizer can use either the 32 bit or the 64 bit bulk utility.

The Command Line Utilities install should update the PATH statement to add the directory where the bulk utility (bcp.exe) was installed.  (i.e.  C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn).  If it does not the following KA will provide the steps required to update the PATH statement.
   
https://bmcsites.force.com/casemgmt/sc_KnowledgeArticle?sfdcid=000097525


SQL Server Management Studio (SSMS)

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

Note:  This package will install SQL Server Management Studio, the 32 bit and 64 bit ODBC drivers and update the PATH statement.

1. BMC MainView Capacity Management Family for Mainframes
2. BMC Performance Assurance for Servers