[dba-SQLServer] Schemas for separation of clients?

John W. Colby jwcolby at gmail.com
Mon Mar 30 23:51:38 CDT 2015


Can you use it to connect Access to an IP on the remote machine?

I don't particularly need remote access per se, though I might if I go 
with AWS or the like.  What I am really trying to accomplish is hitting 
a SQL server with Access linked tables with minimal i/o (VPN) overhead.

John W. Colby

On 3/30/2015 11:56 PM, Jim Lawrence wrote:
> Hi John:
>
> If you are thinking of going Cloud based, it may be an idea to try SSL. OpenSSL is an excellent super secure VPN. It works on both Linux and there is now a Windows version. I use Linux version all the time to connect to my servers from anywhere.
>
> https://www.youtube.com/watch?v=FZyUX-LZHts
>
> Jim
>
> ----- Original Message -----
> From: "John W. Colby" <jwcolby at gmail.com>
> To: "Discussion concerning MS SQL Server" <dba-sqlserver at databaseadvisors.com>, jwcolby at gmail.com
> Sent: Monday, March 30, 2015 9:40:14 AM
> Subject: Re: [dba-SQLServer] Schemas for separation of clients?
>
> I am actually talking about other databases, not the "database from hell".
>
> I have been following your AWS thread with interest.  How do you get the
> public IP address?  I would think that would make the speeds much better
> than trying to tunnel in using Hamachi.  How do you deal with security /
> hack attempts?  Having that public facing IP has always put me off.
>
> John W. Colby
>
> On 3/30/2015 10:47 AM, Gustav Brock wrote:
>> Hi John
>>
>> I have just set up a micro instance at AWS hosting SQL Server 2008 Express and a public IP address.
>> Then I can attach it directly via ODBC.
>> We have only a 15 Mbit/s download, so speed is slower than from our in-house SQL Servers but fully acceptable.
>>
>> At takes a little to set up the access to AWS. I skipped the VPN offering but I may add that later when I find out how to do it.
>>
>> My need is very far from yours with a maximum record count per table of some hundred thousands so I may never meet the issues you are dealing with.
>>
>> /gustav
>>
>> -----Oprindelig meddelelse-----
>> Fra: dba-SQLServer [mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af John W. Colby
>> Sendt: 30. marts 2015 15:35
>> Til: Discussion concerning MS SQL Server; jwcolby at gmail.com
>> Emne: Re: [dba-SQLServer] Schemas for separation of clients?
>>
>> Are you guys hitting the BE with an Access FE?  If so how are you linking to the tables?
>>
>> I am running Access linked tables over the internet to SQL Server on a privately hosted VM / SQL Server.  It runs just fine, though a bit slow.  OK very slow given how I design things.  But it does work. In order to do it however I set up a single user / password out in SQL Server, then come into the VM using Hamachi.  I think that Hamachi is one of the causes of the slowness, though since that is the only way in for me, it is tough to know exactly.
>>
>> Just wondering what you are up to and how to implement it.
>>
>> John W. Colby
>>



More information about the dba-SQLServer mailing list