SSL Security Error in WinXP SP2

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Shailesh Humbad (humbads1_at_hotmail.com)
Date: 08/28/04

  • Next message: Shailesh Humbad: "Re: SSL Security Error in WinXP SP2" 
    Date: Fri, 27 Aug 2004 23:42:28 -0400

    I am running SQL Server 2000 Developer (with Service Pack 3a) on
    Windows XP Professional. After installing Windows XP Service Pack 2,
    I can no longer connect to SQL Server. From Enterprise Manager, the
    error shows up in a dialog when I click on the
    "Machinename\Machinename (Windows NT)" node:

    SQL Server Enterprise Manager
    A connection could not be established to MACHINENAME\MACHINENAME
    Reason: SSL Security Error
    ConnectionOpen (SECDoClientHandshake())..
    Please verify SQL Server is running and check your SQL Server
    registration properties (by right-clicking on the
    MACHINENAME\MACHINENAME node) and try again.

     From the command line, the error is:

    C:\>osql -E -S machinename\machinename
    [DBMSLPCN]SSL Security error
    [DBMSLPCN]ConnectionOpen (SECDoClientHandshake()).

    This instance is configured as a named instance, with mixed-mode
    authentication. I can't connect with either authentication modes. In
    Windows Firewall, I tried both adding an exception for port 1433 and
    turning it off, but the problem still exists. I can stop/start the
    SQL server instance, but I can't connect to it.

    I noticed in another thread comments about uninstalling certificate
    services, but WinXP does not have certificate services or even DNS.
    On this computer, I am running IIS 5.1. Also, I have used the
    selfssl.exe utility (from IIS 6 administrators kit) to automatically
    install a self-signed certificate. Maybe this has interacted somehow
    with XP Service Pack 2.

    I also tried making a UDL file with the OLE DB Provider for SQL
    Server, making sure the "Use Encryption for Data" setting is set to
    false, but the same error occurred.

  • Next message: Shailesh Humbad: "Re: SSL Security Error in WinXP SP2"

    Relevant Pages

    • Re: Recent MSFT KBs on XP SP2 Incompatibility and Others
      ... I wish I could accurately distinguish what are SP2 problems (particularly ... > Some Programs Seem to Stop Working After You Install Windows XP Service ... > Troubleshooting Windows Firewall Settings in Windows XP Service Pack 2 ... > you install SQL Server 2000 or MSDE 2000 on a computer that is running ...
      (microsoft.public.windowsxp.general)
    • Re: Recent MSFT KBs on XP SP2 Incompatibility and Others
      ... I wish I could accurately distinguish what are SP2 problems (particularly ... > Some Programs Seem to Stop Working After You Install Windows XP Service ... > Troubleshooting Windows Firewall Settings in Windows XP Service Pack 2 ... > you install SQL Server 2000 or MSDE 2000 on a computer that is running ...
      (microsoft.public.windowsxp.customize)
    • Re: Recent MSFT KBs on XP SP2 Incompatibility and Others
      ... I wish I could accurately distinguish what are SP2 problems (particularly ... > Some Programs Seem to Stop Working After You Install Windows XP Service ... > Troubleshooting Windows Firewall Settings in Windows XP Service Pack 2 ... > you install SQL Server 2000 or MSDE 2000 on a computer that is running ...
      (microsoft.public.windowsxp.basics)
    • Re: Recent MSFT KBs on XP SP2 Incompatibility and Others
      ... I wish I could accurately distinguish what are SP2 problems (particularly ... > Some Programs Seem to Stop Working After You Install Windows XP Service ... > Troubleshooting Windows Firewall Settings in Windows XP Service Pack 2 ... > you install SQL Server 2000 or MSDE 2000 on a computer that is running ...
      (microsoft.public.windowsxp.newusers)
    • Re: Recent MSFT KBs on XP SP2 Incompatibility and Others
      ... >>Programs That May Behave Differently in Windows XP ... > Windows XP Service Pack ... >>versions on computers that are running Windows XP SP2, ... >>latest SQL Server 2000 service pack or the latest MSDE ...
      (microsoft.public.windowsxp.general)