• Perry Whittle (11/3/2013)


    Firstly, don't use administrative shares for file\folder access, create a new share at the appropriate folder level and ensure you set the following for the account the SQL Server agent service runs under

    Share permissions

    NTFS security permissions

    +1 here... your service account (running SQL Server) does not have rights to utilize the administrative share. As mentioned above, create a new share granting rights to the SS service account.

    Kurt

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman