none
Not able to connect to SQL server : SSL Security error RRS feed

  • Question

  • When I am trying to test SQL connection from WebFOCUS Windows server ( under segment network) with SQL server 2008. I got the following error :

    Connection Failed:

    SQL State: '01000'

    SQL server Error: 772

    [Microsoft][ODBC SQL Server Driver][DBNETLIB][ConnectionOpen (SECDoClientHandshake())

    Connection Failed:

    SQL state: '08001'

    SQL Server Error :18

    [Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL security error

    Tuesday, July 31, 2012 6:05 PM

Answers

  • Hi Neha,

    Could you ping the SQL Server successfully? Clients that have the Force Protocol Encryption option set ON on the client may fail to connect to SQL Server if clients specify an IP address for the server name.

    Please try:

    Use the server name to connect to SQL Server. You can use the SQL Server Client Network Utility to set up an alias for the server that is running SQL Server or implement name resolution by using WINS, DNS, or LMHOST file so that you can connect by server name.

    Or Set the Force Protocol Encryption option to ON on the server by using the SQL Server Server Network Utility. If you turn on encryption on the server, all the clients must connect by using encryption and you must install a certificate on the server. For more information, refer to the "Net-Library Encryption" topic in SQL Server 2000 Books Online.

    For more information please see: http://support.microsoft.com/kb/316779


    Best Regards,
    Iric
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Thursday, August 2, 2012 8:03 AM
    Moderator

All replies

  • Hi Neha,

    Did you try the suggested solution here? - http://blogs.technet.com/b/taraj/archive/2009/01/07/sql-server-the-best-database-server-to-work-on.aspx


    Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com

    Tuesday, July 31, 2012 7:31 PM
  • Yes. I have tried it. But still getting the same error.

    Neha Chauhan

    Tuesday, July 31, 2012 8:11 PM
  • Hello,

    As i am not a specialist of the "SSL Security error" ( all i know that it is often related with a certificate problem ) , i prefer to provide you a generic link :

    http://blogs.msdn.com/search/searchresults.aspx?q=%22SSL+Security+error%22+&sort=date+desc&PageIndex=1

    Don' hesitate to post again for more help or explanations

    Have a nice day


    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

    Wednesday, August 1, 2012 6:06 PM
    Moderator
  • Hi Neha,

    Could you ping the SQL Server successfully? Clients that have the Force Protocol Encryption option set ON on the client may fail to connect to SQL Server if clients specify an IP address for the server name.

    Please try:

    Use the server name to connect to SQL Server. You can use the SQL Server Client Network Utility to set up an alias for the server that is running SQL Server or implement name resolution by using WINS, DNS, or LMHOST file so that you can connect by server name.

    Or Set the Force Protocol Encryption option to ON on the server by using the SQL Server Server Network Utility. If you turn on encryption on the server, all the clients must connect by using encryption and you must install a certificate on the server. For more information, refer to the "Net-Library Encryption" topic in SQL Server 2000 Books Online.

    For more information please see: http://support.microsoft.com/kb/316779


    Best Regards,
    Iric
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Thursday, August 2, 2012 8:03 AM
    Moderator