SQL error 1032 generally triggers when a default account is used as a service account.
In this context we shall look into this error and how we fixed it.
More about SQL error 1032
As a matter of fact, SQL 1032 error occurs in Microsoft SQL Server environment as well as in SQL Server Analysis Services. It is triggered when the default account is used as a service account. When a service is initiated, in the initial instance it works fine but eventually issues arises and you can see the Application log in the Event Viewer that it relates to SQL 1032 error.
From our experience, we noticed that 3 events are evident in an Error 1032 from ESENT source having ID 455, 489, and 490. For instance, SQL Server (SQLServr.exe) logs the following error messages respectively;
sqlservr (3472) An attempt to open the file "C:Windowssystem32LogFilesSumApi.log" for read only access failed with system error 5 (0x00000005): "Access is denied. ". The open file operation will fail with error -1032 (0xfffffbf8).Error 1032
sqlservr (3472) Error -1032 (0xfffffbf8) occurred while opening logfile C:\Windows\system32\LogFiles\Sum\Api.log.
sqlservr (1932) An attempt to open the file “C:\Windows\system32\LogFiles\Sum\Api.chk” for read / write access failed with system error 5 (0x00000005): “Access is denied. “. The open file operation will fail with error -1032 (0xfffffbf8).
While in other instances of SQL Server Analysis Services (Msmdsrv.exe), you will see error messages;
msmdsrv (4680) An attempt to open the file "C:\Windows\system32\LogFiles\Sum\Api.chk" for read / write access failed with system error 5 (0x00000005): "Access is denied. ". The open file operation will fail with error -1032 (0xfffffbf8).
msmdsrv (4680) Error -1032 (0xfffffbf8) occurred while opening logfile C:\Windows\system32\LogFiles\Sum\Api.log.
The system is unable to read Api.chk and Api.log files in C:\Windows\system32\LogFiles\Sum folder. This is a known issue in SQL Server 2012.
Main cause of SQL error 1032
This error has to do with situation when there is not enough permission for the service account to function. Therefore, in the SQL Server and Analysis Services, the 1032 Error will be triggered when trying to access the following folder for logging as a part of the Software Usage Metrics feature:
How to solve SQL error 1032
1032 error can be fixed by adding read and write permission to the service accounts. The Service accounts in this case will be assigned with the these permission as they run SQL Server (sqlservr.exe) as well as Analysis Services (msmdsrv.exe) which is accessible on the Directory C: \Windows\System32\LogFiles\Sum.
On a normal basis, read and write permissions are not given to these accounts as it belongs to the Software Usage Metrics (SUM) function. In Windows Server 2012, SUM utilizes the User Access Logging Service.