Browse Search  
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.
 
 
This article has been viewed 973 times.



ASPWebHosting.com.au Copyright © 2004-2005 | All Rights Reserved |

All trademarks are property of their legal owners.