Summary: This article is for end users to determine appropriate options for installing SQL Server 2008 R2 Express and guidance on when customizing the installation may be necessary.
There are multiple installation packages available for SQL Server Express, ranging from a minimal installation containing only the database engine to a full installation containing all optional components of the Express package. In order to decide which installation package is right for you, this article provide guidance on:
All installation packages for SQL Server 2008R2 Express are available for download from the Microsoft download center, and are available in both 32-bit and 64-bit versions. Each package and the features it contains are described below.
Database Only: This package installs only the SQL Server database engine and should be used if you only require data storage. For example, if you are using an application that requires SQL Server Express and does not specify that it requires additional functionality such as Full-Text Search (http://msdn.microsoft.com/en-us/library/ms142571.aspx) or Reporting Services (http://msdn.microsoft.com/en-us/library/cc281020.aspx,) you would select this package.
Database with Management Tools: This package installs the SQL Server database engine as well as the SQL Server Management Studio Express (http://msdn.microsoft.com/en-us/library/ms365247.aspx,) and should be used if you require data storage and the ability to manage SQL Server and your databases from a graphical interface.
Database with Advanced Services: This package installs the SQL Server database engine, SQL Server Management Studio Express, the ability to run Full-Text Search (http://msdn.microsoft.com/en-us/library/ms142571.aspx) queries against the database, and the ability to generate reports from the database using Reporting Services (http://msdn.microsoft.com/en-us/library/cc281020.aspx).
Management Tools: Installs SQL Server Management Studio Express only. This option is useful if you have previously installed a package that did not include Management Studio, or if you wish to install the Management Studio on a separate computer from SQL Server 2008R2 Express and manage another SQL Server Express installation remotely.
Return to Top.
All installation packages for SQL Server 2008R2 Express are available for download from the Microsoft download center, and are available in both 32-bit and 64-bit versions. The installation packages can be downloaded from the following locations:
Note: The download page may prompt for registration before presenting the link to download the installation package.
Note: The download page contains links to both 32-bit and 64-bit versions of the package; please read the information presented on the download page and select the appropriate version for your system.
During setup, checks are performed to ensure that you have the necessary hardware and software required to successfully install SQL Server 2008R2 Express. If you are missing required software, you will be presented with a dialog box stating what is missing and a link that can be used to download the missing software.
However if you are planning on installing SQL Server Express on multiple computers, you may wish to download and install all prerequisite software and manually install it on all target computers.
To install a new installation of SQL Server 2008R2 Express, launch the installation package obtained from the download center and select New installation or add features to an existing installation from the SQL Server Installation Center.
During the installation, you will be presented with several choices that allow you to customize how SQL Server Express is installed. Default values will already be selected for all choices presented, and you can simply select Next to continue installation. Information on common customizations to the SQL Server Express process are described after the Upgrading information below.
If you are upgrading from SQL Server 2000, SQL Server 2005 or SQL Server 2008 to SQL Server 2008R2, launch the installation package and select Upgrade from SQL Server 2000, SQL Server 2005 or SQL Server 2008 in the SQL Server Installation Center.
For more information, see “How to Identify Your SQL Server Version and Edition” (http://support.microsoft.com/default.aspx/kb/321185).
SQL Server Express supports the concept of instancing, which allows multiple copies of SQL Server to be running simultaneously on your system. Each instance must have a unique name. By default, SQL Server 2008R2 Express uses the instance name of “SQLEXPRESS”; however there are several scenarios that may require you to provide a different name:
NOTE: You cannot change instance names once the installation is complete.
If you develop software applications that embed SQL Server 2008R2 Express, custom installations are typically required. For more information, see How to Embed SQL Server Express in an Application (http://social.technet.microsoft.com/wiki/contents/articles/how-to-embed-sql-server-express-in-an-application.aspx).
Some SQL Server configuration settings can only be set during install. Once the installation is complete, you cannot change these settings. Any change to the configuration settings would require a new installation of the product. Some settings directly impact how data is stored and organized so changing the configuration setting would require significant data manipulation work in order to preserve the data.
Setting the non-Default Collation
Collations effect how characters (data) for a language or alphabet are recognized and sorted. The majority of SQL Server installations use the default collation. There are some situations where the use of a collation other than the default collation setting would be required.
For more information, see Collation Settings in Setup (http://msdn.microsoft.com/en-us/library/ms143508(SQL.105).aspx).
The Filestream configuration setting specifies where to store unstructured data such as text documents, images or videos. You can store this unstructured data inside the database or outside the database in the NTFS files system. The default setting is to store the data inside the database. Storing outside the database can cause data management complexities. You should consider enabling FILESTREAM if:
For smaller objects, storing unstructured data in the database often provides better streaming performance.
For more information, see FILESTREAM Overview (http://msdn.microsoft.com/en-us/library/bb933993.aspx) and FILESTREAM Storage in SQL Server 2008 (http://msdn.microsoft.com/en-us/library/cc949109.aspx).
Enabling the Error Reporting setting allows you to report Windows and SQL Server errors to Microsoft via the internet. Microsoft uses these error reports to improve future releases of SQL Server. Error reports contain only technical data. All error reports are confidential and anonymous.
Customizing Installation Directories
Installation directories are unique folder locations used for placement of:
During installation, you have the option to changing the default directories for some or all of the folders. Business requirements or environmental factors may dictate specifying directories other than the default.
Configuring SQL Server Service Accounts
SQL Server includes many services ranging from tools such as SQL Server Browser service to major product components such as Reporting services. During installation, you can specify which services to install and the account in which they run under. By default, most SQL Server services run under the Network Service account during initial setup. For better manageability and a more secure environment, it is recommended you:
For more information, see Setting Up Windows Service Accounts (http://msdn.microsoft.com/en-us/library/ms143504.aspx).
For more information:
http://www.microsoft.com/sqlserver/: SQL Server Web site
http://technet.microsoft.com/en-us/sqlserver/: SQL Server TechCenter
http://msdn.microsoft.com/en-us/sqlserver/: SQL Server DevCenter