Prepare the Back-end Database Server (COLLABBE01)

  • Article

In these procedures you will prepare and configure the database server, SQLBE01, by performing the following tasks.

Tasks

  1. Prepare the Base Server

  2. Install SQL Server 2005 with SP2 on COLLABBE01

  3. Configure Surface Area Settings in SQL Server 2005

  4. Move COLLABBE01 into the Windows SharePoint Services Servers\Backend OU

Prepare the Base Server

Procedure W08-DWSH.5: To prepare the base Server:

  1. Install Windows Server 2008 (x64) on COLLABBE01.

  2. Enable Remote Desktop.

  3. Join the Fabrikam domain.

  4. Disable Windows Firewall.

Install SQL Server 2005 with SP2 on COLLABBE01

Procedure W08-DWSH.6: To install SQL Server 2005 with SP2 on COLLABBE01

  1. Log on to COLLABBE01 as Fabrikam\Administrator.

  2. Run Setup from the Install SQL Server 2005, Standard Edition installation media on COLLABBE01.

  3. Install SQL Server Database Services and Workstation components, Books Online and development tools.

  4. Follow the instructions to proceed with the installation. Ensure the following settings:

    • Instance Name: Default Instance

    • Service Account: Use the built-in System account, Local System

    • Start services at the end of setup: SQL Server

    • Authentication Mode: Windows Authentication

  5. After SQL Server 2005 setup completes successfully, install SQL Server 2005 Service Pack 2.

  6. Restart the server to complete the installation.

Note

You will see a Warning message for the IIS Feature Requirement. This is an expected warning, because IIS is not installed. It is safe to continue.

For performance reasons, you should store the SQL Server program files on a different drive than the data. For example, specify drive C for the program files, and specify drive D for the data files. You should use high performance drives; the reference architecture recommends using a redundant array of independent disks (RAID).

For better security in your server farm, the solution recommends that you use Windows authentication, instead of SQL Server authentication, for connections between your front-end Web servers and the database servers. Windows authentication uses a domain user account to control access to SQL Server, instead of storing credentials in the registry and passing them across the network as in SQL Server authentication.

Configure Surface Area Settings in SQL Server 2005

Procedure W08-DWSH.7: To configure surface area settings in SQL Server 2005

  1. On COLLABBE01, open the SQL Server Surface Area Configuration tool.

  2. Perform surface area configuration for Database Engine remote connections. Enable Database Engine local and remote connections using TCP/IP and named pipes.

Note

For detailed instructions, see Surface Area Configuration for Services and Connections.

Move COLLABBE01 into the Windows SharePoint Services Servers\Backend OU

Procedure W08-DWSH.8: To move COLLABBE01 into the Windows SharePoint Services Servers\Backend OU

  1. On AD01, open Active Directory Users and Computers and expand your domain (fabrikam.com).

  2. Move the database server (COLLABBE01) to the Windows SharePoint Services Servers\Backend organizational unit (OU).