Connecting to Client's Servers via VPN

ByAdam Gilmore Updated on

Here at Dimodelo Solutions we often work remotely. With today’s technology, we can use Virtual Private Network (VPN) technology to securely connect into our client’s network and access their Servers, as if we were there on site. All that is required is the appropriately authorized Server credentials (User Name and Password) and a VPN Server configured at the client site. Today, it is very easy to set up a VPN Server on a Windows Server. VPN functionality is built into Windows Server 2008. For more information about VPNs visit this link, which has a good basic explanation of VPN Servers. For information about setting up Windows 2008 VPN Server visit this link.

A VPN allows us to connect directly to the Servers using client tools like SQL Server Management Studio, Visual Studio, Business Intelligence Design Studio and Dimodelo Data Warehouse Studio.

It’s as if we are sitting in the Clients offices. With tools like Skype and Join Me etc, the tyranny of distance is no longer an issue.

Adam Gilmore

Adam Gilmore is a Data Architect with 19 years' experience in the Data field. He writes for Dimodelo and develops courses covering Data Analysis to Data Architecture.

Similar Posts

|

Defining a Dimension with Smart Keys

ByAdam Gilmore

While conventional wisdom (and Kimball) says that using meaningful identifiers for surrogate keys is a bad idea, there are some exceptions where it makes sense. Typical examples include: Calendar. An example of a Calendar smart key is – year, month, day e.g. 20110721. A DateTime value can be converted to this date format using this statement convert(char(8),date, 112)….

|

Override SSIS package configurations through an SQL Server 2008 R2 Job

ByAdam Gilmore

If you thought you could override an SSIS package’s configurations when running it through an SQL Server 2008 R2 Job… think again. In the SQL Server Job Step Properties dialog, there is a  Configuration tab that allows you to specify configuration files. The logical assumption is that this will override existing configurations with the same…

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.