Post reply

SQL Error when accessing databases

  • October 22, 2005 at 2:00 am

    #166013

    Hello, Can someone please help me?

    we had a problem last night with a certificate for the website we run, and had it reissued, now when we access the database components on the webpage, we get an error "Database Results Wizard Error The operation failed.  If this continues, please contact your server administrator." I must admit, I am sick of asking myself "The problems persisting, whats causing it and why havent you fixed it yet"

    If I try and access the Enterprise Manager I get "Unable to connect to server. Reason: SSL security error. ConnectionOpen (SECDoClientHandShake())... "

     

    I have tried removeing and readding the certificates, and have changed the account that SQL Runs under, the issue remains, does anyone have any ideas on how to fix it?

     

    Thanks!!!

  • October 22, 2005 at 8:43 am

    #599355

    If you run a google search versus microsoft.com, you will find 2 fixes for the problem.

    Product: MDAC 2.7

    Solution: Apply SP1

    URL: htp://support.microsoft.com/kb/322144/EN-US/

    Product: SQL Server 2000

    Solution: Apply SP1

    URL: http://support.microsoft.com/kb/302409/EN-US/

    SQL = Scarcely Qualifies as a Language

  • October 22, 2005 at 9:52 am

    #599366

    I have already tried those, thanks anyway.

  • October 22, 2005 at 12:15 pm

    #599370

    Did you apply the MDAC Service Pack to the web servers ?

    SQL = Scarcely Qualifies as a Language

  • October 22, 2005 at 12:30 pm

    #599372

    i applied SP4 if thats what you mean, managed to fix just there, I uninstalled, cleared all certs and reinstalled and restored a backup of the main database, and everything is ok, well sortof, I now cant get SSL working even with the certs restored oh well, one step at a time.

     

    Thanks for the help though.

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

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