We are trying to link our dev DW server to a AD directory. When we setup the linked server it allows us to query off of the domain AD and not the one on the server we specified.
We are trying to link our dev DW server to a AD directory. When we setup the linked server it allows us to query off of the domain AD and not the one on the server we specified.
Any help would be greatly appreciated.
I need to do something similar but haven't done it yet. The buzzword is SPN, so just research that.