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

To connect to your SQL 2008 database using SQL Server Management Studio, follow the steps listed below. Customers can find all their database information in the database manager page of the control panel:

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]
  • 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.

Article ID: 186, Created On: 11/13/2008, Modified: 1/26/2012