I need to tighten the security of an existing SQL Server 2008 R2 by disabling certain Instance level configuration options. For example, CLR, Trustworthy, xp_dirtree, xp_regread etc.
How can I check whether disabling these will affect any of my applications/processes.
This is a production server.
Thanks for you help in advance.
asked Aug 06, 2014 at 04:53 PM in Default
Best way to deal with that is to have a test machine with your applications running on it and do the tests there before you do them in production. If that's impossible (and it shouldn't be), then do a single change at a time on production, wait a full 24 hours for that change to impact your applications, then make another change. That way at least you'll know which change caused the issue.
answered Aug 14, 2014 at 10:29 AM
Grant Fritchey ♦♦