How to connect to a SQL Server 2005
This quick tutorial will show you how to connect to a SQL Server 2005. 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 can connect to a SQL Server 2005 database using
SQL Server Management Studio.
If you are using SQL Server 2005 Express Edition, which is available free from
http://msdn.microsoft.com/vstudio/express/sql/, then you can not upload your database in
this manner. Unfortunately, the Express version does not allow you to copy your database to a remote server (our server),
but it will allow you to build a database on a remote server. If you are using the Express Edition and need to copy
your database to our server, you will need to detach, copy, and send us a copy of the database files to be attached on our server. Pricing
for attaching a database can be found on /addons.aspx.
This tutorial is using SQL Server Management Studio.
Part 1:
- Open SQL Server Management Server Studio.
- Click the "Registed Servers" icon.
Part 2:
- Right-click "Database Engine", click "New", and click "Server Registration".
Part 3:
- Enter the remote server name (found on the 'SQL 2005' page in the Aquest control panel) in the text box, and change the Authentication type to "SQL Server Authentication".
- Click "Save".
- Your new server will now show in the list of Sql Servers.
Part 4:
- Right-click your server in the list, select "Connect", and click "Object Explorer".
Part 5:
- Enter your Aquest user name.
- Enter your Aquest password.
- Click "Connect".
Part 6:
- Now you have access to the remote server just as if it was a local server.
- You can click on Databases, and it will show a list of available databases.
Part 7:
Work with your database as if it were a local database.