Export (0) Print
Expand All

Accessing Server Registration Options

SQL Server 2000

  New Information - SQL Server 2000 SP3.

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.

If you choose to store server registration information locally (by selecting the Read/Store locally option on the SQL Server Enterprise Manager Properties dialog box, General tab), you must also specify whether to store server registration information independent of each user:

  • Selecting the Store User Independent check box on the General tab of the SQL Server Enterprise Manager Properties dialog box maintains private registration information for each user, and does not allow multiple users to share the registered server configuration.

  • Clearing the Store User Independent check box allows multiple users to share the same server configuration.

    Security Note  For enhanced security when connecting using SQL Server Authentication, select the Store User Independent option.

To set access to your display of servers and groups

Enterprise Manager

SQL-DMO

Show:
© 2014 Microsoft