Installing SQL Server Express

Follow these steps to install SQL Server Express on your computer using the executable provided with the ArcGIS for Server Workgroup, ArcGIS for Desktop, or ArcGIS Engine installations.

Tip:

If you already have an instance of SQL Server Express with Advanced Services installed that you want to use, uncheck the Microsoft SQL Server Express Edition option checked on the ArcSDE for SQL Server Express Installation Options dialog box and skip to Enabling SQL Server Express to store geodatabases.

Steps:

1. Log in to the computer as a user with administrative privileges.
2. Make sure you have Microsoft Windows Installer 4.5, .NET Framework 3.5 Service Pack (SP) 1, and Windows Powershell 2.0 on the computer. If you do not, you must obtain and install them from the Microsoft site before you can install SQL Server 2008 R2 Express. Some of these applications require you to restart your computer after installing them.
3. Close all applications on your computer.
4. Access the installation media.
   • If you downloaded the installation file from the My Esri, unzip the file and run either the ArcSDE_for_Microsoft_SQL_Server_2008_R2_Express_Personal_<version>_<part_number>.exe or the ArcSDE_for_Microsoft_SQL_Server_2008_R2_Express_Workgroup_<version>_<part_number>.exe.
   • If you have an ISO file, use an ISO extractor to access the installation files and run the ArcSDE_for_Microsoft_SQL_Server_2008_R2_Express_Personal_<version>_<part_number>.exe or the ArcSDE_for_Microsoft_SQL_Server_2008_R2_Express_Workgroup_<version>_<part_number>.exe.
   • If you have an ArcGIS for Server Workgroup, ArcGIS for Desktop, or ArcGIS Engine DVD insert it to the appropriate drive and run either the ArcSDE_for_Microsoft_SQL_Server_2008_R2_Express_Personal_<version>_<part_number>.exe or the ArcSDE_for_Microsoft_SQL_Server_2008_R2_Express_Workgroup_<version>_<part_number>.exe.
5. Leave the Microsoft SQL Server Express Edition option checked on the Installation Options dialog box and click Next.
6. The Microsoft SQL Server installation wizard is the same for all editions of SQL Server. Use the installation wizard to install SQL Server 2008 R2 Express as follows:
   1. On the Installation Type dialog box, be sure Installation Type is selected on the left pane of the SQL Server 2008 R2 Setup wizard, choose the New installation or add shared features option, and click Next.
   2. Read then accept the Microsoft license agreement.

      Note:

      If you do not accept, the installation terminates.

   3. On the Feature Selection dialog box, be sure Database Engine Services and Full-Text Search are selected.
   4. On the Instance Configuration dialog box, be sure Named instance is selected. The default name is SQLExpress. You can accept this name or type a different name.

      Note:

      The instance name cannot exceed 16 characters, must start with a letter, cannot contain spaces or special characters, and must not duplicate an existing instance name.

   5. Also, on the Instance Configuration dialog box, you can accept the default location to create the instance or browse to a different location. Click Next to continue.
   6. On the Server Configuration dialog box, specify accounts to run the Database Engine, Full-Text Search, and Browser services. Default accounts are already set for you, but you can specify different accounts. See the Microsoft SQL Server 2008 Books online for information on accounts to use for running services. This topic should help you get started: http://msdn.microsoft.com/en-us/library/ms143504.aspx#Review_windows_permissions.

      Be sure the Database Engine and Browser services are set to start automatically.

   7. The SQL Server Express instance uses the default collation of the computer on which it is installed. If you need to choose a different collation, click the Collation tab and change the Database Engine language before proceeding. Be sure to use a case-insensitive collation, as case-sensitive collations are not supported with ArcGIS. Click Next to go to the next dialog box.
   8. On the Database Engine Configuration dialog box, be sure the Windows authentication mode is selected. This is the only authentication mode supported for use with the geodatabase accessed through the Database Servers node in ArcCatalog.
   9. Add an administrative user for the SQL Server Express instance.

      You cannot proceed with the installation if you do not add an administrative user.

   10. Click the Data Directories tab and specify the locations for your SQL Server Express files, or accept the defaults and click Next.
   11. On the Reporting Services Configuration dialog box, you can accept the default value. Click Next to proceed.
   12. On the Error Reporting dialog box, you can optionally choose to send information to Microsoft. Click Next to proceed with the installation.
   13. When your installation is complete. click Close to exit the Microsoft SQL Server installation wizard.