Workaround for Error 1032 Related to Event ID 455,489 and 490 on SQL Server 2012

When you install Microsoft SQL Server 2012 or SQL Server 2012 Analysis Services and use the default account as a service account for these applications during the installation, the services start fine but you see several errors listed in the Event Viewer in the Application Log that are related to Error 1032. There are at least 3 events logged for Error 1032 from source ESENT with Event ID 455, 489, and 490.

Error_1032

Event ID 455 is logged with the following description.

sqlservr (1476) Error -1032 (0xfffffbf8) occurred while opening logfile C:\Windows\system32\LogFiles\Sum\Api.log.

Event_ID_455

Event ID 489 is logged with the following description.

Event_ID_489

sqlservr (1476) An attempt to open the file “C:\Windows\system32\LogFiles\Sum\Api.log” for read only access failed with system error 5 (0×00000005): “Access is denied. “.  The open file operation will fail with error -1032 (0xfffffbf8).

Event ID 490 is logged with the following description.

sqlservr (1932) An attempt to open the file “C:\Windows\system32\LogFiles\Sum\Api.chk” for read / write access failed with system error 5 (0×00000005): “Access is denied. “.  The open file operation will fail with error -1032 (0xfffffbf8).

Event_ID_490

As you can see, the system is unable to read Api.chk and Api.log files in C:\Windows\system32\LogFiles\Sum folder. According to Microsoft KB article 2811566, this is a known issue in SQL Server 2012 and Microsoft doesn’t have a solution quite yet.

Workaround

As a workaround, you can manually set permissions for the service accounts that are used by SQL Server (sqlservr.exe) and SQL Server Analysis Services (msmdsrv.exe) to access the C:\Windows\System32\LogFiles\Sum folder. The sum folder is for the Software Usage Metrics (SUM) feature that uses the User Access Logging Service in Windows Server 2012.


Copyright ©2014 Zubair Alexander. All rights reserved.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Comment spam protected by SpamBam

Spam Protection by WP-SpamFree