SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Bulk Load - File Access
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Shakes
Starting Member

1 Posts

Posted - 06/19/2013 :  09:56:03  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

South Africa
1466 Posts

Posted - 06/19/2013 :  09:58:54  Show Profile  Visit ditch's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000