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

Article Id: 5866

Status: Published

Updated On: 14-02-2018 08:10

Legacy Id: TEC1222775

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