• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 428
  • Last Modified:

Permission problem with AD Computers

Hi,

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).


0
maxihost
Asked:
maxihost
1 Solution
 
Neil RussellTechnical Development LeadCommented:
"\\XXX.X.XXX.XXX\d\home\XXXX\Web\GP2011\XX\2011\XX\R
2_XXX102011_S5_SP.txt"

Is that meant to be

"\\XXX.X.XXX.XXX\d$\home\XXXX\Web\GP2011\XX\2011\XX\R
2_XXX102011_S5_SP.txt"
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now