CfgMgr: Install SQL Server 2008 with Service Pack 1

This procedure describes the steps for installing and configuring SQL Server 2008 x64 on the CfgMgr server.

Note: The installation described below was performed using a SQL Server 2008 RTM installation media, after which we have applied Service Pack

Prerequisites

• Active Directory and DNS server are installed and configured for the domain TECHREADY.RO.
• Windows Server 2008 R2 was installed on the server where SQL Server 2008 will be installed.

Installation and Configuration

1. Logon on the server using the domain Administrator account
2. Insert the SQL Server 2008 x64 installation media. In the Program Compatibility Assistant window click Run Program.
3. SQL Server Installation Center will start. From the left pane select Installation.
4. In the Installation section select New SQL Server stand-alone installation or add features to an existing installation.
5. In the Program Compatibility Assistant window click Run Program.
6. In the Setup Support Rules window verify that all rules were met then click OK.
7. In the Product Key window select Enter the product key then click Next.
8. In the License Terms window check I accept the license terms and click OK.
9. In the Setup Support Files window click Install.
10. In the Setup Support Rules window verify that there are no errors and click Next.
11. In the Feature Selection window select Database Engine, Reporting Services and Management Tools then click Next.
12. In the Instance Configuration window accept the Default instance and click Next.
13. In the Disk Space Requirements window click Next.
14. In the Server Configuration window under Account Name select NT AUTHORITY\SYSTEM for all services then select the Collation tab.
15. At the Collation tab accept the default collation settings and click Next.
16. In the Database Engine Configuration window click Add Current User.
17. In the Database Engine Configuration window click Next.
18. In the Reporting Services Configuration window select Install the native mode default configuration and click Next.
19. In the Error and Usage Reporting window click Next.
20. In the Installation Rules window verify that all rules were met and click Next.
21. In the Ready to Install window click Install.
22. In the Installation Progress window wait for the installation to complete then click Next.
23. In the Complete window click Close.

Next we will apply Service Pack 1 for SQL Server 2008 x64.

1. From the folder where you downloaded Service Pack 1 for SQL Server 2008 x64 launch the executable. Note: If you encounter an error while launching, expand the archive and run the Setup program from the folder.
2. In the Welcome window verify the prerequisites and click Next.
3. In the License Terms window check I accept the license terms and click Next.
4. In the Select Features window click Next.
5. In the Check Files In Use window click Next.
6. In the Ready to Update window click Update.
7. In the Update Progress window wait for the operation to complete and click Next.
8. In the Complete window click Close.