Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
218 Chapter 9 SERVER RIGHTS Server Instance. The system administrators should not be installing these service packs and hotfixes against the Microsoft SQL Server instance as the systems administrator should not have rights within the Microsoft SQL Server instance in order to complete the service pack or hotfix instance. When the Microsoft SQL Server service pack or hotfix needs to be installed, the DBA will need to be granted administrative rights to the Microsoft SQL Server's operating system to complete the service pack and hotfix installation. This level of permissions is needed so that the service pack or hotfix can update the Microsoft SQL Server binaries within the "C:\Program Files\Microsoft SQL Server\" folder (or wherever the binaries are installed to). OS Rights Needed to Access SSIS Remotely By default, only members of the local administrators group have the ability to connect to the SQL Server Integration Services (SSIS). This can prevent developers from accessing the SSIS in the