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

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 2
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 the query is run from Workstation A, the query fails. If the XML
files are local to the SQL server, I get successful results... just
not via UNC, ie. distributed query's fail. Are they supported?

User on Workstation A is authenticated with Integrated security (SQL
Admin) and has rights to read the XML files on Server C.

AdHoc Queries using OpenRowSet has been enabled and verified.

Thank you for any responses.

Hamish
.

Relevant Pages

  • RE: Query producing XML appears to be cached
    ... By default the XMLDataSource control always caches its data, ... I have an app that executed a sql server query that produces an XML ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Discussing 3 different strategies for deleting from multiple tables
    ... I will be using SQL Server but I am riding on top of a third party ... FYI, Account contains around 20K ... >>> This results in one parameterized query followed by two more trips to ...
    (microsoft.public.data.ado)
  • Re: Efficient coordinated queries??
    ... :-) We are distributing processing over a large server farm -- bringing it back onto the SQL server would probably kill our performance. ... Hitchhiker's Guide to Visual Studio and SQL Server ... A large chunk of it can be brought in with a single query and each row represents an item to process. ... For a hypothetical example consider a customer order database where we need to process through all customers and can bring in a row of customer data as our main query but there are 0..n1 rows of customer order data, 0..n2 rows of customer feedback information, 0..n3 rows of customer discounts available, etc. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: DTS Global Variables + SQL query
    ... they query I'm trying to run isn't as straight forward as I originally ... >>I'm creating a new Transform Data Task in SQL Server 2000. ... >>'Creating an XML object to read the XML ... > Script Task to set the values to global variables makes sense. ...
    (microsoft.public.sqlserver.dts)
  • Re: Distributed Query: Import XML using OpenRowSet Bulk from UNC - access denied
    ... The security delegation should be setup for the service user account/port combination and registered. ... This is more of a general OpenRowset than XML question. ... connecting to SQL2005 Server B, the data is located on a server C at ... SQL server and verified this. ...
    (microsoft.public.sqlserver.xml)