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.
manderson.hamish@gmail.com - 25 Feb 2008 06:01 GMT
Update:
The client is connecting via Integrated Authentication as sysadmin.
manderson.ham...@gmail.com 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
[quoted text clipped - 21 lines]
>
> Thank you for any responses.