Billing Linux cPanel Windows Control Panel Client Voip ms sql webadmin ms sql backup mysql webadmin Server Status

Main Menu
  • How To Connect Microsoft SQL Server Over SSL encrypted connection?

    No comments May 1st, 2013 6425

    How To Encrypt SQL Server Connection?

    SSL encryption is enabled on all Microsoft SQL Server database servers. We recommend you to use SSL encrypted connections to connect to database servers (especially if you are connecting with database server from remote locations using SQL Server Management Studio Tool). Make sure to use the hostname provided under your database’s properties in the control panel, or in the “Services Information” area of the control panel.

    Connect SQL Server over SSL with ASP.NET/ASP Applications:

    SQL Server connection string for Classic ASP (ADO Library):

    Provider=SQLOLEDB;Data source=HOSTNAME;Initial catalog=databaseName;User Id=userName;Password=password;encrypt=true

    SQL Server connection string for ASP.NET (ADO.NET Library):


    Connect SQL Server over SSL with MS SQL Server Management Studio:

    Follow below steps to connect SQL Server Management Studio over SSL encrypted channel.

    • Open SQL Server Management Studio tool
    • Type SQL Server Name
    • Select Authentication Method to SQL Server Authentication
    • Type your database user name and your database user password
    • Click on Options button to set up advanced settings/ connection properties
    • Under Connection setting click check box to enable “Encrypt Connection”
    • Click on Connect button to connect SQL Server over SSL encrypted session.
    1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 5.00 out of 5)

No comments yet

Allowed tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Uptime 100%

MoneyBack Gurantee

Why Choose Us