June 13, 2007 at 8:58 am
Hi Everyone.. I have been banging my head against a wall here for a while..here is the Situation:
I have a new Dev environment consisting of Dev1(SQL2005 Std), Dev2(SQL2005 Ent), and Dev3(SQL2000 Std) I have a DTS package running on Dev3 that is trying to BCP a file from DEV1 over to a table on Dev2. The SQL service acct(domainacct) is local admin and SA on all three boxes and has full control to the source file share(\\Dev1\Folder\File.txt) I keep getting an error: Operating System Error Code 5(access denied)
It works when source and dest are on the same server or if I run it from Dev2(pulling from Dev1) but not from a third server.
Any suggestions?
June 13, 2007 at 9:04 am
Did you set up the Share permissions in addition to the folder NTFS permission?
To make sure what is going on, run the package and right after that check the security logs on both Dev1 and Dev2 to see what account is denied access.
Regards,Yelena Varsha
June 13, 2007 at 9:14 am
Yes..NTFS and share perms are correct - well, wide open. The errors show NTAuthority\AnonymousLogin..hmm.. the database engine and agent are running under the service account.. Anything else?
June 13, 2007 at 9:18 am
On which machine? Also, are all 3 machines in the same domain?
Regards,Yelena Varsha
June 13, 2007 at 9:24 am
The errors were on both Dev1 and Dev2(I have a copy of the source on both) and I just checked.. and of course.. Dev1 and Dev2 are on a different domain(but it is trusted)
June 14, 2007 at 9:13 am
Do this:
Log in to your Dev3 as the service startup account that you call in this post domainacct and try to access a share \\Dev1\Folder\File.txt yourself doing it as this account. Then you will probably see the error messages and will ask your network admins to fix this account access.
The account can not be the same in different domains even if they are trusted. It is possibly Domain1\domainacct and Domain2\domainacct. In this case the access to the share in Domain1 should be explicitly given to Domain2\domainacct as well as NTFS permissions.
Regards,Yelena Varsha
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply