Technical FAQs

Ask a Question

Registering a new SQL 2000 server using Enterprise Manager

Goals and Symptoms

Summary


  • This article is a step-by-step description of how to register a new SQL server using Enterprise Manager.

Facts and Changes

Keywords
SQL, server, registration, Enterprise Manager

Causes and Fixes

Resolution
1) Open Enterprise Manager

2) Expand Microsoft SQL Server > SQL Server Group

3) Right-click on SQL Server Group. Choose New SQL Server Registration…

4) The Register SQL Server Wizard shows up. Click Next.

5) Under Available Servers, scroll down the list for the new server to connect to.

6) Write the new server name and append "\ION" or "\SMS3000" to the server name. For example, if the server name is JANE12345, write JANE12345\ION under Available servers. This will create an ION or SMS instance of SQL 2000 on this new server

7) Click Add. The new SQL Server name should appear under Added Servers.

Click Next.

8) In Select an Authentication Mode, choose the SQL Server Authentication option (second option).

9) In Select Connection Option, choose to log in automatically using the SQL Server account information (first option). The default login name is sa and the default password is "ION!Everywhere" for ION and "DBMaster".

10) Add the SQL server to an existing SQL Server group.

11) Click Finish to complete the registration.

Attachments

(Removed Image URL: /PubResEXPORT.nsf/2b87ee90be777fc085257c28006ee4ef/6fb52261ad962709c125743b00108e76/fl_block_5/0.1AD6?OpenElement&FieldElemFormat=gif)

  • Original article# 12752
    Date Created: October 30, 2006
    Last Revised: April 29, 2008
    Public
    Original Author: VB
    All content © 1992-2008 Schneider Electric

Legacy KB System (APS) Data: RESL184717 V2.0, Originally authored by DaMi on 06/17/2007, Last Edited by PhHa on 04/30/2008
Related ranges: OS & related Third Party PRODUCTS for Power Mangement Systems, Database for PowerLogic Software
Was this helpful?
What can we do to improve the information ?