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 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

  • Distributed Query: Import XML using OpenRowSet Bulk from UNC - access denied
    ... connecting to SQL2005 Server B, the data is located on a server C at ... DECLARE @xml XML ... SQL server and verified this. ... if I run the query from the SQL ...
    (microsoft.public.sqlserver.xml)
  • SOAP - Beginner Desperately looking for Help
    ... XML message and getting back a return file. ... The server is: ... in information for a query and get a number indicating the query), ...
    (comp.lang.python)
  • Re: Distributed Query: Import XML using OpenRowSet Bulk from UNC - access denied
    ... The client is connecting via Integrated Authentication as sysadmin. ... connecting to SQL2005 Server B, the data is located on a server C at ... DECLARE @xml XML ... if I run the query from the SQL ...
    (microsoft.public.sqlserver.security)
  • Re: SQLXML for xml explicit
    ... then from those lessonids i need to form another xml containing topic ids. ... If I am going to use the sql server 2000's 'FOR XML EXPLICIT' it'd take some ... >> the query plan and the indexes are used by Query Processor to implement ... >> UNION ALLs as MERGE UNIONs. ...
    (microsoft.public.sqlserver.xml)
  • Re: Duplicate Record with .ADDNEW
    ... If the database server will allow you to create a table without something, ... table there is no possibility of duplicate records. ... field imported from the XML. ... Use the Command object instead. ...
    (microsoft.public.vb.database.ado)