Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

asynchronous_file_target access denied error Expand / Collapse
Author
Message
Posted Tuesday, September 25, 2012 2:22 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 23, 2013 1:01 PM
Points: 123, Visits: 293
I am working thru the extended events and I am trying to set the output to a file using asynchronous_file_target. I am getting an access denied error from the OS. The folder that I am trying to write to exists and I am the admin on this system. Is there a configuration option that I need to set? Or do I need to grant the user that is running the sql server service has write access to the target drive? I've tried searching and I'm not getting any good hits. Thanks in advance.
Post #1364284
Posted Tuesday, September 25, 2012 5:21 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 11:44 AM
Points: 6,235, Visits: 7,371
jberg-604007 (9/25/2012)
I am working thru the extended events and I am trying to set the output to a file using asynchronous_file_target. I am getting an access denied error from the OS. The folder that I am trying to write to exists and I am the admin on this system. Is there a configuration option that I need to set? Or do I need to grant the user that is running the sql server service has write access to the target drive? I've tried searching and I'm not getting any good hits. Thanks in advance.


There's two users you'll need to check here. First, yes, the SQL Server service is the one that will definately need access to the filesystem for the file. Next, you'll also want to check the xp_cmdshell proxy and make sure it's not different. I don't remember if extended events relies on that user directly or not but if you *do* have a proxy setup make sure they have access as well just to remove the possible headaches.



- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1364362
Posted Wednesday, September 26, 2012 7:00 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 23, 2013 1:01 PM
Points: 123, Visits: 293
Thanks Craig!
Post #1364634
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse