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


Article ID: 5866


Updated On:


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


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:

#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.


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


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


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: