Setting up a linked server to another server which isn't in a domain without using SQL authenticatio
- by Telos
Server A (SQL2005) is in our primary domain, but server B (SQL2000) is just in a windows workgroup. We are not allowed to join it to the domain, or bad things happen...
We also can't enable SQL authentication on server B.
We've got domain accounts for A, and matching local accounts on server B.
I can connect to B from my local PC or A using SSMS and a domain login, but I can't get the linked server to connect.
Any ideas how to do this?