Upgrading a SQL Server Express instance to Advanced Services

This topic applies to ArcEditor and ArcInfo only.

The version of SQL Server Express that is delivered with ArcGIS has changed with each release. The following lists the version of SQL Server Express that is delivered with each version of ArcGIS:

• ArcGIS 9.2: SQL Server 2005 Express Service Pack (SP) 2
• ArcGIS 9.3: SQL Server 2005 Express with Advanced Services
• ArcGIS 9.3.1 and 10: SQL Server 2008 Express with Advanced Services

If you were using database servers with an earlier release of ArcGIS, you can upgrade your SQL Server Express instance when you install ArcGIS 9.3 or later releases.

If you have SQL Server 2005 Express SP1, you can upgrade to SQL Server 2005 Express with Advanced Services by running the ArcGIS Desktop or ArcGIS Server Workgroup 9.3 executables. Alternatively, you can obtain SQL Server 2005 Express with Advanced Services from the Microsoft Web site. Read the SQL Server Books Online for information on upgrading the SQL Server Express instance in that case.

You can upgrade to SQL Server 2008 Express with Advanced Services from either SQL Server 2005 Express SP1 or SQL Server 2005 Express with Advanced Services. See Upgrading from SQL Server 2005 Express to SQL Server 2008 Express for those instructions.

Steps:

1. Before upgrading the SQL Server Express instance, create backups of all your geodatabases.

   See Creating a backup of a geodatabase on a database server for instructions.

2. Insert the ArcGIS Desktop 9.3, ArcGIS Engine 9.3, or ArcGIS Server Workgroup 9.3 DVD into a drive on the computer where SQL Server 2005 Express is installed.
3. When the installation options dialog box opens, click ArcSDE for SQL Server Express.
4. Leave the Microsoft SQL Server Express Edition option checked on the ArcSDE for SQL Server Express Installation Options dialog box. If you have a new ArcGIS Server Workgroup license, leave the postinstallation option checked. If not, uncheck the postinstallation option.
5. Click Install.
6. Accept the Microsoft SQL Server 2005 Express Edition with Advanced Services license agreement. If you do not accept, the setup exits and SQL Server Express is not installed.
7. The setup checks your computer for the Microsoft Windows Installer 3.1 and .NET 2.0 Framework, which are required by SQL Server 2005 Express. Since SQL Server Express is already installed, these components are already present. Click Next to proceed to the next dialog box.
8. Click Next on the Microsoft SQL Server 2005 Setup/Welcome to the Microsoft SQL Server Installation Wizard dialog box.
9. Microsoft does another system configuration check. When it completes, click Next.
10. On the Instance Name dialog box, click the Installed instances button.
11. Choose the instance you want to upgrade and click OK. Be sure to choose the correct instance.
12. Click Next.
13. The next dialog box, Existing Components, indicates that you will be upgrading the SQL Server Express instance. Click Next to proceed with the upgrade.

If the upgrade completes successfully, your instance now has the Advanced Services (including the full-text search) installed. If you want to take advantage of full-text indexing, you must create new geodatabases on your upgraded instance in ArcGIS Desktop and copy your existing data into these new geodatabases. (Remember, geodatabase names must be unique, so your new geodatabases must have names that are different than your original geodatabases.)

If the SQL Server Express upgrade did not successfully complete, you will need to uninstall your existing SQL Server Express instance and do a new installation of SQL Server Express with Advanced Services. To remove the SQL Server Express instance, see Uninstalling a SQL Server 2005 Express instance.