SQL Server : Trace won't create file -


i'm trying start using sql trace , running "access denied" errors when using following:

exec @rc = sp_trace_create @traceid output, 0, n'c:\users\user$\desktop\sqltrace', @maxfilesize, null  

if (@rc != 0) goto error

i have tried unc path , local, using admin account login mgmt studio, component missing? have tried saving locally , remote client.

it's not permissions account has, it's whether or not account used start sql server service has write permissions folder. please check first. see sp_trace_create doc:

for sp_trace_create, sql server service account must have write permission on trace file folder. if sql server service account not administrator on computer trace file located, must explicitly grant write permission sql server service account.


Comments

Popular posts from this blog

java - Andrioid studio start fail: Fatal error initializing 'null' -

android - Gradle sync Error:Configuration with name 'default' not found -

StringGrid issue in Delphi XE8 firemonkey mobile app -