Posted - 06/19/2013 : 09:56:03
I have enabled FileStream and from SSMS I can then insert a file (so from within the server).
However, locally I cannot. I expect it has to do something with permissioning but I can't quite figure it out.
- Given my SQL account Bulkadmin and sysadmin
- Tried to connect using windows authentication (same windows auth I used to connect to server that has SSMS)
- JDBC, ODBC and ADODB connections
- Using UNC paths
Nothing works, everything throws this error:
Description: Cannot bulk load because the file " " could not be opened. Operating system error code 5(failed to retrieve text for this error.
The Query I use:
SELECT * FROM OPENROWSET (BULK '<file location>, SINGLE_BLOB) rs
I have admin rights to the server but not locally. My windows login has access to the files and to SQL.
So my real question: How can I insert local files to my sql server? What permissions am I lacking and how can I give them?