I have a setup with 2 machines (client on win2012r2, sql server on win2016) which are both not part of a domain. The client machine has a share, accessible to Everyone. I'm using SQL Server authentication. I'm able to browse the share from the SQL server
I have an application which attempt to do a BULK INSERT, but it's complaining that the bulk insert encountered an error code 1326 (username or password incorrect) when accessing the share.
This does not make sense to me; there is no password required to access the files, so how can it be incorrect? I've also tried to configure the application to upload to a share on the SQL Server, and do the bulk insert using a local path, but that triggers an access denied during the BULK INSERT.