Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Shakes
Starting Member
1 Post |
 Posted - 2013-06-19 : 09:56:03
|
| Hello,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.Steps taken:- 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 pathsNothing 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.Reason: 15105).The Query I use:SELECT * FROM OPENROWSET (BULK '<file location>, SINGLE_BLOB) rsI 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?Thank you. |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
|
|
|
|
|
SQL Bulk Load - File Access