Sql-server – SQL Server Agent unable to view network drives

sql serversql-server-agent

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

Best Answer

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

Related Question