Multiple Remote Office Sites

Hi all..

Have a (potential) customer here who wants to set up a MSCRM 1.2 install
across multiple remote sites, users in the remotes will be accessing via IE,
any recomendations on the best way to set this up???

Some of these sites will not have a dedicated internet connection / VPN
connection, is it possible to have multiple SQL servers syncing against the
master database on a schedule? Does MSCRM play well when it has been split
in to lots of small bits??? how is the exchange aspect going to get on with
all this mess????

Any pointers would be appreciated

Jay

John
Wed Jun 23 10:32:20 CDT 2004

Currently CRM uses a single SQL database. It is not possible currently to
have multiple CRM databases which then roll up into a main database. Right
now even clustering of two SQL servers is not officially supported. You
could expose your CRM web server to the internet and let your users in the
other sites access crm that way. Of course without VPN you would at least
want to enable SSL encryption on the connection.

"Jason Fitzpatrick" <gort(nospam)_jay@hotmail.com> wrote in message
news:uR$3ZnQWEHA.712@TK2MSFTNGP11.phx.gbl...
> Hi all..
>
> Have a (potential) customer here who wants to set up a MSCRM 1.2 install
> across multiple remote sites, users in the remotes will be accessing via
IE,
> any recomendations on the best way to set this up???
>
> Some of these sites will not have a dedicated internet connection / VPN
> connection, is it possible to have multiple SQL servers syncing against
the
> master database on a schedule? Does MSCRM play well when it has been split
> in to lots of small bits??? how is the exchange aspect going to get on
with
> all this mess????
>
> Any pointers would be appreciated
>
> Jay
>
>

Jason
Wed Jun 23 11:07:58 CDT 2004

John,,,

Thanks for that,,, do you know if they have any plans for a situation like
this in the future, cos lets face it it is not much of a crm system if it
all has to run off the one SQL server, what happens in the case of a
multinational???

Jay

"John O'Donnell" <csharpconsulting@nospam-hotmail.com-nospam> wrote in
message news:es1NIdTWEHA.1380@TK2MSFTNGP09.phx.gbl...
> Currently CRM uses a single SQL database. It is not possible currently to
> have multiple CRM databases which then roll up into a main database. Right
> now even clustering of two SQL servers is not officially supported. You
> could expose your CRM web server to the internet and let your users in the
> other sites access crm that way. Of course without VPN you would at least
> want to enable SSL encryption on the connection.
>
> "Jason Fitzpatrick" <gort(nospam)_jay@hotmail.com> wrote in message
> news:uR$3ZnQWEHA.712@TK2MSFTNGP11.phx.gbl...
> > Hi all..
> >
> > Have a (potential) customer here who wants to set up a MSCRM 1.2 install
> > across multiple remote sites, users in the remotes will be accessing via
> IE,
> > any recomendations on the best way to set this up???
> >
> > Some of these sites will not have a dedicated internet connection / VPN
> > connection, is it possible to have multiple SQL servers syncing against
> the
> > master database on a schedule? Does MSCRM play well when it has been
split
> > in to lots of small bits??? how is the exchange aspect going to get on
> with
> > all this mess????
> >
> > Any pointers would be appreciated
> >
> > Jay
> >
> >
>
>

Peter
Wed Jun 23 11:18:09 CDT 2004

Release 2, due March/April next year is due to have scalability
enhancements, as yet undefined

Microsoft currently aim CRM at the small- to mid-market, not multinationals.
CRM only does what it says on the tin!

Peter

"Jason Fitzpatrick" <gort(nospam)_jay@hotmail.com> wrote in message
news:OiG$BxTWEHA.3420@TK2MSFTNGP12.phx.gbl...
> John,,,
>
> Thanks for that,,, do you know if they have any plans for a situation like
> this in the future, cos lets face it it is not much of a crm system if it
> all has to run off the one SQL server, what happens in the case of a
> multinational???
>
> Jay
>
> "John O'Donnell" <csharpconsulting@nospam-hotmail.com-nospam> wrote in
> message news:es1NIdTWEHA.1380@TK2MSFTNGP09.phx.gbl...
> > Currently CRM uses a single SQL database. It is not possible currently
to
> > have multiple CRM databases which then roll up into a main database.
Right
> > now even clustering of two SQL servers is not officially supported. You
> > could expose your CRM web server to the internet and let your users in
the
> > other sites access crm that way. Of course without VPN you would at
least
> > want to enable SSL encryption on the connection.
> >
> > "Jason Fitzpatrick" <gort(nospam)_jay@hotmail.com> wrote in message
> > news:uR$3ZnQWEHA.712@TK2MSFTNGP11.phx.gbl...
> > > Hi all..
> > >
> > > Have a (potential) customer here who wants to set up a MSCRM 1.2
install
> > > across multiple remote sites, users in the remotes will be accessing
via
> > IE,
> > > any recomendations on the best way to set this up???
> > >
> > > Some of these sites will not have a dedicated internet connection /
VPN
> > > connection, is it possible to have multiple SQL servers syncing
against
> > the
> > > master database on a schedule? Does MSCRM play well when it has been
> split
> > > in to lots of small bits??? how is the exchange aspect going to get on
> > with
> > > all this mess????
> > >
> > > Any pointers would be appreciated
> > >
> > > Jay
> > >
> > >
> >
> >
>
>

Jason
Wed Jun 23 12:45:29 CDT 2004

thanks for the info!

Jay


"Peter Lynch" <anon@anon.com> wrote in message
news:OHxLV4TWEHA.2908@TK2MSFTNGP10.phx.gbl...
> Release 2, due March/April next year is due to have scalability
> enhancements, as yet undefined
>
> Microsoft currently aim CRM at the small- to mid-market, not
multinationals.
> CRM only does what it says on the tin!
>
> Peter
>
> "Jason Fitzpatrick" <gort(nospam)_jay@hotmail.com> wrote in message
> news:OiG$BxTWEHA.3420@TK2MSFTNGP12.phx.gbl...
> > John,,,
> >
> > Thanks for that,,, do you know if they have any plans for a situation
like
> > this in the future, cos lets face it it is not much of a crm system if
it
> > all has to run off the one SQL server, what happens in the case of a
> > multinational???
> >
> > Jay
> >
> > "John O'Donnell" <csharpconsulting@nospam-hotmail.com-nospam> wrote in
> > message news:es1NIdTWEHA.1380@TK2MSFTNGP09.phx.gbl...
> > > Currently CRM uses a single SQL database. It is not possible currently
> to
> > > have multiple CRM databases which then roll up into a main database.
> Right
> > > now even clustering of two SQL servers is not officially supported.
You
> > > could expose your CRM web server to the internet and let your users in
> the
> > > other sites access crm that way. Of course without VPN you would at
> least
> > > want to enable SSL encryption on the connection.
> > >
> > > "Jason Fitzpatrick" <gort(nospam)_jay@hotmail.com> wrote in message
> > > news:uR$3ZnQWEHA.712@TK2MSFTNGP11.phx.gbl...
> > > > Hi all..
> > > >
> > > > Have a (potential) customer here who wants to set up a MSCRM 1.2
> install
> > > > across multiple remote sites, users in the remotes will be accessing
> via
> > > IE,
> > > > any recomendations on the best way to set this up???
> > > >
> > > > Some of these sites will not have a dedicated internet connection /
> VPN
> > > > connection, is it possible to have multiple SQL servers syncing
> against
> > > the
> > > > master database on a schedule? Does MSCRM play well when it has been
> > split
> > > > in to lots of small bits??? how is the exchange aspect going to get
on
> > > with
> > > > all this mess????
> > > >
> > > > Any pointers would be appreciated
> > > >
> > > > Jay
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Ketil
Tue Jun 29 07:55:48 CDT 2004

We are in the same positions.

Some 30 users spread based in London, Houston, Dubai,
Kuala Lumpur, Oslo and a few other places. All users
travel extensively, often to remote places.

Our plan is to use the SFO in offline mode, and have the
users syncronize frequently.

Ketil


>-----Original Message-----
>Hi all..
>
>Have a (potential) customer here who wants to set up a
MSCRM 1.2 install
>across multiple remote sites, users in the remotes will
be accessing via IE,
>any recomendations on the best way to set this up???
>
>Some of these sites will not have a dedicated internet
connection / VPN
>connection, is it possible to have multiple SQL servers
syncing against the
>master database on a schedule? Does MSCRM play well when
it has been split
>in to lots of small bits??? how is the exchange aspect
going to get on with
>all this mess????
>
>Any pointers would be appreciated
>
>Jay
>
>
>.
>