Posted by Dan Guzman on 12/17/06 15:54

Are you connecting using the account both locally and remotely? See the
Books Online
(ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/18a64236-0285-46ea-8929-6ee9bcc020b9.htm)
for OPENROWSET security considerations.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Gugale at Lincoln" <gugale.newsgroup@gmail.com> wrote in message
news:YUrgh.25003$9v5.24749@newssvr29.news.prodigy.net...
> Hi,
>
>
>
>
> I am not able to execute following command from computers other than the
> SQL server itself.
>
> select * from openrowset(bulk N'\\ImageServer\Model\Cam_05.dwg',
> SINGLE_BLOB) as doc
>
> I get following error message:
>
> Msg 4861, Level 16, State 1, Line 1
>
> Cannot bulk load because the file "\\ImageServer\Model\Cam_05.dwg " could
> not be opened. Operating system error code 5(Access is denied.).
>
>
>
>
> If I use local file path and keep the file on the SQL server then it works
> fine from any computer.
>
> select * from openrowset(bulk N'D:\Model\Cam_05.dwg', SINGLE_BLOB) as doc
>
>
>
> The network share has read access for everyone.
>
>
>
> What should I do to make it work? I am not allowed to move the files and
> the application which loads them to the SQL server.
>
>
>
> Thanks
>
> Sachin G
>
>
>
>
>
>

[Back to original message]