MS SQL Basics Tutorial: Registering a server

You can register a server in SQL Server by using the Registration Wizard and the Registration Properties dialog box in two ways. The registration process is as follows:

(1) Select the Action menu from the Enterprise Manager menu, select the New SQL Server Registration menu item from the Action menu, or select the icon from the toolbar to show the Register as shown in Figure 5-4 SQL Server Wizard (Server Registration Wizard) dialog box. If you select a check box in the first Interface of the wizard dialog box (as shown in Figure 5-4), pressing the Next button translates to the Server Registration Properties dialog interface, as shown in Figure 5-5. You can also select the Newsql Server registration menu item from the shortcut menu by right-clicking Microsoft SQL Servers or SQL Server Group.