Chapter 2. Configuring and Managing SQL Server Instances
Exam objectives in this chapter:
Configure SQL Server instances.
Manage SQL Server instances.
SQL Server instances are separate deployments of Database Engine, Analysis Services, and Reporting Services hosted on the same computer. Each instance may have one Database Engine, one Analysis Services, and one Reporting Services service installed. Each instance has its own program files, directory, and security configuration. A user who can create and drop databases in one instance might not have rights to change databases hosted on another instance, even though both instances are installed on the same host. Multiple instances on the same host enable you to deploy SQL Server multiple times without ...