Hope someone on here can help...
Our C: drive on one of our servers is getting a bit full so we decided to try to relocate the SQL databases to another drive on the same machine. SQL 2016 - Windows Server 2016. Note that this is a virtual server running under Hyper-V.
We followed the instructions to Detach the database, then copy the files to the desired location and then re-attach the database.
This all seemed to work except the database was set to 'Read Only'.
When trying to set read only to False in the options we got an error saying that there were insufficient permissions and the state could not be changed.
Reading a million posts about this everyone suggests that we need to add full permissions to NT Service/MSSQLSERVER.
That sounds reasonable but the security tab does not recognise ant NT Service entries.
Looking at the running services it definitely uses this as the service log on so why can we not select it when trying to allow full access to the moved files?
We ticked the box to show service accounts but still nothing.
What stupid mistake have I made this time?
What I have tried:
Tried to add permissions via the file > properties > security settings but cannot find the SQL server account.