>I am trying to setup the VFPOLEDB provider on a server that has SQL Server 2000. Everything works fine locally, but then again I have the full-blown install of VFP8. I downloaded and ran the VFPOLEDB setup from Microsoft but that has errors and just registering by hand I get access denied errors from SQL.
>
>This can't be that hard, but apparently is base don a google search) Does someone have the definitive setup so I can get my linked server from SQl 2000 to read VFP data located on the same physical server.

What version of VFP OLE DB provider are you trying to instal? What error do you get? Are you installing under admin login?
You can try recently released OLE DB Provider for VFP9 from http://www.microsoft.com/downloads/details.aspx?familyid=e1a87d8f-2d58-491f-a0fa-95a3289c5fd4&displaylang=en