July 1, 2009 at 3:09 am
Hi,
I'm not a DBA but I'm fairly sure that this can be done. I've done a bit of looking around and come up with enough info to convince me that it's relatively easily done but not clear instructions as to how to do it. Could someone explain how? We can use SQL Server authentication on both databases. Is it possible to do with Windows Authentication as well?
I presume it will be done using sp_addlinkedserver and sp_addlinkedsrvlogin.
THanks,
dec.
July 1, 2009 at 3:23 am
You can do it from the GUI, maybe you'll find it easier.
In the object explorer for the linking server expand "Server Objects", then "Linked Servers".
Right click on "linked servers" and select "add new linked server", fill in the required fields and there you are.
For the login question you can use windows authentication with local windows users (current security context) only if the two domains are in trust. If this is not the case, you will have to provide a login name and a password for the remote domain.
Regards
Gianluca
-- Gianluca Sartori
July 1, 2009 at 3:32 am
I just noticed you need it for SQL 2K, while information I provided is for 2005. Sorry.
It works quite the same anyway, you have only a different tree in the management console: "management", "linked servers". The properties window is very similar.
Hope this helps
Gianluca
-- Gianluca Sartori
July 3, 2009 at 8:05 am
As the title you've written as "Different Domain" I don't think you can do it so easily. Before doing anything did u tried to connect the 2nd server from 1st and vice versa???
I think you might need to create a VPN connection between the two to make this happen.
And lest see what our other fellow members have to say.
Ram
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply