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.
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: https://msdn.microsoft.com/en-us/library/jj730314(v=sql.1).aspx