SSL connection to SQL Server using SQL Server Management Studio

To connect to your SQL database using SQL Server Management Studio:
 

Note:  You will need to download and install SQL Server Management Studio 2016 to connect to a SQL 2016 database.

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 the Control Panel Site Info Manager/MS SQL Manager]
    * Authentication: SQL Server Authentication
    * Login: [SQL DB Login name]
    * Password: [SQL DB Password]

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

Click connect.

 

In addition to backing up your site files, our SiteBackup service can also back up your databases. Now you can control backup retention and schedule. Automate your backups with SiteBackup.