ArcSDE database servers are configured to automatically start when the computer on which they are installed is started. When you stop, pause, or start a database server from within ArcCatalog, you are stopping, pausing, or starting the SQL Server Express instance.
Before you can stop or pause a database server, you must disconnect from it.
NOTE: Only Windows administrators can stop/start and pause/resume the database server.
In the Catalog tree, the icon of the database server gives you an indication of the state of the database server or your connection to it.
- A server with a red X on it indicates you are disconnected from a running database server.
- A server that has a red square in the lower right corner means the database server (the SQL Server Express instance) is stopped and is not accepting connections.
- If the server icon has a white square with two red lines in it, the SQL Server Express instance is paused and the database server will not accept any new connections. Existing connections will continue to function normally.
- If the database server has a blank box on it, this means the state of the database server is unknown. An unknown server may be a server that no longer exists, a server that is off the network temporarily, or a server that is running normally. It does not indicate that connections cannot be made.
- When the database server is running and you are successfully connected to it, the server icon will appear with no other symbols on it.
- Right-click your database server connection in the Catalog tree and click Disconnect.
- Right-click the database server again and click Stop. This will shut down the SQL Server Express instance.
NOTE: Shutting down a SQL Server Express instance will sever any existing connections.
