How to connect to SQL Server 2005 using SQL Server Management Studio?

[John_Accuwebhosting]

This article is meant to provide the steps to connect Microsoft SQL Server 2005 database residing on the server of your hosting provider. First of all make sure that you have created MS SQL 2005 database & user from your hosting control panel. Once you are done with this, you will have to install & configure SQL server management studio on your local machine.

You will be able to connect database using SQL Server Management Studio. You will need to follow below steps

1. Open SQL Server Management Studio.
2. Connect to Server Window will pop up.
3. It will ask you to Select/Enter the following:

* Server Type: Database Engine
* Server Name: [The SQL server name OR IP address of SQL server]
* Authentication: SQL Server Authentication
* Login: [SQL 2005 Login username]
* Password: [SQL 2005 User Password]

4. Click connect button and you should be able to connect to the SQL 2005 server database residing on your hosting server

[Heblye]

Re: How to connect to SQL Server 2005 using SQL Server Management Studio?

if you do not know how to, you also can ask a question to get you answer, i think you will learn more if you can ask. the forum is so good, i will come back the second time, third time, even usually.