HACKER SAFE certified sites prevent over 99.9% of hacker crime.
Microsoft Certified Partner.
Microsoft ASP.Net Hosting Advantage Member.
Community Server Certified Host

How to connect to a SQL Server 2005

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:

  1. The server name
  2. your user name
  3. 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:

  1. Open SQL Server Management Server Studio.
  2. Click the "Registed Servers" icon.

Part 2:

  1. Right-click "Database Engine", click "New", and click "Server Registration".

Part 3:

  1. 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".
  2. Click "Save".
  3. Your new server will now show in the list of Sql Servers.

Part 4:

  1. Right-click your server in the list, select "Connect", and click "Object Explorer".

Part 5:

  1. Enter your Aquest user name.
  2. Enter your Aquest password.
  3. Click "Connect".

Part 6:

  1. Now you have access to the remote server just as if it was a local server.
  2. 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.

Is your domain available?
http://www.


Money back guarantee.
ASP.Net web hosting.
ASP.Net 2.0 web hosting.
ASP.Net 3.5 web hosting.
AJAX Installed.
Silverlight Hosting.
SQL Server 2005 hosting.
DotNetNuke web hosting, free installation.
Tandem Server web hosting, free installation.

If you need a tennis partner, then you go to TennisPulse.org, and when TennisPulse.org needs a web host, they come to Aquest Hosting.

www.TennisPulse.org
Community Server 2007 hosting with free installation.
Windows 2003 Server web servers.
Powered by ASP.Net 2.0.
Copyright © Aquest Hosting 2003 - 2007