[dba-SQLServer] Schemas for separation of clients?

[Gustav Brock]

Hi Mark

Well, I´'m not sure. Maybe not, because you have to grant access right for each and every IP address that will connect to the server.

/gustav

-----Oprindelig meddelelse-----
Fra: dba-SQLServer [mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af Mark Breen
Sendt: 31. marts 2015 17:11
Til: Discussion concerning MS SQL Server
Emne: Re: [dba-SQLServer] Schemas for separation of clients?

Hello Gustav

Re the vpn I am not sure in fully grasp why you would need it.

Would it not be sufficient for you to open each clients external facing IP to your odbc ports.  What would make you create a VPN and although I need to read up on it, how or what would u have to do on your clients machines to make the VPN work?

Thanks

Mark
On 31 Mar 2015 22:07, "Gustav Brock" <gustav at cactus.dk> wrote:

> I hope I can use the VPN offering of AWS.
>
> /gustav
> ________________________________
> Fra: fhtapia at gmail.com<mailto:fhtapia at gmail.com>
> Sendt: ‎31-‎03-‎2015 15:46
> Til: Discussion concerning MS SQL Server<mailto:
> dba-sqlserver at databaseadvisors.com>
> Emne: Re: [dba-SQLServer] Schemas for separation of clients?
>
> how do you manage a secure connection? are you sending all your data 
> in the clear then?
>
>
> On Mon, Mar 30, 2015 at 11:23 AM Mark Breen <marklbreen at gmail.com> wrote:
>
> > Hi Gustav
> >
> > no need for a VPN, just make a security rule to include all ports from your
> > office and only open what other ports you need to the outside world.
> >
> > I imagine that will work fine.