Consider the following scenario:
- You install Microsoft SQL Server 2012 or SQL Server 2012 Analysis Services on a computer that is running Windows Server 2012.
- You use the default account as a service account for these applications during the installation.
- The installation is successful.
- After the installation, the services for these programs start successfully.
In this scenario, you may find error messages in the Application log that resemble the following:
For instances of SQL Server (SQLServr.exe)
For instances of SQL Server Analysis Services (Msmdsrv.exe)
msmdsrv (4680) Error -1032 (0xfffffbf8) occurred while opening logfile C:\Windows\system32\LogFiles\Sum\Api.log.
This problem occurs because of insufficient permissions for the service startup accounts for SQL Server and for SQL Server Analysis Services when the services access the following folder for logging as a part of the Software Usage Metrics feature:
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.