Ad hoc access to OLE DB provider 'Microsoft.ACE.OLEDB.12.0' has been denied

Question

Went I Used Microsoft.ACE.OLEDB.12.0 to export Excel from sql on local it success but went i do it from other server it's error Ad hoc access to OLE DB provider 'Microsoft.ACE.OLEDB.12.0' has been denied. You must access this provider through a linked server

Who can help me!

Thanks 

Answer 1

Tuan,

 

 

An Stupid problem that i have already soffered a lot, try to execute your SQL Server management studio as administrator and execute the same query, probably it will conclude with sucess.

---

Fabrizzio A. Caputo
MCT
Certificações:
Oracle OCA 11g
MCITP SQL Server 2008 Implementation and Maintenance
MCITP SQL Server 2008 Developer
Blog Pessoal: www.fabrizziocaputo.wordpress.com
Blog Empresa: www.tripletech.com.br/blog
Twitter: @FabrizzioCaputo
Email: [e-mail]

Answer 2

You have to enable Ad Hoc access on the other server, check out this article => http://www.kodyaz.com/articles/enable-Ad-Hoc-Distributed-Queries.aspx

---

Matt