Overview
Problem / Symptoms:
When upgrading a Version on Bepoz, you might encounter and error when the Database.exe program is trying to perform an update on the Database Tables, where it is trying to create a TESTDATABASE only but the error results in a issue where the TESTDATABASE cannot be created. Resulting in the Database Tables not being able to perform and update.
Diagnosis / Symptoms:
The error occurs when SQL is trying to access the C:\\Bepoz\\Data directory but does not have permissions to do so, this is normally caused by Windows updates that change the default folder security settings.
Resolution:
There is an internal Windows Command prompt to reset Folder and Subdirectory permissions to their original default.
Run CMD in Administrator mode
Run the following command "icacls "C:\\Bepoz" /reset /t /c /l" without quotes.
This will allow SQL to create the TestDatabase within the Bepoz\\Data directory resolving the error of being unable to create the TESTDatabase.
