My office uses accountant programs which run on SQL Server 2008 R2. The SQL Server engine must be installed on one of the laptops (called "server") and the other laptops (called "clients") connect to it via local network. Database files are stored in the same place as the SQL Server engine, so on the "server" laptop. From the security point of view, this is the most ridiculous solution anyone could have so I'm trying to change that.
Is it possible to MOVE only the database files (.mdf) to the NAS which we own, so the SQL Server engine will still run on the "server" laptop but the database will be stored on secured NAS in other place?
Unfortunately it's impossible to install SQL Server on the NAS because it's Synology so it doesn't have MS compatibility (it does have MySQL though).