• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Chapter 23. Administering Databases with... > Running SQL Server Enterprise Manage...

Running SQL Server Enterprise Manager for the First Time

When you launch EntMan on a computer running MSDE, registration of the local server is automatic. You must manually register the remote servers that you want to manage. To connect to a remote SQL Server instance, do the following:

  1. Choose Start, Programs, Microsoft SQL Server, Enterprise Manager to open the MMC snap-in.

  2. Expand the Microsoft SQL Servers and SQL Server Group node, which usually opens with a (No Items) entry.

  3. Right-click the SQL Server Group node, and choose New SQL Server Registration to start the Register SQL Server Wizard. Click Next to bypass the Welcome dialog.

  4. In the Select a SQL Server dialog, select the server(s) that you want to manage in the Available Servers list, and click Add to move them to the Added Servers list (see Figure 23.4). Click Next.

    Figure 23.4. Managing remote SQL Server instances requires registering each server in Enterprise Manager. This example illustrates adding under Windows 98SE an instance of SQL Server Enterprise Edition (OAKMONT-DC1) and MSDE (OAKMONT-MS7) running under Windows 2000 Server.

  5. In the Select an Authentication Mode dialog, select the Windows Account Information option for integrated Windows security if you're connecting to SQL Server running under Windows NT/2000+ server. You must be logged on to the network with an account having membership in the server's local Administrators group to use integrated Windows security. Otherwise, select the SQL Server Login Information option to use SQL Server security.

  6. If you selected SQL Server Login in the preceding dialog, the Select Connection Option dialog opens. If you're not concerned about server security, accept the default Login Automatically option, type sa as the Login Name, and leave Password empty for the default installation of MSDE. Otherwise, select the Prompt for the SQL Server Account Information option (see Figure 23.5). Click Next.

    Figure 23.5. MSDE running under Windows 98/Me+ requires use of SQL Server security; integrated Windows security isn't an option. Selecting the automatic login option grants anyone with access to your computer full system administrator (sa) privileges for the SQL Server instance.

  7. In the Select SQL Server Group dialog, accept the default Add the SQL Server(s) to an Existing SQL Server Group option and the existing SQL server group. Alternatively, you can create a new group with a name of your choice. Click Next and Finish to add the servers.

  8. The Register SQL Server Messages dialog reports success or failure of registration attempts (see Figure 23.6). For example, if your Windows NT/2000+ logon account doesn't have administrator permissions for SQL Server, an error message appears in the list. Click Close to return to Enterprise Manager.

    Figure 23.6. The Register SQL Server Messages dialog reports “Registered successfully” unless the servers aren't running or you don't have permissions to manage them.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint