Do not ask me why, but after suffering for 24 hours of this error, I tried turning on File and Printer sharing on the WIndows Server 2019 which was hosting the SQL Server 2019 Standard. This immediately solved the issue and increased overall speed of the SQL Server.
If anyone have an explanation on this, it would be very much appreciated.