bulk load mystery

This is a discussion on bulk load mystery within the sqlserver-programming forums in Microsoft SQL Server category; hello ... I've got sql2005 running under domain account. When I try to run this query from query analyzer remotely on server: SELECT * FROM OPENROWSET(BULK N'\\host\obr1.jpg', SINGLE_BLOB) as aaa i get error message: Cannot bulk load because the file \\host\obr1.jpg could not be opened. Operating system error code 5(error not found). But when I run same query under same user but loged locally on server everything works fine. When I try to check permissions file with runnig over runas command and sqlserver running account (on sql server or on remote client) everything looks ...

Go Back   Database Forum > Microsoft SQL Server > sqlserver-programming

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 08-28-2008, 05:12 AM
Default bulk load mystery

hello ...

I've got sql2005 running under domain account.
When I try to run this query from query analyzer remotely on server:
SELECT * FROM OPENROWSET(BULK N'\\host\obr1.jpg', SINGLE_BLOB) as aaa
i get error message:
Cannot bulk load because the file "\\host\obr1.jpg" could not be
opened. Operating system error code 5(error not found).

But when I run same query under same user but loged locally on server
everything works fine.

When I try to check permissions file with runnig over runas command
and sqlserver running account (on sql server or on remote client)
everything looks ok I can read file.

Users are member of bulkadmin role.

what the problem ?

thanks for any hint.
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 09:07 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.