|
|
|
Installing SQL Server 2008 |
|
|
|
|
|
||
|
Installing SQL Server 2008 |
|
|
|
|
|
|
Installing SQL Server 2008
|
|
|
Installing SQL Server 2008 |
|
|
|
|
|
||
|
Installing SQL Server 2008 |
|
|
|
|
|
|
On this page:
| 1. | Overview |
Microsoft SQL Server 2008 Express with Advanced Services (SQL Server 2008 Express) is a free, easy-to-use version of SQL Server Express that includes a graphical management tool and powerful features for reporting and advanced text-based searches. SQL Server 2008 Express provides powerful and reliable data management tools and rich features, data protection, and fast performance. It is ideal for small server applications and local data stores.
Supported Operating Systems:
| • | Windows Server 2003 Service Pack 2 |
| • | Windows Server 2008 |
| • | Windows Vista |
| • | Windows Vista Service Pack 1 |
| • | Windows XP Service Pack 2 |
| • | Windows XP Service Pack 3 |
32-bit systems
Computer with Intel or compatible 1GHz or faster processor (2 GHz or faster is recommended. Only a single processor is supported.)
Minimum of 512 MB of RAM (1 GB or more is recommended)
2 GB of free hard disk space
64-bit systems
1.4 GHz or higher processor (2 GHz or faster is recommended. Only a single processor is supported.)
Minimum of 512MB of RAM (1 GB or more is recommended)
2 GB of free hard disk space
You can check your computer to see if it is 32-bit or 64-bit by opening the Start Menu, right-clicking on "Computer" (or "My Computer") and select properties. A window will appear displaying information about your computer and the version of Windows you're using. If you're using Windows Server 2008 or Vista, you will see either 32-bit or 64-bit Operating System as the "System type". In previous versions of Windows, if you have a 64-bit version, it will say so underneath the Windows version. Whereas if you only see the Windows version and no indication of 32-bit or 64-bit, then you have a 32-bit operating system installed.
Before installing SQL Server 2008 Express, you will need to have the following prerequisites installed:
| 1. | Microsoft .Net Framework 3.5 SP1 (You may have to restart your computer after installing the Microsoft .Net Framework.) |
|
You should read the Release Notes and Readme before installing SQL Server Express with Advance Services.
|
Note: |
|---|---|
You must have administrative rights on the computer to install SQL Server Express. |
|
1. Download SQL Server 2008 Express with Advanced Services. There are two files available, although you only need to download the file that is appropriate for your computer.
| • | Download "SQLEXPRADV_x64_ENU.exe" if you will be installing SQL Server Express on a 64-bit computer. |
| • | Download "SQLEXPRADV_x86_ENU.exe" if you will be installing SQL Server Express on a 32-bit computer. |
2. Select Save and save the file to your desktop or a different location that is convenient. The files are over 500 MB and depending on your connection speed, it may take a while for the download to finish.
| 1. | After the download is complete, navigate to where you saved the file and double-click the file to start the SQL Server install. |
| 2. | If prompted, click Run to continue. A progress bar will be displayed as the installation is prepared. |
 |
| Due to security features in Windows, you may have to click Run in order to start the installation. |
 |
| The SQL Server installation will start after the installer prepares the necessary files on your computer. |
| 3. | After the installation is prepared, the SQL Server Installation Center will appear. Select the System Configuration Checker to launch a simple tool that checks for conditions that could prevent SQL Server from installing correctly. |
 |
| The SQL Server Installation Center |
| 4. | The System Configuration Checker will check multiple conditions of your computer and if all rules successfully pass, click OK. If you have any rules that fail, click the blue, underlined word Failed for more information as to why the rule failed and what needs to be done in order to fix the problem. |
 |
| In this example, the computer needs to be restarted before SQL Server can be installed. |
 |
| Clicking on the blue, underlined words will provide you with additional information about each rule. |
| 5. | After successfully running the System Configuration Checker with all rules Passed, select Installation on the left on the SQL Server Installation Center main screen. Then choose the New SQL Server stand-alone installation or add features to an existing installation option to start the installation process. |
| 6. | The installer will check several more rules before continuing. If all rules pass, click OK to continue. |
| 7. | Click Install to install the Setup Support Files. These files are necessary for SQL Server installation. |
| 8. | After the Setup Support Files are installed, additional rules will be checked. |
| 9. | Select the Perform a new installation of SQL Server 2008 option and click Next > to continue. |
| 10. | If you were installing the Standard, Workgroup or Enterprise Edition of SQL Server, this is where you would enter the license key. Click Next > to continue to the next step. |
| 11. | Check I agree to the license terms if you agree to the license terms and click Next > to continue. |
| 12. | Select the features of Microsoft SQL Server to install and click Next > to continue to the next step. |
Features to Install:
Instance Features |
||
|
||
|
||
|
||
|
||
Shared Features |
||
|
||
|
||
|
||
| 13. | Select Named Instance and enter CALLDATA for the name of the instance. Then select Next > to continue. |
|
Note: |
|---|---|
You can specify any instance name you want, although CALLDATA is recommended for clarity. |
|
| 14. | The installer will check to make sure enough space is available on your hard drive to install SQL Server. If you have sufficient space available, click Next > to continue with the installation. If you do not have sufficient space available to install SQL Server, you will need to free up additional space on your hard drive or install SQL Server on another computer before you can continue. |
| 15. | Microsoft SQL Server has multiple  services (A service is a program that runs in the background, even when nobody is logged into the computer.) that need to run in order to function properly. Each service can be ran under dedicated accounts, built-in accounts are any combination of both. For most configurations, using the built-in accounts is adequate.Under the Account Name column, clicking in one of the blank cells will open a drop-down menu allowing you to choose one of the built-in accounts or to choose an alternate account. Clicking the Use the same account for all SQL Server services button allows you to enter the account name and password once for all of the services. After configuring all of the necessary settings, click Next > to continue to the next step. |
|
Note: |
|---|---|
Cells that are grayed out cannot be changed. |
|
Service: |
The name of the respective service. |
Account Name: |
Account which the service will use to run. |
Password: |
Password for the specified account (only applicable when an account other than a built-in account is used). |
Startup Type: |
Manual: The service must be started manually. Automatic: Starts the service when the computer starts. |
| 16. | Select Mixed Mode and enter a password for the 'sa' account (the sa account is the SQL Server system administrator account and has complete control of the SQL Server). Also select Add Current User to add your Windows account to the list of SQL Server administrators. Optionally, you can click the Add... button to add other Windows accounts to the list of SQL Server administrators. When you're finished, click Next > to continue. |
| 17. | Select the Install the native mode default configuration option to use the native Reporting Services configuration instead of the SharePoint integrated mode. Click Next > to continue. |
| 18. | If you would like to send usage & error information with SQL Server to Microsoft or your own corporate error reporting server, then select the appropriate options and click Next > to continue. |
| 19. | The installer will check several more rules again and if all rules pass or are not applicable, click Next > to continue. Any rules that fail will cause the install to stop. All rules must pass in order to continue with the installation. |
| 20. | This screen will review the configuration for the SQL setup. Click Install to start the installation. |
| 21. | The progress of the installation will be displayed on the status bar. this may take a while depending on the performance of your computer. |
| 22. | After the installation is complete, the installer will inform you as to whether the installation has completed successfully or failed. If the install has failed, additional information will be provided on this screen. |
| 23. | After successfully installing Microsoft SQL Server 2008, you should ensure that you have the latest software updates with Microsoft Update. |
Next:
CallData Installation Instructions
See Also:
.png){kind=small}
