• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1862
  • 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?
0
emailamos
Asked:
emailamos
  • 2
1 Solution
 
RiteshShahCommented:
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
0
 
RiteshShahCommented:
how was it resolved? by giving the permission?
0
 
emailamosAuthor Commented:
yes, thanks
0
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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