Microsoft SQL Server 2012: A dozen features you might have missed

7/11

SQL Server 2012 security: New default settings, greater flexibility

Source:  Fotolia

SQL Server 2012 security promises to be more flexible than in previous iterations of SQL Server. BUILTIN\administrators and Local System (NT AUTHORITY\SYSTEM) are no longer automatically provisioned in the sysadmin fixed server role, allowing you greater flexibility in granting permissions. What this means for IT pros is that default security settings not only should be tweaked, but must be, though it also means greater control for system administrators.

View All Photo Stories

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close