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. You can follow the SQL Server Express installation steps outlined in the Installing SQL Server Express with Advanced Services section of the Install_sqlexpress.htm file in the ArcGIS Installation Guide.

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.

Führen Sie folgende Schritte aus, um SQL Server Express mithilfe der ausführbaren Datei der ArcGIS Server Workgroup-, ArcGIS Desktop- oder ArcGIS Engine-Installationsdatenträger auf dem Computer zu installieren.

Tipp:

Wenn Sie bereits eine Instanz von SQL Server Express with Advanced Services installiert haben, die Sie verwenden möchten, deaktivieren Sie die Option "Microsoft SQL Server Express Edition" im Dialogfeld "+++ArcSDE for SQL Server Express Installation Options", und fahren Sie mit Aktivieren von SQL Server Express für die Speicherung von Geodatabases fort.

Schritte:

1. Melden Sie sich am Computer als Benutzer mit Administratorrechten an.
2. Stellen Sie sicher, dass sich Microsoft Windows Installer 4.5, .NET Framework 3.5 Service Pack 1 (SP) und Windows PowerShell 1.0 oder 2.0 auf dem Computer befindet. Ist dies nicht der Fall, müssen Sie diese Komponenten von der Microsoft-Website herunterladen und installieren, bevor Sie SQL Server 2008 Express installieren können. Einige dieser Anwendungen erfordern, dass Sie den Computer neu starten, nachdem Sie sie installiert haben.
3. Schließen Sie alle Anwendungen auf dem Computer.
4. Greifen Sie auf die Installationsmedien zu.
   • Bei einer ISO-Datei verwenden Sie ein ISO-Extraktionsprogramm, um auf die Installationsdateien zuzugreifen, und führen Sie "ESRI.exe" aus.
   • Wenn Sie eine ArcGIS Server Workgroup-, ArcGIS Desktop- oder ArcGIS Engine-DVD haben, legen Sie diese in das entsprechende Laufwerk ein, und führen Sie "ESRI.exe" aus.

   Das Dialogfeld +++Installation Options wird geöffnet.

5. Wählen Sie das zu installierende Produkt aus.
   • Wenn Sie die 32-Bit-Version von SQL Server Express installieren möchten, klicken Sie auf ArcSDE for SQL Server Express.
   • Wenn Sie die 64-Bit-Version von SQL Server Express installieren möchten, klicken Sie auf ArcSDE for SQL Server Express (64 bit).
6. Lassen Sie die Option Microsoft SQL Server 2008 Express Edition im Dialogfeld +++ArcSDE for SQL Server Express Installation Options aktiviert, und klicken Sie auf Installieren.
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.

    Hinweis:

    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.

    Hinweis:

    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.

    Hinweis:

    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.