Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Security / February 2008

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
manderson.hamish@gmail.com - 25 Feb 2008 06:00 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.