Why Spybot Search & Destroy apps detects MSSQL cookies

jana
jana used Ask the Experts™
on
When clicking "Disable these  Cookies" we get a message of 3rd cookies to select (see below).   We noticed that all are SQL.  Can some EE explain why these cookies?  Why SQL have 3rd party cookies? - please shed some light on the topic

Spybot issue
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
bbaoIT Consultant

Commented:
did you run SQL Express management via web before running the scan?

Commented:
spybot isnt as good anymore try using free online scanner nod32
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
You would have to make an exclusion for the cookies.  Old versions of Symantec Endpoint used to do this as well
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Commented:
not that i know but try it you may change your antivirus program after you yse it :)

Author

Commented:
Thank you guys, but my question is Why Spybot detects these MSSQL cookies.
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
Look under the SpyBot settings and preferences for Exclusions as I note above.

This is an older product. If the settings are not there (not available to set) then you may need to change your Anti Virus.

Author

Commented:
Understood; i just wanted to know the why, why it’s being detected.  Did some search with no results, thus went to EE.
bbaoIT Consultant

Commented:
>  my question is Why Spybot detects these MSSQL cookies.

that's why i asked below question in the first comment.

did you run SQL Express management via web before running the scan?
Robert RComputer Service Technician

Commented:
it is a fault of the product, these are called false positives. This is why it happens. To resolve it follow the procedures suggested by the experts mentioned above.
bbaoIT Consultant

Commented:
> it is a fault of the product, these are called false positives.

that's exactly what i am thinking about and what i want to investigate why. i guess the author accessed SQL Express management via web on the local computer, which might leave some cookies remaining and detected by Spybot - which will be false positive.

Author

Commented:
Did not run SQL Express management via web before running the scan (never ran via web).

Author

Commented:
Our question is more on why my SQL have 3rd party cookies detected or why listed as seen below?

sql cookies
bbaoIT Consultant

Commented:
what’s your Windows version? i will try installing SQL Express 2016 an reproducing the symptom.

Author

Commented:
Hi,

Windows 10 Pro.

My question is why?  As to my knowledge SQL use is local here we don’t use SQL access databases via the web or VPN.

My question is why do this message pops up? (Note we have run spybot  previous and after placing this question with no problems - yet this message is always present when clicking the disable cookies button.  And yes we know the short answer “they are cookies” - but why are they there?).

Hope I have transmitted the concerne we have.
Mohammed HamadaSenior IT Consultant

Commented:
I think its a very notmal warning, the App is warning you against non Windows cookies which is something to do with how it is configured.

If you set it up to accept third party cookies then it probably wont pop up again.

Its nothing to do with security really. Otherwise you will get a more serious warning.
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
>> My question is why?  As to my knowledge SQL use is local here we don’t use SQL access databases via the web or VPN

Okay, let me try to explain the need for cookies here..
When you create an Application role using sp_setapprole, then we can have an option to create a cookie for that Application role. Kindly check the parameter @fCreateCookie in the link above..
This cookie works similar to your browser cookies and helps in correctly identifying the session calling that application role.

>> i just wanted to know the why, why it’s being detected

Spybot uses its own algorithm to detect all tracking cookies in the system and report it as an issue.
It is designed by default to behave that way and hence it detected the SQL Server cookies as well which I never seen any other antivirus scans scanned(in my experience)..
https://www.safer-networking.org/cookies/
One piece of advice here, kindly exclude the SQL Server installation files, data files and backup files from antivirus scans as it might slow down server performance and to avoid these kind of False positives.

Kindly let us know for more details.

Author

Commented:
Thank you very much! Super clear!
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
Welcome, glad to clarify!!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial