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

book

Article ID: 5866

calendar_today

Updated On:

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