Overview of SQL Server 2008 R2 Express Edition
6. In 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.
7. In 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.
8. Next, 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.
9. In 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.