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

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

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

html - jQuery UI Sortable - Remove placeholder after item is dropped -