Installing and configuring SQL Server Express

The production databases need to reside in SQL Server Express. This allows the implement and populate processes of the Nautical Solution to function.

To use ArcSDE with ArcGIS Desktop, you need to install an instance of SQL Server Express, then enable it to store ArcSDE geodatabases.

提示:

如果已安装要使用的 SQL Server Express with Advanced Services 实例，请取消选中“ArcSDE for SQL Server Express 安装选项”对话框中选中的 Microsoft SQL Server Express Edition 选项，然后跳至启用 SQL Server Express 来存储地理数据库。

If you are not an administrator of the machine, your login needs to be added to the SQL Server Express administrator role. Once you enable SQL Server Express to store geodatabases, open ArcCatalog, connect to the local database server, right-click on the server, then choose Permissions to verify that you are listed with administrator privileges.

按照以下步骤使用 ArcGIS Server Workgroup、ArcGIS Desktop 或 ArcGIS Engine 安装媒介上的可执行文件将 SQL Server Express 安装在计算机上。

步骤:

1. 以具有管理权限的用户身份登录到计算机。
2. 确保计算机上装有 Microsoft Windows Installer 4.5、.NET Framework 3.5 Service Pack (SP) 1 以及 Windows Powershell 1.0 或 2.0。如果未安装，则必须从 Microsoft 站点获取并安装它们，然后再安装 SQL Server 2008 Express。其中一些应用程序在安装后需要重新启动计算机。
3. 关闭计算机上的所有应用程序。
4. 访问安装介质。
   • 如果您拥有 ISO 文件，那么请使用 ISO 提取程序进入安装文件并运行 ESRI.exe。
   • 如果您拥有 ArcGIS Server Workgroup、ArcGIS Desktop 或 ArcGIS Engine 的 DVD，那么请将它插入到相应的驱动器中，然后运行 ESRI.exe。

   将打开安装选项 对话框。

5. 请选择要安装哪个产品。
   • 如果要安装 SQL Server Express 的 32 位版本，请单击 ArcSDE for SQL Server Express。
   • 如果要安装 SQL Server Express 的 64 位版本，请单击 ArcSDE for SQL Server Express（64 位）。
6. 保持 ArcSDE for SQL Server Express 安装选项 对话框上 Microsoft SQL Server 2008 Express Edition 选项的选中状态，然后单击安装。
7. Click Installation on the left pane of the SQL Server Installation Center window, then click New SQL Server stand-alone installation or add features to an existing installation.

   The setup checks your computer to make sure it meets the minimum system requirements necessary to install SQL Server 2008 Express.

8. Click OK when the check is finished.
9. Install the setup support files.

   If you do not have the .NET Framework 3.5 SP1 installed, which is required by SQL Server 2008 Express, the setup will close.

10. Click Next to proceed to the next dialog box.
11. Choose the Perform a new installation of SQL Server 2008. option.

12. Click Next.
13. You are installing the Express edition, so choose the Specify a free edition option on the Product Key dialog box.
14. Accept the Microsoft license agreement and click Next.

    注意:

    If you do not accept, the installation terminates.

15. On the Feature Selection dialog box, be sure that the Database Engine Services and Full-Text Search check boxes are checked.

    

16. On the Instance Configuration dialog box, click the Named instance option.
17. The default name is SQLExpress. Keep the default name.

    注意:

    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.

18. You can accept the default location to create the instance or browse to a different location.

    

19. Click Next to continue.

    The installation checks to make sure you have enough disk space in the location you specified for the SQL Server Express instance.

20. Click Next to continue.
21. On the Server Configuration dialog box, specify accounts to run the Database Engine and Full-Text Search services.

    You should use different accounts for each one. The SQL Server Browser is already set to an account for you. See the Microsoft SQL Server 2008 books online for information on accounts to use for running services. This topic can help you get started: Reviewing Windows Permissions for SQL Server Services.

    注意:

    For SQL Server Database Engine service and SQL Full-text Filter Daemon Launcher service, a local user or domain user account is recommended. The account must have Full Control permissions over any folders where data or log files (.mdf, .ndf, .ldf) will reside. For the SQL Server Browser service, a Local System Account should be used as the account name. Change SQL Server browser's startup type to Automatic.

    

22. Click the Collation tab and change the Database Engine language before proceeding if you need to choose a different collation.

    The SQL Server Express instance uses the default collation of the computer on which it is installed. Be sure to use a case-insensitive collation; case-sensitive collations are not supported with ArcGIS.

23. Click Next.

    The Database Engine Configuration dialog box appears.

24. Choose Windows authentication mode.

    This is the only authentication mode supported for use with the geodatabase accessed through the Database Servers node in ArcCatalog.

25. Click Add current user to add an administrative user for the SQL Server Express instance.

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

26. Click the Data Directories tab and specify the locations for your SQL Server Express files or accept the defaults.
27. Click Next.

    The Error and Usage Reporting dialog box appears.

28. Optionally, choose to send information to Microsoft.
29. Click Next.

    The next dialog box checks to make sure all installation rules are met.

30. Click Next to proceed.
31. Review the summary of your SQL Server Express installation and click Install to perform the SQL Server Express installation.
32. When the installation completes successfully, click Next, then Close to exit the Microsoft SQL Server installation wizard.