SSL connection to SQL Server 2012 using SQL Server Management Studio

Before you attempt to connect, make sure you have a SQL 2012 add-on feature, if not you can order one through Control Panel.

To connect to your SQL 2012 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: Database Management > MS SQL 2012]
    * Authentication: SQL Server Authentication
    * Login: [SQL 2012 Login name]
    * Password: [SQL 2012 Password]

Click the Options button. Under connection properties, check the box that reads "Encrypt connection".

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

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