ConfigMgr 2012 : Unable to Import Drivers After Moving SQL Files

Posted in CM2012ConfigMgrSCCMSQL

Recently had an issue at a client site where we suddenly couldn’t import drivers, manually or via a PowerShell script.

Problem

When importing manually, we were seeing the following error:

“An error occurred while importing the selected driver”

When importing via the script, we were seeing:

“Unexpected error, skipping INF : CSspConfigurationItem: SQL_ERROR 3242722562″

After some creative searching, I can across this KB article:

After moving the System Center 2012 Configuration Manager SQL Site Database to another drive, creating a new Software Update package or a new application fails.

http://support.microsoft.com/kb/2709082

Well as it turns out, I had just moved around the DB and Log files for this client to new drives.

Resolution

I used the following commands to alter the DB, verify the Isolation level, and then finally change the DB owner back to SA.

CM_XXX = ConfigMgr DB Name

Step1:

ALTER DATABASE CM_XXX SET TRUSTWORTHY ON

Step 2:

DBCC USEROPTIONS

Verify that Isolation level is “READ COMMITTED SNAPSHOT”

Step 3:

Use [CM_XXX]

Go

Exec sp_changedbowner ‘SA’

Go

After completing those steps, I was able to import drivers again.

email

Written by , Posted .