Overview of SQL Server 2008 R2 Express Edition
the Instance Configuration screen, specify whether you want to install SQL
Server 2008 R2 Express Edition as a default instance or as a named instance. If
you choose to install SQL Server 2008 R2 Express as a default instance then the
Name and Instance ID will be MSSQLSERVER. In this screen you can also choose
the instance root directory where SQL Server 2008 R2 Express needs to be
installed. Click Next to continue with the installation.
the Server Configuration screen configure both Service Accounts information and
Collation. In the Service Account tab, provide the service account details under
which SQL Server Services should run. In this screen itself you can specify the
startup type for each of those SQL Server Services. The three startup type
options available are Automatic, Manual & Disabled.
click on Collations tab, select the appropriate collation value as per your requirements
or else choose the default value. Click Next to continue with the installation.
the Database Engine Configuration screens, in the Account Provisioning tab
specify the authentication mode and administrators for the database engine.
Authentication Mode: – SQL Server supports two authentication modes, Windows
and Mixed Mode Authentication. If selecting Mixed Mode Authentication then a
very strong password must be used for the SQL Server System Administrator (SA)
account. Being a System Administrator If you would like to add other users as
administrators to SQL Server 2008 R2 Express Edition; then run the script which
is mentioned in Get
admin rights to your local SQL Server Express with this simple script link.
Click on the Data
Directories tab in the Database Engine Configuration screen to specify the non
default installation directory. It’s possible to place System Databases, User
Databases, User Databases Log, TempDB Data, TempDB Log and Backup directory in
a different directory other than the default. It’s a good practice to
store database log files on a separate disk from database files. Performance
may be improved as log file I/O’s are sequential and database file I/O’s are
random. It is also advised to keep TempDB related data and log files on a
separate log file to improve performance.
Next, click on the FILESTREAM
tab in the Database Engine Configuration screen to enable FILESTEAM feature in
the instance of SQL Server. Refer to the previous article titled Configure
Filestream in SQL Server 2008 to read more about
configuring FILESTREAM feature in SQL Server 2008. Click Next to save the
configuration changes and to continue the installation.
10. In the Reporting Services Configuration screen there are three choices
available to configure reporting services in SQL Server 2008 R2 Express Edition.
a) Install native mode default configuration
b) Install SharePoint
integrated mode default configuration
c) Install, but do
not configure the report server
Make the right choice per your requirements and click Next
to continue with the installation.