CA Software Asset Manager (SAM) upgrade from release 3.6.6 to 4.1 fails.

Products

• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

We are upgrading SAM from release 3.6.6 to 4.1.  On the install_db step, receive the error: 

ERROR:database connection failure (Host: SAMServer; Database: SAM); native message: asp_db_mssql_sqlsrv->connect(): failed. error: code: 0, message: 

#1: SQLSTATE: IMSSP; code: -49; message: This extension requires the Microsoft ODBC Driver 11 for SQL Server. Access the following URL to download the ODBC Driver 11 for SQL Server for x86: http://go.microsoft.com/fwlink/?LinkId=163712

#2: SQLSTATE: IM002; code: 0; message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Layer message is: connect(SAMUser, , $Password) failed.

Cause

The bit level of the Microsoft ODBC Driver 11 for SQL Server is incorrect. 

Environment

CA Software Asset Manager 3.x to 4.x upgrade

Resolution

Download and install the appropriate bit level of the 'Microsoft ODBC driver 11' that corresponds to your SQL Server version and architecture (x86 or x64)

Drivers can be found at: https://msdn.microsoft.com/en-us/library/jj730314(v=sql.1).aspx