Hi guys
First, thanks to Mr. John who suggested me to start a new thread.
I am very new to this forum. Hope that my query will be answered. If I am not able to put up my query in clear manner please do reply to this post.
I want to setup a WAN for my SQL servers. I want to have a sQL Server at one Location with Static IP Address, and 2 more servers on different location. Each site will have it's own databases so that they can work independently. Those two servers data will be replicated to my central server whenever they require. I have a doubt in my mind wheter it is possible or not to access my central server which is having Static IP address through internet. And one more thing whether i will be able to administer those two servers from my central server. Here I want to use push subscription with remote agent activation. Please guide me. One thing will also be clear that that those two servers are not having any static IP and use to connect to internet either by Dial-Up or DSL.
I am thanking all of you in advance and please help me out.
Manoj