OPENROWSET



I've the SQL Service to run on a domain admin account.
Bad practice yes, but trying to resolve issue.
Errors with :
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: Unspecified error]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80004005: ].


We're trying to execute the openrowset command in a production environment,
but can't get anything to run unless the account executing the SQL is admin
on local box. Any directions to look?


.



Relevant Pages