Permission problem with AD Computers

Posted on 2011-10-15
Last Modified: 2012-05-12

We have tree servers, one application server, one database server and one domain controler, we need to use SQL Bulk Insert t put data in SQL server with files located on application server.

I put our SQL to start with one user in our domain and we use windows sharing to get all data and insert in SQL server.

But we have some errors with permissions, when i try to map one directory from application server to database server does not work, but when i try to map one directory from database server to application server works fine.

If i use the same user in both servers, i don't know why doesn't work in both ways.

In my Bulk insert i have this error:

Cannot bulk load because the file"\\XXX.X.XXX.XXX\d\home\XXXX\Web\GP2011\XX\2011\XX\R
2_XXX102011_S5_SP.txt" could not be opened. Operating system error code 1265(error not found).

Question by:maxihost
    1 Comment
    LVL 37

    Accepted Solution


    Is that meant to be


    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Recently, I had the need to build a standalone system to run a point-of-sale system. I’m running this on a low-voltage Atom processor, so I wanted a light-weight operating system, but still needed Windows. I chose to use Microsoft Windows Server 200…
    ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now