0

I am unable to get agent jobs to output to a network path. I have pushed the IT guy to set up a domain authenticated user that logs in when the agent starts. That login does have access to the domain and is able to see the network drives. If I set the location of the output file to be the local c: then this works without issue. However if I set the drive to be a network location I get the following message;

[SQLSTATE 01000] (Message 0)Unable to open Step output file. The step succeeded.

Any help would be very much appreciated

Improve this question
2
  • 1
    What do you mean by "user that logs in when the agent starts"? Is it the account running SQL Server Agent service you can see on services.msc?
    – Ronaldo
    Jul 10, 2020 at 11:44
  • 1
    this link contains all you need to know about SQL Agent: red-gate.com/simple-talk/sql/database-administration/… As Ronaldo said, you need to make sure the service account running SQL Agent does have write permission in the remote folder.
    – Dominique Boucher
    Jul 10, 2020 at 12:59

1 Answer 1

Reset to default
0

Thank you for all the help. UNC file paths was the solution.

Another thing to check is that you refer to the output location with a UNC path instead of a mapped letter drive. Letter drive mappings aren't reliable from something running as a service. – Doug Deden 2 days ago

Here is some more information regarding mapped drives and services: https://stackoverflow.com/questions/182750/map-a-network-drive-to-be-used-by-a-service – G.Smith 2 days ago

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.