SSL error message

  • Hello!
     
    I discovered following error message on our production x-64 bit SQL Server 2005 cluster:
    '
    Message

    The server was unable to load the SSL provider library needed to log in; the connection has been closed. SSL is used to encrypt either the login sequence or all communications, depending on how the administrator has configured the server. See Books Online for information on this error message:  0x2746. [CLIENT: 10.20.7.15]'

     
    Has anyone had any experience with it?
     
    Thanks,
    Igor
  • This was removed by the editor as SPAM

  • We also got the same error message in Sql 2005 64 bit server.if anyone know about this issue, please post it.


    DBA

  • This appears to be a bit a of a complex problem. I have read various posts about it, after experiencing the same thing with my 64 bit 2 node cluster. For some people, the lock pages in memory option fixes it, see:

    http://msdn2.microsoft.com/en-us/library/ms190730.aspx

    Other suggestions include making sure your SQL Service account has full permissions to all SQL registry entries.

    I am working with MS Support at the moment with mine, as the above did not help me :=(

    As soon as I find out more I will post here.

    Here is another link to an msdn forum, which would suggest it is a bug. The MS Support guys I'm talking to, do not agree, so we will see ! Good Luck !

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=676428&SiteID=1&mode=1

  • Looks like we have the problem sorted. For us it was the iLO Management Channel Interface Driver (Cpqcidrv.sys) from Hewlett-Packard. Apparently it is known to cause this issue on x64 editions of SQL Server 2005. The driver causes the SQL Server 2005 64-bit working set to be trimmed.

    We do not use ILO on our servers so I disabled it in device manager. The problem has not reared its ugly head for four days now!! Fingers Crossed !

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply