How do I register a SQL Server with SQL Enterprise Manager?

A. A. Before you can control a SQL Server with the Enterprise Manager you first need to register it. If you are running for the first time perform the following:

  1. Make sure the SQL Server service has been started (Start - Settings - Control Panel - Services - MSSQLServer - Start)
  2. Start the SQL Enterprise Manager (Start - Programs - Microsoft SQL Server 6.5 - SQL Enterprise Manager)
  3. Enter the computers name in the Server box (check using Network control panel applet, or right click on Network Neighbourhood and select Properties).
  4. In the Login ID box enter sa which is the default SQL Administrator, leave password blank.
  5. Click Register
  6. Click Close

Click here to view image
- Registering an SQL Server

The SQL Server will now be visible from the main control window.

If you have used SQL Enterprise Manager before and want to add a new server just right click on SQL 6.5 in Enterprise Manager and select "Register Server" from the context menu.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.