Post reply

Bulk Insert

  • December 27, 2007 at 9:02 am

    #377744

    I’ve run across an interesting issue. Bluk insert decided to stop working a couple of days ago and now I receive the infamous “could not be opened. Operating system error code 5(Access is denied.)” error on 2 databases. Basically ServerA is receiving flat files, saving to a NAS and calling sql to bulk insert them. The sql server is a multi-instance cluster with 2 nodes. The weird part is the bulk insert process works just fine on other dbs in the same instance. This process is also working in the other instance just fine.

    To my knowledge nothing has changed in the environment. Which I believe because this started xmas eve at 1 am. I’ve also gone to the lengths of opening the share and folder access to everyone with full control. I have also dropped all security on the 2 dbs and reapplied. The sql service accounts and the account running the process on ServerA are not locked and are setup for trusted deligation. The SQL instances are sp2.

    Anyone else have a similar problem? Any help or insight would be greatly appreciated!

    Thanks!

  • December 27, 2007 at 10:57 am

    #763032

    Something had to have changed in the environment... for example, the login that SQL Server uses to start services... it may have been changed permission wise on the Windows Server so that it can no longer see the share.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • December 27, 2007 at 11:17 am

    #763043

    Just double checked. No security issues.

    The part that's throwing me off is the other dbs are working fine. The process that hits those databases is using the same credentials.

  • January 20, 2009 at 1:49 am

    #929539

    is it in the same folder?

  • January 20, 2009 at 5:36 am

    #929633

    Larry Mitchell (12/27/2007)

    Just double checked. No security issues.

    The part that's throwing me off is the other dbs are working fine. The process that hits those databases is using the same credentials.

    Are you getting and error message. If so, please copy and paste it so we can see exactly what it is.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply