SQL Server SSL Enable...

From: George Kosina (georgekosina_at_yahoo.com)
Date: 08/19/04 

Date: Thu, 19 Aug 2004 10:04:59 -0700

These are the steps I have made to enable SSL on SQL Server. I am not
sure if it is enabled or not.

(1) Created a certificate request by using
Start->Control Settings->Administrative
Tools->Internet Services Manager.

(2) I passed this request on to Microsoft Certificate
Server located at http://ssrc.msstate.edu/certsrv/ .
The certificated generated has been stored on to the
desktop.

(3) Right-click the certificate and install.

(4) Enabled the Force Protocol Encryption in Server
Network Utility and restarted the SQL Server.

At this point I was hoping that no clients will be
able to login to SQL Server. I tried using QA from a
different computer and it was able to login without
any difficulty. Does this prove that SSL is not
enabled on the SQL Server.

Your help will be greatly appreciated.

Thanks,
GK

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • HOWTO: SQL Server SSL On A Cluster
    ... This post describes issues concerning the implementation of SSL ... certificates on SQL Server 2000 clusters. ... cluster and failover is working, ... DC is running a certificate authority, and that the CA is configured ...
    (microsoft.public.sqlserver.clustering)
  • HOWTO: SQL Server SSL On A Cluster
    ... This post describes issues concerning the implementation of SSL ... certificates on SQL Server 2000 clusters. ... cluster and failover is working, ... DC is running a certificate authority, and that the CA is configured ...
    (microsoft.public.sqlserver)
  • Re: SQL Server 2005 SP2 fails in upgrading Database service
    ... Clearing the certificate had no success. ... I suspect there's a problem with the permissions of the SQL Server service ... SQL Server Database Services 2005 ENU SP2 ... This is an informational message only; no user action is ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2005 SP2 fails in upgrading Database service
    ... Clearing the certificate had no success. ... I suspect there's a problem with the permissions of the SQL Server service ... This is an informational message only; no user action is ...
    (microsoft.public.sqlserver.setup)
  • Re: Retrieving Devices thru xp_Availablemedia in 2005 without SA role
    ... certificate, and sign the procedure with the certificate. ... and grant that login VIEW SERVER STATE (which I ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)