Thursday, October 14, 2010

SQL Server Job fails with error “Unable to open step output file. The step failed”

 

Are you getting the error message below on a SQL Server Job?

image

Resolution:

See if the SQL Agent Service account have sufficient privileges.

I have encountered this error when I change the SQL Server Agent account.
Resolved giving proper rights on the folder.

1 comment:

James Zicrov said...

Thank you so much for putting up such a useful and excellent blog post about SQL and its other areas as well.As usual this excellent blogger puts up the best everytime.

SQL Server Load Rest API