Announcement

Collapse
No announcement yet.

SQL Server Help

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL Server Help

    Hope this is the right forum, We had a problem with a certificate last night and got a reissued one, however now all Database driven components are returning "Database Results Wizard Error The operation failed. If this continues, please contact your server administrator." and the SQL manager is saying "Unable to connect to server. Reason: SSL security error. ConnectionOpen (SECDoClientHandShake())... " the only guide I have found is for an issue during Install, not in general usage.


    has anyone got any ideas on what we can try?

    thanks!!!

    UPDATE: I managed to fix it, thanks anyway, I removed all Certs, Uninstalled, and reinstalled then reattached the certs, only "bug" is now SSL wont work, even if I generate a new Cert I get Cannot Find Server
    Last edited by SAS; 22nd October 2005, 19:21. Reason: resolved issue

  • #2
    Re: SQL Server Help

    Hi,
    this is what i got for you from SQL BOOKS on line.

    Net-Library Encryption
    New Information - SQL Server 2000 SP3.

    Microsoft® SQL Server™ 2000 can use the Secure Sockets Layer (SSL) to encrypt all data transmitted between an application computer and a SQL Server instance on a database computer. The SSL encryption is performed within the Super Socket Net-Library (Dbnetlib.dll and Ssnetlib.dll) and applies to all inter-computer protocols supported by SQL Server 2000. When SSL encryption is active, the Super Socket Net-Library performs the SSL encryption before calling:

    The Windows Socket 2 API to transmit TCP/IP Sockets or NWLink IPX/SPX packets.


    The Net-Library router to send a packet to the Named Pipe, Multiprotocol, AppleTalk, or Banyan VINES Net-Libraries.
    SSL encryption works only with instances of SQL Server 2000 running on a computer that has been assigned a certificate from a public certification authority. The computer on which the application is running must also have a root CA certificate from the same authority.

    The Net-Library encryption is implemented using the Secure Sockets Layer API. The level of encryption, 40-bit or 128-bit, depends on the version of the Microsoft Windows® operating system that is running on the application and database computers.

    Enabling SSL encryption increases the security of data exchanged across networks between instances of SQL Server and applications. Data sent across the network is encrypted so that the clear text cannot be read by unauthorized people using tools such as network sniffers. Enabling encryption does, however, slightly slow the performance of the Net-Libraries. Encryption forces these actions in addition to all of the work for an unencrypted connection:

    An extra network round trip is required at connect time.


    All packets sent from the application to the instance of SQL Server must be encrypted by the client Net-Library and decrypted by the server Net-Library.


    All packets sent from the SQL Server instance to the application must be encrypted by the server Net-Library and decrypted by the client Net-Library.
    Shared memory Net-Library communications are inherently secure without the need for encryption. The shared memory Net-Library never participates in inter-computer communications. The area of memory shared between the application process and the database engine process cannot be accessed from any other Windows process.

    For compatibility with earlier versions of SQL Server, the Multiprotocol Net-Library continues to support its own encryption. This encryption is specified independently of the SSL encryption and is implemented by calling the Windows RPC encryption API. It does not require the use of certificates. The level of RPC encryption, 40-bit or 128-bit, depends on the version of the Windows operating system that is running on the application and database computers. The Multiprotocol Net-Library is not supported by named instances.

    Comment


    • #3
      Re: SQL Server Help

      thanks might take me awhile to understand it :P, atleast the server is (mostly) up and running again

      Comment


      • #4
        Re: SQL Server Help

        Hi,
        is it resolved !


        Regards

        Comment


        • #5
          Re: SQL Server Help

          Hi,
          is it resolved !


          Regards

          Comment


          • #6
            Re: SQL Server Help

            yes thanks!

            Comment

            Working...
            X