How to connect to a SQL Server 2000
This quick tutorial will show you how to connect to a SQL Server 2000. To get
started, you will need to know:
- The server name
- your user name
- your password
If you are an Aquest Hosting customer, then this information is provided to you
when you add a SQL database to your account.
Requirements:
You will connect using SQL Enterprise Manager. If you have installed SQL Server or MSDE on your
computer then you have SQL Enterprise Manager. If you don't have SQL Server or MSDE
installed you will need to install
one of them before you can proceed. MSDE is available for free
from Microsoft. Search for "MSDE download" on
http://www.msn.com, download it, and install it.
Part 1:
- Open SQL Enterprise Manager
- Right-click a Server Group, and select "New SQL Server Registration...".
Part 2:
- Click Next.
Part 3:
- If the server you are want to connect to is not in the list, enter the server name
in the text box.
- Click the "Add" button to move the server name to "Added Servers".
Part 4:
- Click Next.
Part 5:
- Select the Authentication type to use. Aquest Hosting customers will use SQL Authentication
to connect to your SQL Server database.
- Click Next
Part 6:
- Enter your user name.
- Enter your password.
- Click Next.
Part 7:
- Now you can assign this connection to an existing Server Group, or create a new Server Group.
- After selecting the Server Group, or adding a new one, click Next.
Part 8:
- Click 'Finish', and wait as your computer tries to connect to the server.
Part 9:
- If you did everything correctly, and the server is available, you will get the message
"Registered successfully".
- Close the message window.
Part 10:
- Now you will see the new server listed in your list of available servers. You
will be able to work with your database just like you work with the databases that
are local to your machine.
- If you are on a shared server, you will see other peoples databases, but you will not
have access to view or modify them.
- Find your database in the list of databases and work with it as you would work with any
database on your computer.