Linux Server Machine

Popular Linux Server Machine-Buy Cheap Linux Server Machine lots

Select a SQL Server 2017 image from the search results.

Click Create.

On the Basics blade, fill in the details for your Linux VM.

Click OK.

On the Size blade, choose a machine size. For development and functional testing, we recommend a VM size of DS2 or higher. For performance testing, use DS13 or higher.

To see other sizes, select View all. For more information about VM machine sizes, see Linux VM sizes.

Click Select.

On the Settings blade, you can make changes to the settings or keep the default settings.

On the Summary page, click OK to create the VM.

Note

The Azure VM pre-configures the firewall to open the SQL Server port 1433 for remote connections. But to remotely connect, you also need to add a network security group rule as described in the next section.

Configure for remote connections

To be able to remotely connect to SQL Server on an Azure VM, you must configure an inbound rule on the network security group. The rule allows traffic on the port on which SQL Server listens (default of 1433). The following steps show how to use the Azure portal for this step.

  1. In the portal, select Virtual machines, and then select your SQL Server VM.
  2. In the list of properties, select Network interfaces.
  3. Then select the Network Interface for your VM.
  4. Click the Network security group link.
  5. In the properties of the Network Security Group, selct Inbound security rules.
  6. Click the +Add button.
  7. Provide a Name of "SQLServerRemoteConnections".
  8. In the Service list, select MS SQL.
  9. Click OK to save the rule for your VM.

Connect to the Linux VM

If you already use a BASH shell, connect to the Azure VM using the ssh command. In the following command, replace the VM user name and IP address to connect to your Linux VM.

You can find the IP address of your VM in the Azure portal.

If you are running on Windows and do not have a BASH shell, you can install an SSH client, such as PuTTY.

  1. Run PuTTY.
  2. On the PuTTY configuration screen enter your VM's public IP address.
  3. Click Open and enter your username and password at the prompts.

Configure SQL Server

  1. After connecting to your Linux VM, open a new command terminal.
  2. Set up SQL Server with the following command.

    sudo /opt/mssql/bin/mssql-conf setup

    Accept the License and enter a password for the system administrator account. You can start the server when prompted.

Startech StarTech.com 2 Port PCI Express SuperSpeed USB 3.0 Card Adapter with UASP - SATA PEXUSB3S24
Personal Computer (Startech)
  • Form Factor: plug-in card
  • Interface (bus) Type: PCI Express x1
  • Ports: USB 3.0 x 2
  • Add 2 SuperSpeed USB 3.0 ports with SATA power to your PCI Express-enabled PC
  • Compatible with HP Pro 6300 / Lenovo ThinkCentre M72e
  • 2 Port PCI Express USB 3.0 Card Adapter w/ UASP / 2Port USB 3.0 Controller Card
  • USB 3 PCIe Card / PCIe USB 3.0 Card
  • SATA Powered USB 3.0 PCI Express Card / PCI Express USB 3.0 Expansion Card w/ UASP
  • Add USB 3.0 Ports to a Desktop
  • Two Port 5 Gbps USB 3.0 UASP Card includes a Low Profile/half-height bracket
Corsair Corsair XMS2 DDR2 4GB (2x2GB) PC2-6400 800MHz 240-Pin Dual Channel Desktop Memory
CE (Corsair)
  • Industry Leading Lifetime Warranty
  • Latency of 5-5-5-18 for maximum reliability and performance
  • These modules allow users to experience outstanding memory performance and stability.
  • The XMS brand family is Corsair’s mainstream line of performance memory
  • Two matched 2GB modules for use with AMD and Intel DDR2 systems
Canon Canon PIXMA MG3022 Wireless Inkjet All-in-One Printer, 8 ipm Black, 4800x600 Color, - Print, Copy, Scan
Office Product (Canon)
  • COMPACT SIZE - The PIXMA MG3022 is a great little All-In-One printer that s just the right size and has all the right features. Like canon print app, Auto Power...
  • ENHANCED WIRELESS CONECTIVITY - With its built in Wifi feature you will enjoy fast & easy hassle free prints from any of your favorite mobile devices, smartphone...
  • HYBRID INK SYSTEM - EXCEPTIONAL PRINT QUALITY - This printing device is known for its great quality prints for an affordable price with sharp black & whites...
  • EASY CONVENIENT & QUICK SETUP - You don t have to be a computer and technology scientist in order to set up this printer, it comes with an easy to follow instructions...
  • GENERAL SPECIFICATIONS - Print Speed (up to): Black: ESAT: Approx.8.0 ipm Color: ESAT: Approx. 4.0 ipm -- Number of Nozzles: Color: 960 / Pigment Black: 320 / Total:...

Related posts: