Linking SQl

[clayton74]

Hello All
I dont know if this is the correct place to post this question. We have 2 SQL servers on our WAN but they are on differant Domains, is there a way to setup so that we can maintane both SQL servers from 1 location

Thanks in advance

 

[JBaileys]

I assume you can ping both servers if they are on the same lan. All you need to do is register the servers through enterprise manager. Because they do not share domains, authentication should be done via sql server. Enter the server name or ip address and select sql authentication. The rest should fall into place.

Are you receiving any errors? I would also make sure your network libraries are passing ip or netbeui traffic (so you have sql traffic)