Bulk Insert Problm with SQL Server 2005
Posted on 2007-10-17
Trying to perform a bulk insert from a text file located on a shared folder on a remote computer. Recieving the error message Operating system error code 5(Access is denied.).
SQL Server 2005 running on Windows 2003 SP1 connecting to a Windows 2003 SP1 server with a shared folder.
SQL Server and SQL Agent start with the same domain account, this account has Full Control permissions to share.
In the security log of the server hosting the shared folder there are entries showing attempted connections from sqlserver$ then multiple anonymous logon attempts. This one has us stumped, thanks in advance.