Posted - 10/03/2012 : 11:55:24
We've installed Microsoft ACE.OLEDB.12.0 Providers on one of our Servers to import the Data with 'OPENROWSET' query. We are able to see the Provider under Linked Servers & are able to execute the query, if member of SA. But the person who needs to be executed the query is only the member of Data_Owner for that particular DB (to which the query belongs to), not even any Server role and when he is trying to execute it receiving below msg :
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".
So please help me out what permission exactly we need to provide him along with Data_Owner or any specific role which can execute the query (but we should not give SA role to him)...Very Urgent...please
Mail ID: firstname.lastname@example.org