OPENROWSET and network share

[Gugale at Lincoln]

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

[Ed Murphy]

Gugale at Lincoln wrote:

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.

Does it work if you map the share to a drive letter on the SQL server?

[Dan Guzman]

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" <gu**************@gmail.comwrote in message
news:YU*******************@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