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

Language

Home>Knowledge Base>Databases>MS SQL 2008>How to connect to SQL Server 2008 using SQL Server Management Studio

Information

Article ID	186
Created On	11/13/2008
Modified	9/8/2009

Actions

Print this Page

Add Favorite

Share With Others

	del.icio.us
	Digg
	FaceBook
	Reddit
	YahooMyWeb

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

Note: To connect to an MS SQL 2008 database you must use the 2008 version of SQL Server Management Studio. You cannot connect to an SQL 2008 database using the 2005 (or earlier) version of SQL Server Management Studio.

To connect to your SQL 2008 database using SQL Server Management Studio, follow the steps listed below:

Open SQL Server Management Studio, the "Connect to Server" window will open. Select/enter the following:

Server Type: Database Engine
Server Name: [The SQL server name found in Control Panel]
Authentication: SQL Server Authentication
Login: [SQL 2008 Login name]
Password: [SQL 2008 Password]

Click "connect" and you will be connected to the SQL 2008 server.