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 ...

Get Training Kit Exam 70-462: Administering Microsoft® SQL Sever® 2012 Databases now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.