Sql Server : Error : Could not create a trace file (SP_TRACE_CREATE)
- Posted by Sqltimes
- On November 8, 2014
- 0 Comments
Quick one today:
Earlier last month, while running server side traces on a lab Sql Server machine, I ran into this interesting error.
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.
Trace File Permissions
This is easy to fix. Go to the folder where you are attempting to store the trace files. Open the folder properties and go to Security tab. Make sure the Sql Server service account is added to the permissions list with necessary read and write permissions.
Hope this helps,
0 Comments