Bruce Ng's software development blog
An archive of solutions of programming problems I have faced in my career
When reading processed historical data from OPC UA server, if you don’t set processing interval, only one value will be returned.
So if you use aggregation function Max from StartTime to EndTime, if you don’t specify the processing interval, it will return the maximum value from start time to end time.
If you specify the processing interval to 1 hour, it will return multiple max values for each hour within StartTime to EndTime.
Search for “Turn Windows features on or off” and enable features under IIS -> WWW Services -> Application Development Features.
Enable ASP.NET 3.5 or 4.8, one of the features will enable handlers.
Maybe <handlers> is for ASP.NET Http Handlers.
Refer to this link: https://social.technet.microsoft.com/Forums/windows/en-US/6e133d2c-d0b8-48b0-8b32-94d6b010a224/server-does-not-appear-under-network?forum=w7itpronetworking
“Network discovery requires that the DNS Client, Function Discovery Resource Publication, SSDP Discovery, and UPnP Device Host services are started, you may check this on both sides to make sure they are started.”
I faced this issue, turned out when using docker cp to copy files to the container, the files were owned by root user and other users didn’t have read permission. This is because the files were copied from shared folder in Windows host to the linux VM.
Because only root can read, I couldn’t restore the DB using the copied file as the server cannot read the file.
Doing a chmod to add read permission before copying into the container solves the issue.
This was a stupid one.
Use SSMS to check if the MSSQL instance is configure to allow logging in using only Windows Authentication.
Switch to both SQL Server Authentication and Windows Authentication and restart the service.