CA Software Asset Manager - SAM upgrade fails on the check installation with: Database connection error. Microsoft ODBC driver 11 for SQL Server: Access the following URL to download the ODBC driver 11 for SQL Server x86

Document ID : KB000070122
Last Modified Date : 13/03/2018
Show Technical Document Details
Issue:

During a CA Software Asset Manager upgrade or a new install, the check installation errors with the following message: 

Database connection error. Microsoft ODBC driver 11 for SQL Server: Access the following URL to download the ODBC driver 11 for SQL Server x86 ...

 

Environment:
CA Software Asset Manager 4.x
Resolution:
If your operating system is 64-bit, download the 64-bit ODBC driver 11 from this URL: 
https://www.microsoft.com/en-us/download/details.aspx?id=36434 

The 64-bit driver displays as:  1033\amd64\msodbcsql.msi 
Note: The 32-bit ODBC driver 11 will FAIL to install onto a 64-bit operating system.