DiscountASP.NET Support Portal
Language
 
Home>Knowledge Base>Databases>MS SQL 2000>How to connect to SQL Server 2000 using Enterprise Manager
Information
Article ID206
Created On11/14/2008
Modified8/5/2009
How to connect to SQL Server 2000 using Enterprise Manager
To connect to your Microsoft SQL Server database using Enterprise Manager to manage your database, simply follow the steps listed below.
  1. Open Enterprise Manager, navigate to SQL Server Group (default group)
  2. Right Click on SQL Server Group, select "New SQL Server Registration"
  3. Type the SQL Server Name (found in your Control Panel) in the "Available Servers" text box and click "Add." Click "Next"
  4. Select SQL Server Authentication as "Authentication Mode." Click "Next"
  5. Type in the Login and password (can be found in your database activation email). Click "Next"
  6. Click "Next" and "Finish"