What’s New in Security and User Administration
Several new security enhancements have been added to SQL Server 2008 to help make it more secure than any prior version. These enhancements build upon the myriad of security-related changes made in SQL Server 2005 and follow the policy of “least privileges” that Microsoft has been pushing. Several of these new changes follow:
• BUILTIN\Administrators—This local Windows group is no longer included in the SQL Server sysadmin fixed server role. In prior versions, the BUILTIN\Administrators account was part of this role, which meant that network administrators could access the SQL Server instance even though they were not given explicit permission. You still have the option of manually adding this ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
