I need a sql server login (not a windows login) to be able to perform bulk inserts using a file on another server.
using bulk insert
\\path\to\server\c$\path\to\dir does not work because of permissions.
My question is: how can I configure the sql server user to access that file on another server?
I've tried mapping a drive, but that mapping isn't "visible" to the sql server login (it's only visible if I log in as a windows user)
Thanks for helping!