Accessing Server Registration Options

Administering SQL Server

Administering SQL Server

Accessing Server Registration Options

Microsoft® SQL Server™ allows you to maintain shared or private registry information. Shared registry information allows multiple users to use the same configuration from the same local computer or from a central computer. Alternatively, private registry information prevents others from gaining access to your configuration.

You can access server registration information in two ways:

  • Remotely, on a central computer referred to as the central store.

    Remotely accessing the server registration information stored on a central computer allows different client computers to view shared registry information. For example, the system administrator registers servers x, y, and z to view server activity. With a central registration store, the system administrator can view all servers from any client.

    Note  To read server registration information from a remote server, you must have servers registered and disable the Store User Independent option on the remote computer.

  • Locally, accessing either private or shared information.

    From a local computer, the system administrator can make changes to the central store and configure SQL Server Enterprise Manager to save registration information without enabling the Store User Independent option. The Store User Independent option allows all users to share registration information. When this option is disabled, the central store maintains private registration information for each user.

To set up a central store for server registration information