I have following architecture for sharepoint and I wanted to know best permission set up. Currently we have fresh install of SharePoint Foundation server with the services running as shown in the image below.
We are moving the database engine to a dedicated SQL server because its running standard edition. However the dedicated SQL server doesn't have enough hard disk space. So we plan to use existing network drive which is coming from a file server.
Consider we have created folder on the network drive called "Sharepoint Database" where all the .mdf,.ndf and .ldf files will be copied. The SQL database of sharepoint will now be hosted by the SQL server shown in the middle with files on the network drive.
Under what account now I need to run the services on the Sharepoint box? Which of the accounts need to be a domain account ? My main concern is which service will actually try to read/write to database on the network drive?