Is it possible.....SQL 2 SQL on SBS2000

I have clients who are doctors and have several small
offices in various locations. I currently have two of the
offices on SBS2000. They use a SQL database application
for appointments, patient history, doctor availability,
etc. Is it possible to replicate information between the
two or more SQL servers even though they are on seperate
LANS (connected via VPN) and are seperate SBS2000
domains? I am pretty sure this possible with the stand
alone SQL server but was not sure if this was possible
with the SBS2000 version of SQL. Secondly, when
replicating information between the servers, can they use
a RPC to contact each other via the internet or do they
need to go through a WAN or VPN. If they can use a RPC,
is this information encrypted or can it be compromised
during the replication process.

Steve
Fri Jul 11 05:27:28 CDT 2003

jcatalucci wrote:

> I have clients who are doctors and have several small
> offices in various locations. I currently have two of the
> offices on SBS2000. They use a SQL database application
> for appointments, patient history, doctor availability,
> etc. Is it possible to replicate information between the
> two or more SQL servers even though they are on seperate
> LANS (connected via VPN) and are seperate SBS2000
> domains? I am pretty sure this possible with the stand
> alone SQL server but was not sure if this was possible
> with the SBS2000 version of SQL. Secondly, when
> replicating information between the servers, can they use
> a RPC to contact each other via the internet or do they
> need to go through a WAN or VPN. If they can use a RPC,
> is this information encrypted or can it be compromised
> during the replication process.

Yes it is possible. But it's not terribly easy. You basically follow
the SQL guidelines on replication between untrusted domains.

And unless you create a VPN between the two networks, the data is
transmitted in the clear (having said that, it's SQL's internal format,
not raw ascii).

--
Steve Foster [SBS MVP]
---------------------------------------
MVPs do not work for Microsoft. Please reply only to the newsgroups.

jcatalucci
Tue Jul 15 19:56:01 CDT 2003

Thanks for the info. I'll take a closer look at the SQL
replication info.


>-----Original Message-----
>jcatalucci wrote:
>
>> I have clients who are doctors and have several small
>> offices in various locations. I currently have two of
the
>> offices on SBS2000. They use a SQL database
application
>> for appointments, patient history, doctor
availability,
>> etc. Is it possible to replicate information between
the
>> two or more SQL servers even though they are on
seperate
>> LANS (connected via VPN) and are seperate SBS2000
>> domains? I am pretty sure this possible with the stand
>> alone SQL server but was not sure if this was possible
>> with the SBS2000 version of SQL. Secondly, when
>> replicating information between the servers, can they
use
>> a RPC to contact each other via the internet or do
they
>> need to go through a WAN or VPN. If they can use a
RPC,
>> is this information encrypted or can it be compromised
>> during the replication process.
>
>Yes it is possible. But it's not terribly easy. You
basically follow
>the SQL guidelines on replication between untrusted
domains.
>
>And unless you create a VPN between the two networks,
the data is
>transmitted in the clear (having said that, it's SQL's
internal format,
>not raw ascii).
>
>--
>Steve Foster [SBS MVP]
>---------------------------------------
>MVPs do not work for Microsoft. Please reply only to the
newsgroups.
>.
>