September 24, 2009 at 12:08 pm
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=\\9.10.11.100\Test\Test.xls', 'SELECT * FROM [Sheet1$]')
When i run the query using a login with sysadmin role i am getting the desired output but when i run the query with a non-sysadmin login i am getting the following error
"Ad hoc access to OLE DB provider [Microsoft.Jet.OLEDB.4.0] has been denied. You must access this provider through a linked server"
What could be the problem. Changing the DisallowAdHocAcess setting doesn't make any difference..
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 24, 2009 at 12:56 pm
Sounds like a security issue.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply