Connection Failure

  • keanyukas

    SSC Eights!

    Points: 914

    Users are getting an error when using an app to connect to the database. I have tried to research it but I find nothing. Wonder if anyone has seen this?
    unexpected error: connection failure context: transaction rollback source Microsoft OLE DB Provider for SQL Server

  • Rick-153145

    SSCrazy

    Points: 2683

    Would need more information, by the sounds of it, the user is connecting, but then getting an error while something is running and the process they are running is rolling back. Put a profile trace on and see what is being called.

  • keanyukas

    SSC Eights!

    Points: 914

    I think I may have found the issue. I was also getting an error message that the transaction log could not be found. Upon snooping around the database I saw that auto close was set to TRUE. I have made it FALSE hoping this will clear up these unusual messages

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

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