Browse FAQs

Registering a new SQL 2000 server using Enterprise Manager

Published date: 09 June 2020

Goals and Symptoms


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

Facts and Changes

SQL, server, registration, Enterprise Manager

Causes and Fixes

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.


(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
    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 ?

Can't find what you are looking for?

Reach out to our customer care team to receive information on technical support, assistance for complaints and more.