Remote database question

[rossm]

Hello all,

having read a bit about the bcm setup i am slightly confused and now worried
about how it actually works.

I wish to have the database for bcm installed on a server (not a domain
controller) the server is 2003 server standard and will have sql 2005 on it.

The server is simply a server no clients nothing fancy just sql. Its
connected to the web in a secure site with a fast connection.

I want a number of works from home or laptops to be able to connect to a BCM
database on this server, they will be using thier own pc's at home or
personal laptops out in the field. At no time are they a user on the server
(but i can add them if needed)
Is this even possible? i have installed 2003 server sql 2005 and installed a
bcm database but from reading the whitepaper i am thinking its not going to
work this way.
The reason i want the database held on this server is because i then can
easily back it up and the upload of the internet is very fast.

is this possible?

Thanks in advance

 

[Luther]

Hello all,

having read a bit about the bcm setup i am slightly confused and now worried
about how it actually works.

I wish to have the database for bcm installed on a server (not a domain
controller) the server is 2003 server standard and will have sql 2005 on it.

The server is simply a server no clients nothing fancy just sql. Its
connected to the web in a secure site with a fast connection.

I want a number of works from home or laptops to be able to connect to a BCM
database on this server, they will be using thier own pc's at home or
personal laptops out in the field. At no time are they a user on the server
(but i can add them if needed)
Is this even possible? i have installed 2003 server sql 2005 and installed a
bcm database but from reading the whitepaper i am thinking its not going to
work this way.
The reason i want the database held on this server is because i then can
easily back it up and the upload of the internet is very fast.

is this possible?

Thanks in advance

I think you will need a Virtual Private Network (VPN) to access the
database over the internet.

And, unless you are using Active Directory, you will need to add the
BCM users as users to the server itself, and they will have to have
the same login and password as on their client machines..

 

[rossm]

Hi, thanks for the help.

Thats what i was worried about. VPN is a no no and not everyone will want to
add/change user name/passwords on their personal pc's .

ok then its a none starter time to look at some other options

does seem a little silly that no one can access a remote database without
having the same details on the local machine and the server

 

[Luther]

Hi, thanks for the help.

Thats what i was worried about. VPN is a no no and not everyone will want to
add/change user name/passwords on their personal pc's .

ok then its a none starter time to look at some other options

does seem a little silly that no one can access a remote database without
having the same details on the local machine and the server







- Show quoted text -

That's the way Windows security works. Either a domain machine (e.g.
ActiveDirectory) authenticates the user, or the user id and password
pairs match. Otherwise anyone could assume anyone else's identity.

 

[Brian]

Actually, it is my experience that the user/password used for the VPN
connection does NOT matter. ONLY the local user name matters (and NOT the
local password).

So, as long as you create a user account on the domain / server that matches
the user account on the remote machine.. it will work (the user / password
for the vpn connection NOR the local password… have any bearing).

I just tested this on a stand alone (no domain – just workgroup) XP pro
notebook computer, connecting to SBS-2003; using Outlook 2007 Anywhere (rpc
over http) and a VPN (for the BCM).

Microsoft—why don’t you just have BCM use the Exchange DB!?!? You must be
able to do this with an Exchange folder, no?! Then it could work with
Outlook Anywhere, right?

Brian

 

[Luther]

Actually, it is my experience that the user/password used for the VPN
connection does NOT matter.  ONLY the local user name matters (and NOT the
local password).

So, as long as you create a user account on the domain / server that matches
the user account on the remote machine.. it will work (the user / password
for the vpn connection NOR the local password… have any bearing).

I just tested this on a stand alone (no domain – just workgroup) XP pro
notebook computer, connecting to SBS-2003; using Outlook 2007 Anywhere (rpc
over http) and a VPN (for the BCM).

Microsoft—why don’t you just have BCM use the Exchange DB!?!?  You must be
able to do this with an Exchange folder, no?!  Then it could work with
Outlook Anywhere, right?

Brian






- Show quoted text -

If a VPN requires a password for authentication, the VPN's password is
irrelevant to BCM because it not the Windows authentication password.
If your network is on a domain, the machine password is irrelevant;
authentication is handled by ActiveDirectory.