I set up a VFPOLEDB datasource as a linked server on one of our SQL2005 servers.
I works fine when I'm physically or via Remote Desktop on the server.

From the SQLWB on my PC I get:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Cannot initialize the data source object of OLE DB provider "VFPOLEDB" for linked server "CLIPPER". (Microsoft SQL Server, Error: 7303)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3175&EvtSrc=MSSQLServer&EvtID=7303&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Help of course get's you a "no help" message.

I have tried MSDN Forums » SQL Server » SQL Server Data Access » VFP Linked Server problems and there is a lot of talk but no solution.

I presume that it's a security issue since it works fine on the server.

Help much appreciated.

TIA