June 27, 2008 at 9:30 am
There is a stored procedure on my server which imports data from various sources. The one I'm having a problem with is this...
SELECT * into MyTable from OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'\\server\share\file.csv')
I am getting an error indicating that the linked server could not be found. I'm sure this is due to the fact that the user doesn't have access to the share. However, this user is SQL login, not a windows login. I would like a suggestion on how to get this user access to the windows share.
Your help is greatly appreciated
June 27, 2008 at 9:39 am
If it's in a stored procedure you could use the EXECUTE AS option to run the procedure in the security context of anther login. I'm not sure it will work for accessing a fileshare, but it's worth a try.
[font="Verdana"]Markus Bohse[/font]
June 27, 2008 at 10:06 am
Hmmm. That sounds very promising. Thanks for the tip!
Mark
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply