Registering a SQL Server

Registering a remote SQL Server in Enterprise Manager is easy, once you know the method. Before you start, you must have Enterprise Manager installed on the client machine, and you must know the port number for the instance of SQL Server to which you will connect. For MIS431W04 on Reliant, the port number is 3448.

Click on the name of the SQL Server Group in the left panel.
 

 
In the right panel, right click and choose New SQL Server Registration from the object menu that appears. If the Register SQL Server Wizard starts, check the box that says "From now on, I want to perform this task without using a wizard." and click Next >. Complete the Registered SQL Server Properties dialog box as shown below, using your Login Name and Password. 3448 is the number of the port on which the MIS431W04 instance of SQL Server is running – the server administrator has to provide this number to you.
 

 
If successful, the server will now appear in the list on the left and the window on the right.
 

 
Depending on how you log on to your system, this registration may be permanent, or you may have to do it every time you start Enterprise Manager.

This is a living document that is subject to revision during the course of the class. The most recent versions of course materials can be found at http://www.cbe.wwu.edu/misclasses/mis431W04/. Last revised Tuesday, January 13, 2004; at 12:58:28 PM.