Monday, April 12, 2010

Use OF SQL Server Enterprise Manager

From the Microsoft SQL Server program group, choose Enterprise Manager
to open SQL Server Enterprise Manager.

2. Look at the SQL Server Enterprise Manager interface. SQL Server
Enterprise Manager uses the Microsoft Management Console (MMC)
interface. MMC enables you to “snap in” administrative tools so that you
can perform a variety of administrative tasks from within a single utility.
When you first open SQL Server Enterprise Manager, you see the MMC
displayed with the Microsoft SQL Server’s snap-in loaded. The left pane in
SQL Server Enterprise Manager is called the console tree, and the right pane
is called the details pane.

3. In the console tree, expand Microsoft SQL Servers to display a list of the
server groups in SQL Server Enterprise Manager. By default, SQL Server
Setup creates only the SQL Server Group. You can also create your own
server groups to organize your SQL servers.

4. Right-click on the SQL Server Group and look at the shortcut menu.
You can choose New SQL Server Registration to start the Register SQL
Server Wizard. Use this option to register other SQL servers within SQL
Server Enterprise Manager.

5. Close the shortcut menu.

6. Expand the SQL Server Group to display a list of servers registered in the
group. By default, SQL Server Enterprise Manager automatically registers
your local server in this group; SQL Server Enterprise Manager logs you in
to your server by using your Windows 2000 account.

7. Look at the green arrow on your server’s icon. The green arrow indicates
that your server is currently running.

8. In the console tree, right-click on your server. From the shortcut menu,
choose Edit→SQL Server Registration Properties.

9. Look at the Registered SQL Server Properties dialog box. You can use
this dialog box to register your server with a different login account and
password, switch between Windows Authentication and SQL Server Authentication
security, move your server to a different server group, and set server
configuration options.

10. Click Cancel to close the Registered SQL Server Properties dialog box.

11. Expand your server to display the folders for configuring your server. For
example, you use the Security folder to configure your server’s login