We get below error trying to import Drivers on to SCCM with SQL 2022
Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryException
Not found , property = CI_ID
This issue occurs due to the Database compatibility with the SCCM Current branch.
In order to fix this issue, we need to alter the CM DB compatibility from 160 to 150.
Here is the compatibility table for reference.
| Product | Database Engine version | Default compatibility level designation | Supported compatibility level values |
|---|---|---|---|
| Azure SQL Database | 16 | 160 | 160, 150, 140, 130, 120, 110, 100 |
| Azure SQL Managed Instance | 16 | 150 | 160, 150, 140, 130, 120, 110, 100 |
| SQL Server 2022 (16.x) | 16 | 160 | 160, 150, 140, 130, 120, 110, 100 |
| SQL Server 2019 (15.x) | 15 | 150 | 150, 140, 130, 120, 110, 100 |
| SQL Server 2017 (14.x) | 14 | 140 | 140, 130, 120, 110, 100 |
| SQL Server 2016 (13.x) | 13 | 130 | 130, 120, 110, 100 |
| SQL Server 2014 (12.x) | 12 | 120 | 120, 110, 100 |
| SQL Server 2012 (11.x) | 11 | 110 | 110, 100, 90 |
| SQL Server 2008 R2 (10.50.x) | 10.5 | 100 | 100, 90, 80 |
| SQL Server 2008 (10.0.x) | 10 | 100 | 100, 90, 80 |
| SQL Server 2005 (9.x) | 9 | 90 | 90, 80 |
| SQL Server 2000 (8.x) | 8 | 80 | 80 |
Execute the below query on the SQL Server 2022 with elevated prevalages.
Check Current Compatibility Level:
SELECT compatibility_level FROM sys.databases WHERE name = 'CM_XXX';
Set the Compatibility Level to 150:
ALTER DATABASE YourDatabaseName SET COMPATIBILITY_LEVEL = 150;
In case of any issues after the altering the Compatibility,
You can revert the compatibility level back to 160
ALTER DATABASE YourDatabaseName SET COMPATIBILITY_LEVEL = 160;
Sources:
- https://www.reddit.com/r/SCCM/comments/112cjes/strange_error_trying_to_import_drivers_on_2211/
- https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level?view=sql-server-ver16
- https://www.reddit.com/r/SCCM/comments/zz8uoj/issues_importing_drivers_into_mecm/