• Try these steps..

    1. Map the file location as a drive (like F:\folder) to the server where the sql  server is running. Specifying direct server path does not work.

    2.  Run 'dcomcnfg' exe and add in the account that SQL Server agent is running under. If it is running unde SA account, then choose 'Everyone'.

    Hope this helps!!!

    -sundar