Detaching/Attaching SCCM 2012 Database

As part of a recent task to relocate an SCCM database to faster spindles, I went ahead used the detach/attach method to accomplish this. After the database relocation there were no issues until we tried to create a new application. I received the following error:

 

After checking the logs, I found the following event being reported continuously:

After some digging around, I found a Microsoft KB that addresses this exact problem: http://support.microsoft.com/kb/2709082

Part of the issue is that when you detach and attach a database ( a perfectly supported SQL action) the trustworthy database flag is turned to off. As a result, SCCM DLL’s are not successfully loaded. After following the steps outlined in the KB article, I was able to create applications without any issues.

Recommendation: Use backup/restore method to relocate the database than using attach/detach.