Hello everybody,
First of all, sorry for my English - not native - it may includes mistakes.
If this topic is not in the right forum, please tell me (I couldn't find a better place?).
At work, I am using Avast Business Antivirus Pro (actual version: 19.7.2573 (build: 19.7.4674.542)).
I am also using Microsoft SQL Server Management Studio 18 (on Windows 10 64b) to connect on a local instance (let's say PCserialnumber\instancename) It worked from May to the beginning of November - could connect to my databases etc.
Recently, I couldn't connect to the instance, getting the error #258 (Server can't be found or not accessible).
When I disable Avast (all shields), it works fine. When I enable back all shields, it stops working. It also works when I disable the Avast firewall only.
I have this issue also for Network Sharing Center to access my own shared files (PCserialnumber\sharedfileblabla).
I have checked a lot of topics about MSSQL before finding out it was Avast having trouble… ticking some boxes, removing others… but instead of breaking Avast, I prefer to ask you for this specific request - and it can then later help other people who could encounter this issue.
Thank you, hope you can help me asap.
Best regards.