maxihost
asked on
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\hom
2_XXX102011_S5_SP.txt" could not be opened. Operating system error code 1265(error not found).
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\hom
2_XXX102011_S5_SP.txt" could not be opened. Operating system error code 1265(error not found).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.