Cannot initialize the data source for linked server
Posted on 2009-04-06
I migrated a backend access database for my vb.net program to SQL Server 2005. Everything works when I run the program on the same machine that has the server on it. When I try to run the program on other machines in the network: it works when it has to access everything, except the Linked Servers. The 'Linked Servers' are Access DB's that are on a different server on the network. (and I get the error above)
Tried these suggestions:
Set sharing on the Temp directory to everyone/full control. (relocated the Temp directory to root of C:/ instead of Docs and Settings)
Went to Component Services, 'My Computer' the one that has a MS DTC tab on it. Set the access to Allow Outbound, Allow Inbound, (Mutual Authentication Required), Allow Remote Clients, and Allow Remote Administration (all checked)
Unchecked: Enable Transaction Internet Protocol (TIP) Transactions
Unchecked: Enable XA Transactions
MS Office is installed on the computer hosting the server. (my computer)
Still get the same error message.
??This is possible to do, right....set up a Server on a WinXP destop CPU that is networked on my company's server?? It's just the linked server's that aren't working, and those are elsewhere on the Company's server domain. What do I do...spent hours trying to figure this out...if I could offer 5000 points...I would!