Re: Distributed Query: Import XML using OpenRowSet Bulk from UNC - access denied

Update:

The client is connecting via Integrated Authentication as sysadmin.


manderson.ham...@xxxxxxxxx wrote:
I'm having issues importing XML data using a distributed query with
the following statement which is run from an XP workstation named A
connecting to SQL2005 Server B, the data is located on a server C at
the following UNC path \\SERERC\SHARE\PATH\DATAFILE.XML

DECLARE @xml XML
SELECT @xml =CONVERT(XML, bulkcolumn, 2)
FROM OPENROWSET(BULK '\\SERVERC\SHARE\PATH\DATAFILE.XML', SINGLE_BLOB)
AS x
SELECT @xml

Results:
Msg 4861, Level 16, State 1, Line 7
Cannot bulk load because the file "\\ServerC\Share\Path\DataFile.xml"
could not be opened. Operating system error code 5(Access Denied).

The SQL Server service is running using a domain user account with
permissions to read the remote files. I have logged in locally to the
SQL server and verified this. Also, if I run the query from the SQL
Server B, the query is successful. When it is run from Workstation A,
the query fails.

AdHoc Queries using OpenRowSet has been enabled and verified.

Thank you for any responses.
.

Relevant Pages