In the past couple of days, after restoring my database I was been experiencing unexpected shutdown occurrences in SQL and non responsive AOS service
In event log I was getting following error
sqlservr (3160) An attempt to open the file "C:\Windows\system32\LogFiles\Sum\SystemIdentity.mdb" for read / write access failed with system error 5 (0x00000005): "Access is denied. ". The open file operation will fail with error -1032 (0xfffffbf8).
and
sqlservr (3160) Database recovery/restore failed with unexpected error -1032.
Solution for this was in KB Artical
https://support.microsoft.com/en-gb/kb/2811566
To work around this problem, add read/write permissions manually to the service accounts that are used by SQL Server (sqlservr.exe) and SQL Server Analysis Services (msmdsrv.exe) to access the \Windows\System32\LogFiles\Sum folder.
In event log I was getting following error
sqlservr (3160) An attempt to open the file "C:\Windows\system32\LogFiles\Sum\SystemIdentity.mdb" for read / write access failed with system error 5 (0x00000005): "Access is denied. ". The open file operation will fail with error -1032 (0xfffffbf8).
and
sqlservr (3160) Database recovery/restore failed with unexpected error -1032.
Solution for this was in KB Artical
https://support.microsoft.com/en-gb/kb/2811566
To work around this problem, add read/write permissions manually to the service accounts that are used by SQL Server (sqlservr.exe) and SQL Server Analysis Services (msmdsrv.exe) to access the \Windows\System32\LogFiles\Sum folder.
