• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1814
  • Last Modified:

OPENROWSET from a network share drive

SELECT * FROM OPENROWSET (BULK '\\mynetworksharedrive\XML\Output_Files\test.xml', SINGLE_BLOB) AS Data

I'm trying to read the xml from a network sharedrive but wasn't successful, tried using a 'C:\XML\Output_Files\test.xml' is okay, but the xml file would eventually stored in a network drive rather than my c drive or the database server c drive.

Is there a way to mapped it to a network drive?
  • 2
1 Solution
create one windows user, give full permission to "Output_files" folder to that user, create login for that windows user in sql server,

Once you done with that, login to your SSMS with windows authentication and you will be ok
how was it resolved? by giving the permission?
emailamosAuthor Commented:
yes, thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now