Server and Client Installation

Hello, what is the ideal setup for a server and client installation?

I have a Windows 2019 Server with SQL Server, currently running python for scheduled automated scripts.

And I have users locally running python (using different IDEs), however they are working from home on a VPN and significantly slower.

Is there a good client side IDE that can use a server side python installation, preferably free, at least whilst I’m testing usability. I would also preferably like only admin to control what python packages are installed on the server.

I am not sure what role the IDE plays with respect to setting up a server? Any IDE will do, including a simple editor.

When you are looking for an excellent IDE, I suggest Platformio.