Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 4 replies
  • Subscribers 1 subscriber
  • Views 9269 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How do I get Sophos out of my SQL Server

danparker276

What's the best way to remove Sophos from running stuff on my SQL Server without removing the whole thing?  I have no clue why people want it running on SQL server anyway and it's causing SQL Server to give me out of memory errors.

Here's a microsoft article describing the error or why I'm getting SQL server crashes.

http://support.microsoft.com/kb/2033238

I've also seen a few other articles about Sophos causing problems in SQL Server that are very hard to reproduce.

I want Sophos out of my database, I've been dealing with crashes for over a year now.  After rebuilding servers from scratch and testing everything, I'm pretty sure Sophos is to blame.  I'm not a sys admin, so I don't care for any explaintions, I just don't want it on there period.  I was shocked to find that SQL server have anti-virus stuff even running on it.  

We are talking with Microsoft top level support now, and they are asking us to completly remove Sophos, but the system admin at our client site probably won't allow this.  So I think removing it from SQL server would probably do the trick.

I've unchecked the buffer overflow, which I thought might do it,  but it's still sofos stuff running when I query:

select file_version,product_version,company,[description] from sys.dm_os_loaded_modules 

where company not like 'Microsoft%'

:36513


This thread was automatically locked due to age.
  • 0
    Hi.
    Sounds like you want to disable detours
    /search?q= 10551
    Regards,
    Jak
    :36515
  • 0

    Hi,

    first of all you should update the Sophos installation in the SQL Servers.

    We have several SQL Server clusters and standalone SQL Servers with the latest Sophos on it. Versions of SQL Server is from 2005 - 2008 R2

    No problems at all. No crashes, no memory errors.

    Regards

    :36573
  • 0

    I followed the instructions for the above message and the Sophos Buffer Overrun Protection is gone, but the Sophos Web Intelligence is still there.  I want that gone.  Is there a method similar to the one above?  Otherwise I'll have to remove the whole product from the server.

    As for no crashes, no memory errors... our client runs a lot of OLEDB connections with a lot of client side triggers on an outdated software platform.  I doubt you have a test case that would simulate our environment.  And our database server is for an internal network only.  We have no need for sophos running anything in SQL Server.  We have re-imaged and re-built this machine many times and it will get a memory error a few times a month.  This is have going on for a year and a half.  Many people and consultants have looked at it and many hours have been wasted trying to debug this.  Even Microsoft is suggesting that we remove Sophos from the server.  I can't say 100%, but I'd bet money that this is the issue.   I do have the latest version and if SOPHOS_DETOURED.DLL is known to cause problems in the past, why in earth would I want it on my database even if you say it's updated.

    :36827
  • 0

    I guess if there's no way to remove the other one, I'll have to tell my client to remove sophos and get another product.

    :37075