Database Registration Properties Dialog Box

Use this dialog box to register a new repository database with Meta Data Browser. You should only register repository databases. Databases that do not contain the standard repository SQL tables do not have viewable content in Meta Data Browser.

This dialog box is available when you run Meta Data Browser as a stand-alone snap-in. It is not available for use within SQL Server Enterprise Manager. For more information, see Using Meta Data Browser.

This dialog box appears when you right-click the Meta Data Services folder or an existing registered repository database and then click Register Database. You can also open this dialog box by clicking Edit Database Registration.

Options

Server

The name of a registered computer running Microsoft® SQL Server™ 2000.

Connection

Provides two authentication approaches that are identical to SQL Server database registration. For more information, search on "registered SQL Server properties" in SQL Server Books Online.

Database

The name of the repository database you want to register. Be sure to choose a database that has the repository SQL tables. These tables provide data for the Contents and Information folders.

Browse Mode

Specifies the browse mode for browsing contents and information models. The default selection is End User. Power User and Administrator modes provide additional browsing capability.

End User

The default user mode selection. End User mode supports read-only access to the Contents folder.

Power User

Power User mode supports read/write access to the Contents folder. In the Contents folder, Power Users can display and edit object properties.

Administrator

Administrator mode supports read-write access to the Contents folder, read-only access to the Information Models folder, and support for creating, editing, and deleting repository database registration. Repository Administrators can also install information models and view object identifier properties (such as ObjID and InternalID) in the Repository Object Properties dialog box.

Browse mode selection is available during new database registration. The browse mode that you select determines your degree of interaction with the database. To change the browse mode, you must edit the registration properties.

The browse mode selection you make applies to you. You cannot set or predetermine the browse mode for other users.

Database Registration Properties Dialog Box

Options

See Also