Coupon code copied
Server Intellect
(855) 850-HOST

Toll Free 24/7/365        (4678)

Get help from a Microsoft Certified Engineer.

Intellect Connect

Technical problem with your Windows Hosting?

Let our Microsoft Certified experts handle the problem for you.

Connect to SQL Server with Enterprise Manager

Step 1

You can obtain SQL Server 2000 Enterprise Manager through Microsoft at the following URL:
Microsoft Download Center

You are able to download and use the ‘Client Tools’ free of charge with the SQL Server 2000 Evaluation Software.

kb-sql-with-enterprise-1

Step 2

When you first open SQL Server 2000 Enterprise Manager you will be shown a Microsoft Management Console like the one above.

kb-sql-with-enterprise-2

Step 3

You will need to Right-Click on the SQL Server Group node and choose New SQL Server Registration.

kb-sql-with-enterprise-3

Step 4

You will then then start the Register SQL Server Wizard. You will be presented with a Starting Screen.

Click Next to get to the above Panel.

You will then put the SQL Server IP Address in the Available Servers.

You will then need to click Add to add the SQL Server to the right panel window.

You can now click Next.

kb-sql-with-enterprise-4

Step 5

You will need to choose Connect Using SQL Authentication and then click Next.

kb-sql-with-enterprise-5

Step 6

You can then record your username and password so SQL Server Enterprise Manager does not ask you for a username/password every time you connect.

kb-sql-with-enterprise-6

Step 7

When you click Next SQL Server Enterprise Manager will try to connect to the SQL Server.

Please make sure you have no firewall running that may prevent SQL Server Enterprise Manager from accessing the internet.

kb-sql-with-enterprise-7

Step 8

If SQL Server Enterprise Manager was able to find and log in to the SQL Server successfully you will be presented with the above message.

kb-sql-with-enterprise-8

You can now expand the new server node on the left side on the Microsoft Management Console.

Simply expand the new SQL Server Registration node until you find your new database.

You can now manage your new SQL Sever Database using SQL Server Enterprise Manager.

Interested in letting our experts solve your IT problems for you?
Get a free, no-obligations consultation with one of our experts today!

Call us at (855) 850-HOST

Contact

Start Your Order

X

This form does not accept free e-mail accounts. Please enter a business e-mail to submit it.

Submit Form Cancel

Please wait...

Submitting your info. This may take less than a minute.