TAILIEUCHUNG - Microsoft SQL Server 2008 R2 Unleashed- P32

Microsoft SQL Server 2008 R2 Unleashed- P32:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 264 CHAPTER 10 Client Installation and Configuration was introduced in SQL Server 2005 and was a key part of client configuration. The functionality made available in this tool has now been replaced with Policy-Based Management features and changes in the SQL Server Configuration Manager SSCM tool. For example the option to allow Remote Connections that was available in SAC is no longer there. You should look to the SSCM tool and enable or disable the protocols for which you want to allow connections. The details of this change are discussed later in this chapter and a full discussion of Policy-Based Management is provided in Chapter 22 Administering Policy Based Management. One last change in SQL Server 2008 Client Installation and Configuration that may rear its head relates to the BUILTIN Administrator windows group. By default this group is no longer included in the SQL Server sysadmin fixed server role on new SQL Server 2008 installations. So by default network administrators and administrators of the machine where SQL Server is running are not able to log in to SQL Server and administer it. In past versions of SQL Server the BUILTIN Administrator windows group was added to the sysadmin role. To grant administrators permission to SQL Server you can manually add the BUILTIN Administrator group to the sysadmin SQL Server role or you can add each individual network administrator that needs to access SQL Server to that role. The change to the BUILTIN Administrator windows group is in line with Microsoft s strategy to secure by design secure by default and secure in deployment. This strategy relates to many aspects of SQL Server including installation security and client installation and configuration. The strategy is a good one but can cause you as the administrator some extra grief if you are not aware of the impact that these changes can have on you and your users. Client Server Networking Considerations Before we delve into the features on the client side in .

TỪ KHÓA LIÊN QUAN
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.