Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jayam.cnu
Starting Member
45 Posts |
 Posted - 2012-10-03 : 11:55:24
|
| Hi,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 1The 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 1Cannot 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...pleaseSreenivasulu.p,Mail ID: sreenivas.puliverthi@gmail.com |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-03 : 12:13:17
|
| can you show the connection string used for openrowset?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Regarding ACE.OLEDB.12.0 Driver