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

_{Friday, November 25, 2011 3:13 AM}

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 

_{Saturday, November 26, 2011 7:08 AM ✅Answered | 1 vote}

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.aspxMatt

_{Friday, November 25, 2011 5:20 PM}

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: fabrizzio.antoniaci@gmail.com

_{Thursday, October 31, 2013 12:08 PM}

life and time saving. Thank you!