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

Document ID : KB000005866
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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.

Environment:
CA Software Asset Manager 3.x to 4.x upgrade
Cause:

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

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