Fix for DMF scheduled policy checking in SQL Server 2008 June CTP

If you have been trying out the new Declarative Management Framework policies you may have run across an issue trying to use an Execution mode of Check on Schedule with the error "Could not load file or assembly Microsoft.SqlServer.DmfSqlClrWrapper" being reported in the policy job history.

The Declarative Management DLL, which runs inside the SQLCLR, did not get signed as part of the build process. Running the command below will disable strong name verification for this assembly. Client-side checking of policies: "Test Policy" and "Run Now" will function as expected without the fix. Policy automation (enforce, check on change, and check on schedule), though, will require applying the fix.

The fix is very simple. Launch a command line and run the following command:

"C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\sn.exe" -Vr Microsoft.SqlServer.DmfSqlClrWrapper,89845DCD8080CC91

Thanks to Dan Jones for the fix details in his forum post

Published Thursday, June 7, 2007 7:24 PM by sqldbatips


No Comments