<div>
create one windows user, give full permission to &quot;Output_files&quot; folder to that user, create login for that windows user in sql server, <br />
<br />
Once you done with that, login to your SSMS with windows authentication and you will be ok
</div>


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

<div>
<div class="content wysiwyg-content">
SELECT * FROM OPENROWSET (BULK '\\mynetworksharedrive\XML<wbr />\Output_Fi<wbr />les\test.x<wbr />ml', SINGLE_BLOB) AS Data<br />
<br />
I'm trying to read the xml from a network sharedrive but wasn't successful, tried using a 'C:\XML\Output_Files\test.<wbr />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.<br />
<br />
Is there a way to mapped it to a network drive?
</div>
</div>


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?

OPENROWSET from a network share drive

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.