How to connect to SQL Server 2008 using SQL Server Management Studio

Note: To connect to an MS SQL 2008 database, you must use SQL Server 2008 Management Studio.
You cannot connect to an SQL 2008 database using an earlier version of SQL Server Management Studio.

To connect to your Microsoft SQL Server 2008 database using SQL Server Management Studio, you will need to follow the steps listed below.

Open SQL Server Management Studio, the Connect to Server Window will pop up, select/enter the following:
  1. Server Type: Database Engine
  2. Server Name: The assigned sql server name provided by your control panel
  3. Authentication: SQL Server Authentication
  4. Login: your assigned sql login
  5. Password: your assigned sql password
Click connect and you will be connected to your sql server database.

Add Feedback