How to Setup OpenVPN On Windows Server 2019

What is OpenVPN?

As noted previously in our OpenVPN article, OpenVPN is an open-source Windows software package used to create a secure, site-to-site tunneled VPN connection that provides remote access between two locations. OpenVPN consists of three parts:

• The OpenVPN-AS Server
• The Admin Web Interface/Admin GUI
• The Connection Clients

The OpenVPN Server

The OpenVPN server is the principal element of the OpenVPN-AS Server and manages the main functionality on the backend. Some functionality that is handled within the admin interface includes tunneling, routing, encryption, user management, authentication, and many other features. The OpenVPN server also consists of a WebGUI, which assists with control in several of the fundamental components of the software.

The Main WebGUI Administrative Interface

The main web-based GUI allows for the uncomplicated handling of the OpenVPN server elements. In the WebGUI, an admin can check routing options, privileges, network configurations, user validation, and other parameters. By default, an administrator can connect to the GUIWeb gateway by browsing to https://serverip:943/admin

The OpenVPN Connect Clients

The OpenVPN client is also an important part of the OpenVPN software. This application allows users to link to the VPN server directly in one of three ways. The VPN Client also offers the ability to download the user’s configuration file, which can be duplicated to other OpenVPN clients. The three options are:

• Browser Connect Client – This is the browser-based connection tool for openvpn. The web address for users is https://serverip:943
• OpenVPN Connect Client (Mac) – Simplistic single connection client
• OpenVPN Connect Client (Linux/Windows) – This is the OpenVPN client (which is different from the main openvpn-as program). This software requires a configuration file to work correctly.

#tutorials #openvpn #neural networks

What is GEEK

Buddha Community

Windows Server Setup and Management - Global TechForce

Are you looking for the best outsource it services company for windows server setup? Don’t forget to visit Global TechForce for best and expert IT professionals to install and manage Windows Server 2019. Call us today: (954) 678-2600.

#Windows Server Support #Windows Server Management #Windows Server Setup

Key Differences between SQL Server 2019 for Windows and Linux

Since the release of SQL Server 2017 for Linux, Microsoft has pretty much changed the entire game. It enabled a whole new world of possibilities for their famous relational database, offering what was only available in the Windows space until then.

I know that a purist DBA would tell me right away that the out of the box SQL Server 2019 Linux version has several differences, in terms of features, in regards to its Windows counterpart, such as:

• No SQL Server Agent
• No FileStream
• No System Extended Stored Procedures (e.g. xp_cmdshell)

However, I got curious enough to think “what if they can be compared, at least to some extent, against things that both can do?” So, I pulled the trigger on a couple of VMs, prepared some simple tests, and collected data to present to you. Let’s see how things turn out!

#sql server #sql server 2019 #sql server linux #sql server windows #sql

Azure VM Upgrade To Windows Server 2019

On Azure, if we have a Windows VM and want to upgrade it to the latest version; e.g. Windows server 2019, there is no direct way or available template on Azure to do it smoothly. Though there are a couple of alternatives to achieve this.

• Download the OS drive (c:) VHD on one of your systems, do the in-place upgrade (keeping all the files intact) and post local in-place upgrade, upload the upgraded OS drive (c drive) VHD to the Azure storage account and replace the C drive of your VM.
• Create the new VM all together with the new OS version, install your required software, set up file share user permission & do all the required settings, do the thorough testing and switch the old server domain name to a new one & discard the old server.

All these processes are a time-consuming activity that requires more effort from operations as well as from a testing point of view.

What if we upgrade on Azure windows VM itself (in-place upgrade) with more confidence? Yes, we can and it can be done in 4-6 hours. Keep in mind before upgrading that you need to take the backup of VHDs (OS & data disks), make note of extensions, NIC.

Here is the step by step process to update the IaaS VM Windows server:

• Enable boot diagnostic
• Take Screenshot of Disks from Portal:
• The idea is to get the LUN number and disk names detail.
• Take Screenshot of Disks from Server: The iea is to get the LUN number and disk drive letter mapped to it
• Step 2 & 3 will help us when we are going to create a new VM from disk snapshot if required
• Disable the disk encryption.

1. $vmName =  “<<your-vm-name”
2. $rgName =  “<>”
3. Disable-AzureRmVMDiskEncryption -ResourceGroupName $rgName -VMName $vmName -VolumeType All

• Remove the disk encryption

• Wait for a few minutes until all disks are fully decrypted. Wait time all depends on disk size. Depending on your disk size it may vary. For TBs of data disk, it will take a few hours to fully decrypt the disks.

• Steps to verify:

• Open PowerShell in admin mode

• Command: Get-BitLockerVolume

• If we see VolumeStatus (FullyDecrypted) or EncryptionPercentage (0)

• We are good to proceed with the next step of removing the disk encryption.

#windows server #azure vm #windows server 2019

Python Packages in SQL Server – Get Started with SQL Server Machine Learning Services

Introduction

When installing Machine Learning Services in SQL Server by default few Python Packages are installed. In this article, we will have a look on how to get those installed python package information.

Python Packages

When we choose Python as Machine Learning Service during installation, the following packages are installed in SQL Server,

• revoscalepy – This Microsoft Python package is used for remote compute contexts, streaming, parallel execution of rx functions for data import and transformation, modeling, visualization, and analysis.
• microsoftml – This is another Microsoft Python package which adds machine learning algorithms in Python.
• Anaconda 4.2 – Anaconda is an opensource Python package

#machine learning #sql server #executing python in sql server #machine learning using python #machine learning with sql server #ml in sql server using python #python in sql server ml #python packages #python packages for machine learning services #sql server machine learning services

Windows Server Management

Our Windows server management provide an end to end solution ranging from Windows server setup, configuration, patches, security, troubleshooting, CI/CD to emergency consulting in cases like cyber breach and disaster recovery.

#windows server management #server management services #top server management #top server management services