StevensNet.com

...Because someone's gotta tell the story...

Blogs

To return to the main Blog List, click Full Blog Listing.

Tags

SCCM
SQL
System Center

SCCM 2012: Database Restore and .NET

Saturday, February 22, 2014 in System Center (Views: 2356)
Just a little something that was strange, but after restoring a SQL server and losing permissions, I was unable to work with the SCCM database. It seemed that .NET code was disabled on the database for some reason.

Not to worry, in case you wind up in the same predicament, I found this SQL snippet quite handy:

sp_configure 'clr enabled',1
GO
RECONFIGURE
GO
sp_configure 'clr enabled' -- Verify this works
GO


Of course, standard disclaimer applies, use TSQL wisely and have good backups.

 

Related Blogs You May Be Interested In:


To leave a comment, please log in and/or register.