The OLE DB provider "VFPOLEDB.1" for linked server "VFPoledbDbf" reported an error. Access denied.
Original
This happens when SQL Server is running under an account other than Local System, and the provider is configured to run out of process. The workarounds are to either run SQL Server under the Local System account, or configure the provider to run in process (Allow InProcess).
The "access denied" error occurs when the following 3 conditions are met:
1. The Visual FoxPro provider is configured to run out of proc
2. The SQL service is configured to use an account other than Local System (i.e. a domain account)
3. You are accessing the server from an account other than the account used by the SQL service.
Do this to configure the Visual FoxPro provider to run in process.
Steps:
1. Start Enterprise Manager
2. Drill down into server.
3. Drill down into Security/Linked Servers.
4. Rightclick on Linked Servers and select New linked server
5. For Provider name, select Microsoft OLE DB Provider for Visual FoxPro
6. Click Provider Options
7. Check Allow InProcess checkbox. This will apply to any Visual FoxPro linked servers or distributed queries.
8. Click OK
9. Click Cancel, since you don't need to create a new linked server.
This should prevent the "access denied" error.