beautypg.com

Installing the database instances – Dell R810 User Manual

Page 18

background image

Servers: Database consolidation on Dell PowerEdge R810 servers


18

Figure 7. Choosing features for installation.

On the first installation, choose to install the default

instance. On subsequent installations on the
same server, choose named instance and provide
a name for the instance.

Configure the credentials of the SQL Server service

account and SQL Server Agent accounts.

Specify SQL Server administrators and also specify

the authentication mode desired for your
configuration. Microsoft recommends Windows
Authentication mode, but legacy applications may
require SQL Server authentication.

Complete the installation.

Installing the database instances

While there can be only one default instance, SQL Server 2008 R2,
as with previous versions of SQL Server, allows you to have
multiple named instances. These instances function largely
independently of one another; each has its own security contexts,
collation settings, etc. (For more information, see

http://msdn.microsoft.com/en-us/library/
ms143531(SQL.105).aspx

.)

To install one or more named instances, as we did for our testing,
follow the same procedures as installing a default instance, with
the exception of a few configuration changes during the process.
First, on the Feature Selection screen, if you are installing a named