Need to change the compatibility level of the CM database so that it would import drivers successfully.

Altered the database using following: ALTER DATABASE <CM_DB> SET COMPATIBILITY_LEVEL = 150

https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level?view=sql-server-ver16

or

To change the compatibility level of a database in SQL Server, you can:

1. Open the database properties
2. Select the Options page
3. Set the Compatibility Level
4. Select a different option from the list
5. Click OK