Informatica error: Invalid connection license key for CMN_1022 [database [Microsoft SQL Server] solution

1. No problems caused by Lincense
Problem: The connection license key for CMN_1022 [database [Microsoft SQL Server] is invalid
Solution: Check your license on the console (click license to view permissions). Switch to ODBC connections.
 
2. Odbc connection to SQLServer.
In the system ODBC, establish a connection, for example: odBC_ORa_HR, test to see if it can connect to the remote Oracle Server. When you set up ODBC in the Workflow Manager, that ConnectString puts the name odBC_ora_hr. Odbc_ora_hr should be ok if it’s accessible from your system’S ODBC

Read More: