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.
Sugerencia: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.
Siga estos pasos para instalar SQL Server Express en el equipo utilizando el archivo ejecutable de los discos de instalación de ArcGIS Server Workgroup, ArcGIS Desktop o ArcGIS Engine.
- Inicie sesión en el equipo como usuario con privilegios de administrador.
- Asegúrese de que tiene instalado en el equipo Microsoft Windows Installer 4.5, .NET Framework 3.5 Service Pack (SP) 1 y Windows Powershell 1.0 o 2.0. Si no los tiene, debe obtenerlos en el sitio web de Microsoft e instalarlos para poder instalar SQL Server 2008 Express. Algunas de estas aplicaciones requieren reiniciar el equipo tras la instalación.
- Cierre todas las aplicaciones en el equipo.
-
Vaya al disco de instalación.
- Si tiene un archivo ISO, utilice un extractor de ISO para acceder a los archivos de instalación y ejecutar ESRI.exe.
- Si tiene un DVD de ArcGIS Server Workgroup, ArcGIS Desktop o ArcGIS Engine, introdúzcalo en la unidad adecuada y ejecute ESRI.exe.
Se abre el cuadro de diálogo Installation Options.
-
Elija el producto que desea instalar.
- Si desea instalar la versión de 32 bits de SQL Server Express, haga clic en ArcSDE para SQL Server Express.
- Si desea instalar la versión de 64 bits de SQL Server Express, haga clic en ArcSDE for SQL Server Express (64 bit).
- Deje activada la opción Servidor SQL de Microsoft 2008 Express Edition en el cuadro de diálogo ArcSDE for SQL Server Express Installation Options y haga clic en Instalar.
- 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.
- Click OK when the check is finished.
- 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.
- Click Next to proceed to the next dialog box.
- Choose the Perform a new installation of SQL Server 2008. option.
- Click Next.
- You are installing the Express edition, so choose the Specify a free edition option on the Product Key dialog box.
- Accept the Microsoft license agreement and click Next.
Nota:If you do not accept, the installation terminates. - On the Feature Selection dialog box, be sure that the Database Engine Services and Full-Text Search check boxes are checked.
- On the Instance Configuration dialog box, click the Named instance option.
- The default name is SQLExpress. Keep the default name.Nota: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.
- You can accept the default location to create the instance or browse to a different location.
- 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.
- Click Next to continue.
- 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.
Nota: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.
- 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.
- Click Next.
The Database Engine Configuration dialog box appears.
- Choose Windows authentication mode.
This is the only authentication mode supported for use with the geodatabase accessed through the Database Servers node in ArcCatalog.
- 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.
- Click the Data Directories tab and specify the locations for your SQL Server Express files or accept the defaults.
- Click Next.
The Error and Usage Reporting dialog box appears.
- Optionally, choose to send information to Microsoft.
- Click Next.
The next dialog box checks to make sure all installation rules are met.
- Click Next to proceed.
- Review the summary of your SQL Server Express installation and click Install to perform the SQL Server Express installation.
- When the installation completes successfully, click Next, then Close to exit the Microsoft SQL Server installation wizard.