SvcMgr: Install SQL Server 2008 x64

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

Prerequisites

• Windows Server 2008 R2 was installed on the server.
• You have installed the prerequisites: IIS, ASP.NET and .NET Framework 3.5.1

Installation and configuration steps

1. Logon on the SCSM server using the domain Administrator account.
2. Insert the SQL Server 2008 x64 installation media. In the Microsoft SQL Server 2008 Setup window click OK.
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 Setup Support Rules window verify that all rules were met then click OK.
6. In the Product Key window select Enter the product key then click Next.
7. In the License Terms window check I accept the license terms and click OK.
8. In the Setup Support Files window click Install.
9. In the Setup Support Rules window verify that there are no errors and click Next.
10. In the Feature Selection window select Database Engine, Full-Text Search, Reporting Services and Management Tools then click Next.
11. In the Instance Configuration window accept the Default instance and click Next.
12. In the Disk Space Requirements window click Next.
13. In the Server Configuration window under Account Name select NT AUTHORITY\SYSTEM for all services then select the Collation tab.
14. At the Collation tab select the Latin1_General_100_CI_AS collation then click Next.
15. In the Database Engine Configuration window click Add Current User.
16. In the Database Engine Configuration window click Next.
17. In the Reporting Services Configuration window select Install the native mode default configuration and click Next.
18. In the Error and Usage Reporting window click Next.
19. In the Installation Rules window verify that all rules were met and click Next.
20. In the Ready to Install window click Install.
21. In the Installation Progress window wait for the installation to complete then click Next.
22. 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.