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

To connect to your SQL 2012 database using SQL Server Management Studio, follow the steps listed below. You can find all of your database information in the database manager page of 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 2012 Login name]
  • Password: [SQL 2012 Password]
Click "connect" and you will be connected to the SQL 2012 server.

Article ID: 1021, Created On: 3/19/2012, Modified: 4/2/2012