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


  1. Install Prerequisites for COLLABBE01
  2. Install SQL Server 2005 with SP2 on COLLABBE01
  3. Move COLLABBE01 into the Windows SharePoint Services Servers\Backend OU

Install Prerequisites for COLLABBE01

Procedure W03-DWSH.6: To install prerequisites for COLLABBE01

  1. Install Windows Server 2003 R2 Standard Edition with SP2 on COLLABBE01. Note that for this server role, either the 32-bit version or 64-bit version of Windows Server 2003 is supported.

  2. Install the Microsoft .NET Framework 2.0 with SP1.

  3. Install the Windows Server 2003 Support Tools.

  4. Join the Fabrikam domain.

Install SQL Server 2005 with SP2 on COLLABBE01

Procedure W03-DWSH.7: 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.

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.

Move COLLABBE01 into the Windows SharePoint Services Servers\Backend OU

Procedure W03-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 (

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