Have you tried setting the AllowInProcess property for the provider you are using

EXEC master.dbo.sp_MSset_oledb_prop N'xxxPROVIDERxxx', N'AllowInProcess', 1

or

Server Objects | Linked Servers | Providers | Right-click on a provider, and select Properties. Enable the Allow InProcess property.

TEST IT FIRST!!!