Views:
You can configure settings for external access to the SMS database and for database replication. If you enable external database access, an external system can perform a number of read-only tasks, such as reading the SMS database, generating additional custom reports, and replicating the database.
The SMS does not allow modifications to the database through external connections. External systems are restricted to read-only access to the SMS database. You can secure external access by granting access to a specific list of IP addresses.
Note
Note
Enabling external access and enabling database replication to an external system both require a reboot of the SMS server. Follow your company’s server downtime policies, including notification to the SMS client of the pending reboot.
The External Database Settings panel indicates whether the following services are enabled or disabled:
  • External Database Access – Allows read-only access to the SMS database. A typical use of this service is to allow an external reporting tool to generate custom reports. You must reboot the SMS to enable or disable this service. When enabled, the database name to connect to is ExternalAccess.
  • External Database Replication – Allows an external database server to replicate reporting data from the SMS. You must reboot the SMS to enable or disable this service.
  • Access Restrictions – Restricts external access to a specified list of IP addresses. You select these addresses from a list of user-defined Named Resources.
You can access Exports and archives to view snapshots and exported and archived SMS files.
For more information on the external database, see the SMS Web API Guide.