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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Bulk Load - File Access

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 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.
Reason: 15105).

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?

Thank you.

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2013-06-19 : 09:58:54
Try this: http://blogs.msdn.com/b/jay_akhawri/archive/2009/02/16/resolving-operating-system-error-code-5-with-bulk-insert-a-different-perspective.aspx


Duane.
http://ditchiecubeblog.wordpress.com/
Go to Top of Page
   

- Advertisement -