Thursday, November 8, 2012

Windows error occurred while running SP_TRACE_CREATE. Error = 0x80070005 (Access is denied.)

I had created one start up stored procedure for capturing the trace files. Recently I had changed the location of the output file, after changing the location its throwing an error like below.

Error Details:
Windows error occurred while running SP_TRACE_CREATE. Error = 0x80070005(Access is denied.).
Msg 19062, Level 16, State 1, Procedure sp_trace_create, Line 1
Could not create a trace file.


Workaround / Fix

Its very simple to fix this solution, please follow below steps.

Step 1: Go to the output folder of the trace files, right click on it and open the properties.
Step 2: Open Security tab, add the service account and give the full access and click ok.

Problems with SP_TRACE_CREATE, sp_trace_create for SQL Server 2008 Internals and Troubleshooting, What security context is a sub procedure run under, Changing Server Side Trace Scripts, How to create a Profiler Trace during Server startup, Microsoft SQL Server: Setup and Administration - Audit TRACE restart, Thread Tracing the out put, SP_Trace_Create, Sp_trace_create And File Exists Error, Windows error occurred while running SP_StoredProcedure

2 comments:

Post a Comment