I need to know if are there a way to use OPENROWSET by a SQL user without sysadmin role?
We have the problem below when the SQL user perform a quey with OPENROWSET, however when perform with sysadmin role the result when come back it is correct.
Msg 7415, Level 16, State 1, Line 1
Ad hoc access to OLE DB provider 'IBMDA400' has been denied. You must access this provider through a linked server.
Windows Server 2008 R2 64bits
SQL Server 2008 R2 64bits
AddhocRemoteQuerysEnabled is True
Could someone help us, please.