The issue has been fixed. In the end the fault was in the network, the connection between a TP LINK router and a CISCO one. Apparently these 2 are not...

I was discussing again with our network technician and he discovered that there is a compatibility issue between the routers that link our current location to the server location (TP...

The RDP works fine. On the server itself there are no issues. All SQL instances can be accessed ok.

As for the resource allocation the main machine has dynamic allocation and...

The physical machine does hold indeed multiple VMs.

I have tried with a DAC connection and it behaves like the CMD connection: specific select works like "select column1,column, etc from...