Alexander’s Blog

January 10, 2014

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

by @ 8:14 am. Filed under Articles, SQL Server, Tips & Tricks, Troubleshooting

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.

Leave a Reply

*

Comment spam protected by SpamBam

Spam Protection by WP-SpamFree

Contact E-mail | Terms of Use | Privacy Policy

Copyright ©2002-2013 Zubair Alexander. All rights reserved.

Internal Links

Search Blog

Categories

Archives

July 2014
M T W T F S S
« Jun    
 123456
78910111213
14151617181920
21222324252627
28293031  

RSS Feeds

TechGalaxy Visitors

29 queries. 0.472 seconds