SS2K5 Login Permissions Issue w/ Jet OLEDB

[JayKusch]

Afternoon Folk ...

So here is the issue. I have a login that executes a stored procedure. I do NOT have the account set as a SysAdmin role and when I execute the SP I get the following error:

[error]
Msg 7415, Level 16, State 1, Line 2
Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this provider through a linked server.
[/error]

Now if I set the login to use the SysAdmin role the SP executes just fine.

I thought it had to do with the unchecking the Linked Server..Providers..Microsoft.Jet.OLEDB.4.0 setting of "Disallow AdHoc Access" check box. But that has no seemed to do the trick.

SO ... I am thinking it has to be some rights assignment that I need to set but cannot seem to find.

Where would I grant access to login so that the SP will execute without the Login being assigned the SysAdmin role?

Thanks ALL!

J

Thanks

J. Kusch