Creating and starting an ArcSDE service for SQL Server

The last step in the ArcSDE for SQL Server Post Installation wizard is optional. It adds an entry for the service in the Windows services and ArcSDE services.sde files using the information you provide in the wizard. Then it creates an ArcSDE service, adds it to the Windows registry, and starts the service.

The ArcSDE service information dialog box of the Post Installation wizard can be accessed by doing either a complete or custom postinstallation setup.

Steps:

1. Navigate to the ArcSDE service information dialog box of the Post Installation wizard.

   The Post Installation wizard automatically opens at the end of the ArcSDE component installation wizard. It can be accessed at a later time by clicking Start > All Programs > ArcGIS > ArcSDE > ArcSDE Post Installation for SQL Server.

2. Type a unique name for the service in the Service text box.
3. Type a unique TCP/IP port number followed by /tcp in the Service text box.

   6789/tcp

4. What user information you provide depends on the type of schema you are using.
   • If you are creating a service for an sde-schema geodatabase, the ArcSDE Login text box is automatically populated with sde.
   • If you are creating a service for a dbo-schema geodatabase, type in the ArcSDE DBA login text box the user name of a database or Windows-authenticated login that is dbo in the SQL Server database.
5. Similarly, the password you type depends on the geodatabase schema.
   • If the geodatabase is in the sde schema, type the password of the sde user in the ArcSDE Password text box.
   • If the geodatabase is in the dbo schema, type in the ArcSDE DBA Password text box the password for the dbo user you specified in the ArcSDE DBA login text box.
6. In the Database name text box, type the name of the database that contains the geodatabase.
7. Type the name of the SQL Server instance that contains the database with the geodatabase in the SQL Server instance name text box.
8. In the Server name text box, type the name of the server on which the database resides.
9. Click Next.
10. When prompted, click OK to start the service.
    Tip:

    If, instead, a dialog box appears asking for a different service name or port number, it means you typed a service name or port number that is already in the services files. Type a unique name and port number to continue.

    If the service name and port number are in the services files erroneously, you can manually remove them. However, if the service still exists but is not in use, you must delete the service then remove the entries from the services files. Then you can reuse the service name and port number.