SQL Server SSL Problem


  • Hi All,


    I'm facing the following Error when i try logging into the MS Project URL (IIS6.0):


    Project was unable to log you on at this time because the Project Server database cannot be accessed. Please try again later or check with your Project Server administrator. (5001)


    While trying to log into the SQL Server 2005, i faced the following error:


    Unable to connect to server XXXXXXXX

    Server: Msg 18, Level 6, State 1
    [Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security Error


    Error on SQL Server Enterprise manager:

    A connection could not be established to (LOCAL)

    Reason: SSL Security error
    ConnectionOpen (SECDoClientHandshake())..

    Please verify SQL Server is running and check your SQL Server registration properties(by right-clicking on the (LOCAL) node) and try again.


    When i checked ran the SSL Diagnostics, it gave me the following error:


    Verifying server certificate, it might take a while...
    #WARNING:Error 0x800b0109 : A certificate chain processed, but terminated in a root certificate which is not trusted by the trust provider


    I have checked the Certificate, which is self generated, and it's valid from 3rd November 2008 to 2nd May 2009 (180 Days). Could anyone help me identify what the problem might be?


    Any help would be appreciated



    Tuesday, November 4, 2008 6:24 AM

All replies