Install a new instance of SQL Server 2008 for Windows SBS 2008 for Windows SBS 2008 migration

  • Article

Updated: January 22, 2009

Applies To: Windows SBS 2008

To install a new instance of SQL Server 2008

  1. Insert the Microsoft SQL Server 2008 Standard Edition for Small Business disc into your DVD drive, and then run either D:\SQL2008\x64\Servers\setup.exe or D:\SQL2008\x86\Servers\setup.exe, where D is the letter of your DVD drive.

Important

If you are installing SQL Server 2008 in a 32-bit version of Windows Server 2008, you must use D:\SQL2008\x86\Servers\setup.exe.

Note

If you are installing SQL Server 2008 to use with a line-of-business (LOB) application, see the documentation for that application to ensure that it is compatible with SQL Server 2008 and to determine if there are specific configuration requirements.

  1. If the .NET Framework 2.0 installation dialog box appears, on the End User License Agreement page, review the licensing agreement. To continue, you must accept the agreement, and then click Next.

  2. When .NET Framework 2.0 is installed, click Finish.

  3. On the End User License Agreement page, review the licensing agreement. To continue, you must accept the agreement.

  4. On the Installation Prerequisites page, click Install.

  5. After the prerequisites are installed, the SQL Server Installation Center is opened in a new window. Click New Installation in the task list. The Install SQL Server 2008 window opens.

  6. On the System Configuration Check page, verify that you have no potential installation problems, and then click Next.

  7. On the Feature Selection page, click the Database Engine Services check box. If your LOB application requires that you install the Microsoft SQL Server 2008 Reporting Services component, click the Reporting Services check box. You can also click any of the other check boxes to install additional features. Click Next.

  8. On the Instance Configuration page, choose the Default instance, and then click Next.

Important

If you are installing SQL Server 2008 as part of your LOB installation, consult the documentation for the LOB application in order to determine whether you need to create a named instance of SQL Server 2008 other than the Default instance.

  1. On the Server Configuration page, do the following:

    1. Type the service account and password for each service. Or type a shared account and password in Use the same account for all fields, and then click Apply to all.

Important

You can use either a local user account or a domain user account as the service accounts. If you use a domain user account, the server that you are installing SQL Server 2008 on must be connected to the domain. 

2.  On the **Collation** tab, specify non-default collations for the Database Engine and Analysis Services. For more information, see [Specify SQL Server collation settings for Windows SBS 2008 migration](cc527470\(v=ws.10\).md).

3.  Click **Next**

  1. On the Database Engine Configuration page, do the following:

    1. Click Windows Authentication Mode.

    2. In Specify SQL Server administrators, click Add or Remove to select the user accounts.

    3. You can also click Add Current User to add the current user account to the administrators list.

    4. Click Next.

  2. If you are installing the Analysis Services feature, the Analysis Services Configuration page is displayed. Do the following:

    1. Click Windows Authentication Mode.

    2. In Specify SQL Server administrators, click Add or Remove to select the user accounts.

    3. You can also click Add Current User to add the current user account to the administrators list.

    4. Click Next.

  3. On the Reporting Services Configuration page, click Install the Native mode default configuration, and then click Next.

  4. On the Error and Usage Reporting page, you can choose to automatically send error reports to Microsoft or to your corporate error-reporting server. You can also choose to send data about feature usage for SQL Server 2008 to Microsoft. Click Next.

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

  6. Click Next when it becomes available on the Setup Progress page.

  7. On the Complete page, click Close.

Important

When you finish installing Reporting Services, you must run the Reporting Services Configuration Manager to fully configure and enable Reporting Services. See the documentation for your LOB application to determine the specific configuration settings.

For more information about SQL Server 2008 Standard Edition for Small Business, see the Microsoft Web site (https://go.microsoft.com/fwlink/?LinkId=120782).