Home : MSSQL :
How to connect to SQL Server 2000 using Enterprise Manager?

Category : MSSQL

To connect to your Microsoft SQL Server database using Enterprise Manager to manage your database, you will need to follow the steps listed below.

  • Open Enterprise Manager, navigate to SQL Server Group (default group).
  • Right Click on SQL Server Group, select "New SQL Server Registration".
  • Type the SQL Server Name and comma with port Number(25000) (found in your hosting control panel) in the Available Servers textbox and click Add. Hit Next.
  • Select SQL Server Authentication as Authentication Mode. Hit Next.
  • Type in the Login and password (can be found in the activation email). Hit Next.
  • Hit Next and Finish.

Created : 22 Jan 2002
Modified : 22 Jan 2002
Viewed : 2736 times.
Print Article