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
Post a Comment