How do I register a SQL Server with SQL Enterprise Manager?
March 4, 1999
A. A. Before you can control a SQL Server with the Enterprise Manageryou first need to register it. If you are running for the first time performthe following:
Make sure the SQL Server service has been started (Start - Settings -Control Panel - Services - MSSQLServer - Start)
Start the SQL Enterprise Manager (Start - Programs - Microsoft SQL Server6.5 - SQL Enterprise Manager)
Enter the computers name in the Server box (check using Network controlpanel applet, or right click on Network Neighbourhood and select Properties).
In the Login ID box enter sa which is the default SQL Administrator, leavepassword blank.
Click Register
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 serverjust right click on SQL 6.5 in Enterprise Manager and select "RegisterServer" from the context menu.
About the Author
You May Also Like