I am try to run bulk insert command on SQL Server 2008 but I am having issues with the security. after researching via internet, the problem has something to do with account delegation and impersonation.
However all solutions seems to point to an Active Directory setup which my setup is not.
My setup is SQL Server 2008 Express on Windows Server 2008 Standard configured as a workgroup.
Despite a SQL Server user account, assigned all the user mappings and server roles and ensuring security set to SQL, I am getting this error:
Msg 4861, Level 16, State 1, Line 1
Cannot bulk load because the file "\server_name\file_name.txt" could not be opened. Operating system error code 5 (Access is denied.).
So, how does one setup SQL Server account delegation and impersonation on a workgroup environment?
Thanks in advance