How To Use SQL Server Over SSL? How To Encrypt SQL Server Connection?


Sometimes you may need to encrypt SQL Server connections between your applications and our hosted database for the better security. Please follow these steps if you want to access your SQL Server database over SSL remotely.

Step By Step Guide To Use SQL Server over SSL

1) Download and import Database Mart root certificate

  1. Download our root certificate from here.
  2. Unzip the downloaded root certificate and copy the "DBM-CA.cer" in your local hard drive.
  3. Import the root certificate to your local "Trusted Root Certification Authority". Please follow How To Import a Trusted Root Certification Authority In Windows 7/Vista/XP?

2) Connnect SQL Server over SSL with ASP.NET/ASP Applications

You only need to append "encrypt=true" in the connection string.


3) Open SQL Server Management Studio

Please run SQL Server Management Studio Tool and enter the server name, Login user name and Password

4) Check encrypt option

Click' Options>>', Then check Encrypt option and click 'Connect'

Related Resources

  1. How To Create SQL Server 2008/2005 Database In WebsitePanel Control Panel?
  2. How To Get The IP and Connection String for My Hosted SQL Server Databases?
  3. How To Access Hosted Microsoft SQL Server Database With SQL Server Management Studio Remotely?


Other Knowledgebase Articles

Free Shared Hosting

# of Domains: 1
# of SQL Server Databases: 1
Disk Space: 5GB
Bandwidth: Unmetered
SQL Server 2014
Monthly: $0.00
More Information About Free Shared SQL Hosting Plan

Free Hyper-V Server

Dedicated Memory:1GB
Disk Space: 25GB SSD
Bandwidth: Unmetered
Windows 2012 R2/2008 R2: Free
Monthly: $0.00
More Information About Free Windows Hyper-V Server

Dedicated SQL Server

CPU: Quad-Core Xeon X3440
Disk: 2x120GB SSD
Bandwidth: 100Mbps Unmetered
Windows 2012/2008: Free
Monthly: $79.00
More Information About Unlimited Dedicated SQL Server
SQL Server Hosting | ASP.NET Hosting | DotNetNuke Hosting | Windows VPS Hosting | Dedicated SQL Server Hosting | Dedicated Windows Server Hosting