Set up SQL Server for a Project Server 2010 test environment

 

Applies to: Project Server 2010

Topic Last Modified: 2011-08-05

(This article is part 5 of the Microsoft Project Server 2010 test environment deployment series. The procedures in this article assume that you have read the series in sequence starting with Hyper-V quick start for creating a Project Server 2010 test environment.)

This article describes how to install and configure Microsoft SQL Server 2008 for use with Project Server 2010. Project Server 2010 requires one of the following versions of SQL Server:

  • Microsoft SQL Server 2008 with Service Pack 1 (SP1) and Cumulative Update 2

  • Microsoft SQL Server 2005 SP3 with Cumulative update package 3 for SQL Server 2005 Service Pack 3

This article describes installing and configuring SQL Server 2008 SP1 with Cumulative update package 2 for SQL Server 2008 Service Pack 1.

Video demonstration

This video shows the steps involved in setting up SQL Server 2008 for use with Project Server 2010.

Screenshot of video

Watch the video (https://go.microsoft.com/fwlink/p/?LinkId=196722). To download the video file, right-click the link, and then click Save Target As.

Configure a local administrator

We recommend that you install SQL Server 2008 while logged on with the SQL Server administrator domain account (Litware\SQLAdmin). Prior to doing this, you must add this account to the local Administrators group on the Litware-SQL virtual machine.

Log on to the Litware-SQL virtual machine with the domain administrator account (Litware\administrator) and perform the following procedure to add the Litware\SQLAdmin account to the local Administrators group.

To add a local administrator

  1. Log on to the virtual machine where you want to install SQL Server as a domain administrator.

  2. Click Start, click Administrative tools, and then click Computer Management.

  3. Expand Local Users and Groups, and then click Groups.

  4. In the right pane, right-click Administrators, and then click Properties.

  5. Click Add.

  6. Type the name of the SQL Server administrator account (Litware\SQLAdmin), and then click OK.

  7. Click OK.

  8. Log off the virtual machine.

To perform the remaining procedures in this article, log on to the Litware-SQL virtual machine with the Litware\SQLAdmin account.

Install SQL Server 2008

The first step is to install SQL Server 2008. SQL Server 2008 requires the .NET Framework version 3.5. If the .NET Framework 3.5 is currently not installed, you must install it or enable it as a feature in Windows Server 2008 before you continue.

Perform the following procedure to install SQL Server 2008 on Litware-SQL.

To install SQL Server 2008

  1. Attach the SQL Server 2008 DVD to the virtual machine DVD drive.

  2. Log on to the virtual machine where you want to install SQL Server as the SQL Server administrator.

  3. On the SQL Server DVD, double-click setup.exe.

  4. If a compatibility warning is displayed, click Run program.

  5. In the SQL Server Installation Center, in the left pane, click Installation.

  6. In the right pane, click New SQL Server stand-alone installation or add features to an existing installation.

  7. If a compatibility warning is displayed, click Run program.

  8. On the Setup Support Rules page, click OK.

  9. On the Product Key page, type your product key, and then click Next.

  10. On the License Terms page, review the license agreement and, if you agree, select the I accept the license terms check box, and then click Next.

  11. On the Setup Support Files page, click Install.

  12. On the Setup Support Rules page, click Next.

  13. On the Feature Selection page, select the following check boxes:

    • Database Engine Services

    • Analysis Services

    • Reporting Services

    • Management Tools - Complete

    Note

    We also recommend that you install SQL Server Books Online.

  14. Click Next.

  15. On the Instance Configuration page, leave the Default instance option selected, and then click Next.

  16. On the Disk Space Requirements page, click Next.

  17. On the Server Configuration page, set an Account Name and Password for each service listed. We recommend that you use the SQL Server administrator account for this.

  18. Set the Startup Type for the SQL Server Agent service to Automatic.

  19. Click Next.

  20. On the Database Engine Configuration page, select the Mixed Mode option, and type and confirm a password for the built-in SQL Server administrator account.

  21. Click Add Current User to add the current user account as a SQL Server administrator.

  22. Click Next.

  23. On the Analysis Services Configuration page, click Add Current User to add the current user account as an Analysis Services administrator.

  24. Click Next.

  25. On the Reporting Services Configuration page, select the Install the native mode default configuration option, and then click Next.

  26. On the Error and Usage Reporting page, leave the default values and then click Next.

  27. On the Installation Rules page, click Next.

  28. On the Ready to Install page, click Install.

  29. When the setup process is complete, click Next.

  30. On the Complete page, click Close.

Install SQL Server 2008 updates

Windows Server 2008 requires Service Pack 1 for SQL Server 2008. If the version of SQL Server 2008 that you installed did not include Service Pack 1, then you must install Service Pack 1 next. Perform the following procedure to install Service Pack 1 for SQL Server 2008.

To install SQL Server 2008 SP1

  1. Attach the DVD that contains SQL Server 2008 SP1 to the virtual DVD drive.

  2. On the DVD drive, double-click the KB968369 executable file.

  3. On the Welcome page, click Next.

  4. On the License Terms page, review the license agreement and if you agree, select the I accept the license terms check box, and then click Next.

  5. On the Select Features page, click Select All, and then click Next.

  6. On the Check Files in Use page, click Next.

  7. On the Ready to Update page, click Update.

  8. On the Update Progress page, click Next.

  9. On the Complete page, click Close.

Microsoft SharePoint Server 2010 and Microsoft Project Server 2010 require Cumulative update package 2 for SQL Server 2008 Service Pack 1. Download the cumulative update at the following location:

https://support.microsoft.com/kb/970315 (https://go.microsoft.com/fwlink/p/?LinkID=165962)

Perform the following procedure to install Cumulative update package 2 for SQL Server 2008 Service Pack 1.

To install SQL Server 2008 SP1 CU2

  1. Attach the DVD that contains SQL Server 2008 SP1 CU2 to the virtual DVD drive.

  2. On the DVD drive, double-click the KB970315 executable file.

  3. On the Welcome page, click Next.

  4. On the License Terms page, review the license agreement and, if you agree, select the I accept the license terms check box, and then click Next.

  5. On the Select Features page, click Select All, and then click Next.

  6. On the Check Files in Use page, click Next.

  7. On the Ready to Update page, click Update.

  8. On the Update Progress page, click Next.

  9. On the Complete page, click Close.

  10. Restart the virtual machine.

When SQL Server 2008 and the required updates have been installed, the next step is to create a login for the Farm Administrator account (Litware\FarmAdmin) to provide the necessary permissions for SharePoint Server 2010 and Project Server 2010 installation and configuration.

Perform the following procedure to create a login for the Farm Administrator account.

To create a login for the Farm Admin

  1. In SQL Server Management Studio, expand Security, right-click Logins, and then click New Login.

  2. In the Login name box, type Litware\FarmAdmin.

  3. In the left pane, click Server Roles.

  4. Select the sysadmin and dbcreator server roles.

  5. Click OK.

Once the Farm Administrator account has been configured on SQL Server 2008, the next step is to install SharePoint Server 2010 on the Litware-Proj virtual machine. Proceed to the next article, Install SharePoint Server 2010 on a Project Server 2010 test environment.

Configure SQL Server network protocols

SharePoint Server 2010 requires that SQL Server 2008 allow connections over TCP/IP. Depending on your SQL Server configuration, this may or may not be enabled by default. Use the following procedure to confirm that TCP/IP access is enabled.

To enable connections over TCP/IP

  1. On the computer that is running SQL Server, click Start, click All Programs, click Microsoft SQL Server 2008, click Configuration Tools, and then click SQL Server Configuration Manager.

  2. Expand the SQL Server Network Configuration node.

  3. Click Protocols for MSSQLSERVER.

  4. In the Protocol Name list, confirm that TCP/IP is Enabled. If it is not, right-click TCP/IP, and then click Enable.

  5. If TCP/IP was disabled, restart the SQL Server service for the new setting to take effect.