Skip to main content
Redhat Developers  Logo
  • Products

    Platforms

    • Red Hat Enterprise Linux
      Red Hat Enterprise Linux Icon
    • Red Hat AI
      Red Hat AI
    • Red Hat OpenShift
      Openshift icon
    • Red Hat Ansible Automation Platform
      Ansible icon
    • View All Red Hat Products

    Featured

    • Red Hat build of OpenJDK
    • Red Hat Developer Hub
    • Red Hat JBoss Enterprise Application Platform
    • Red Hat OpenShift Dev Spaces
    • Red Hat OpenShift Local
    • Red Hat Developer Sandbox

      Try Red Hat products and technologies without setup or configuration fees for 30 days with this shared Openshift and Kubernetes cluster.
    • Try at no cost
  • Technologies

    Featured

    • AI/ML
      AI/ML Icon
    • Linux
      Linux Icon
    • Kubernetes
      Cloud icon
    • Automation
      Automation Icon showing arrows moving in a circle around a gear
    • View All Technologies
    • Programming Languages & Frameworks

      • Java
      • Python
      • JavaScript
    • System Design & Architecture

      • Red Hat architecture and design patterns
      • Microservices
      • Event-Driven Architecture
      • Databases
    • Developer Productivity

      • Developer productivity
      • Developer Tools
      • GitOps
    • Automated Data Processing

      • AI/ML
      • Data Science
      • Apache Kafka on Kubernetes
    • Platform Engineering

      • DevOps
      • DevSecOps
      • Ansible automation for applications and services
    • Secure Development & Architectures

      • Security
      • Secure coding
  • Learn

    Featured

    • Kubernetes & Cloud Native
      Openshift icon
    • Linux
      Rhel icon
    • Automation
      Ansible cloud icon
    • AI/ML
      AI/ML Icon
    • View All Learning Resources

    E-Books

    • GitOps Cookbook
    • Podman in Action
    • Kubernetes Operators
    • The Path to GitOps
    • View All E-books

    Cheat Sheets

    • Linux Commands
    • Bash Commands
    • Git
    • systemd Commands
    • View All Cheat Sheets

    Documentation

    • Product Documentation
    • API Catalog
    • Legacy Documentation
  • Developer Sandbox

    Developer Sandbox

    • Access Red Hat’s products and technologies without setup or configuration, and start developing quicker than ever before with our new, no-cost sandbox environments.
    • Explore Developer Sandbox

    Featured Developer Sandbox activities

    • Get started with your Developer Sandbox
    • OpenShift virtualization and application modernization using the Developer Sandbox
    • Explore all Developer Sandbox activities

    Ready to start developing apps?

    • Try at no cost
  • Blog
  • Events
  • Videos

Getting Started with Microsoft SQL Server on Red Hat Enterprise Linux

 

December 14, 2016
Takayoshi Tanaka
Related topics:
Linux
Related products:
Microsoft SQL Server on Red Hat Enterprise LinuxRed Hat Enterprise Linux

Share:

    Microsoft announced SQL Server on Linux public preview, so now you can try SQL Server on your Red Hat Enterprise Linux server. I'll describe how to start SQL Server on RHEL.

    Install and connect with CLI on RHEL

    Microsoft publishes a step-by-step document how to Install SQL Server on Red Hat Enterprise Linux. It's only 7 steps to install and run.

    # systemctl status mssql-server
    ● mssql-server.service - Microsoft(R) SQL Server(R) Database Engine
       Loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; vendor preset: disabled)
       Active: active (running) since Wed 2016-11-16 20:59:33 EST; 1 weeks 1 days ago
     Main PID: 77982 (sqlservr)
       Memory: 753.6M
       CGroup: /system.slice/mssql-server.service
               ├─77982 /opt/mssql/bin/sqlservr
               └─77997 /opt/mssql/bin/sqlservr

    Now you can connect to SQL Server on RHEL. At first, let's connect with sqlcmd. You should have to install SQL Server tools even if you run sqlcmd on the same host as you installed mssql-server package with following the document. First connect to local SQL Server instance.

    $ sqlcmd -S localhost -U SA -P '<YourPassword>'

    When you connect to remote SQL Server instance, specify the host name.

    $ sqlcmd -S example.com -U SA -P '<YourPassword>'

    If SQL Server instance is lisetening the non default port, specify port with ".".

    $ sqlcmd -S example.com,8489 -U SA -P '<YourPassword>'

    After a succeedful login, sqlcmd is waiting for your commands. Here are commands for creating a new database with default setting and using this created database.

    1> CREATE DATABASE testdb;
    2> GO
    1> USE testdb;
    2> GO
    Changed database context to 'testdb'.

    Commands are case insensitive and each command can be ended with ";". Then when input "GO", SQL Server execute commands. So you can execute several commands at one time. Here are the commands for creating a table and inserting a record. This sample executes 3 commands at one time.

    1> CREATE TABLE items (id INT, name NVARCHAR(50), quantity INT);
    2> INSERT INTO items VALUES (1, 'box', 10);
    3> INSERT INTO items VALUES (2, 'ball', 5);
    4> GO
    
    (1 rows affected)
    
    (1 rows affected)
    1> SELECT * FROM items WHERE quantity > 6;
    2> GO
    id          name                                               quantity
    ----------- -------------------------------------------------- -----------
              1 box                                                         10
    
    (1 rows affected)

    Connect from Visual Studio Code

    You can operate SQL Server graphically on Linux with Visual Studio Code and mssql extension. Here is a short video that explains how to install and run mssql extension for Visual Studio code.

    https://youtu.be/NrzHLcBO2F0

     

    To use mssql extension, please set a file type to "SQL".

    Visual Studio Code has an IntelliSense for SQL syntax and sql code snippets.

    Connect from Visual Studio

    If you're using Visual Studio on Windows, you can use this Visual Studio to manage SQL Server on Linux with SQL Server Data Tools(SSDT). Now SSDT can manage not only SQL Server on Windows but also SQL Server on Linux. You can see table definition, execute query and execute other operations graphically.

     

    Takayoshi Tanaka

    About the author:

    Takayoshi Tanaka is the Software Maintenance Engineer of Red Hat. He is mainly in charge of OpenShift, .NET Core on Red Hat Enterprise Linux and Red Hat solutions on Microsoft Azure. He is a Microsoft MVP for Visual Studio and Development Technologies. He writes many articles in his personal blog and web sites, and also he gives many technical session in community events.

    Last updated: November 14, 2023

    Recent Posts

    • Migrating Ansible Automation Platform 2.4 to 2.5

    • Multicluster resiliency with global load balancing and mesh federation

    • Simplify local prototyping with Camel JBang infrastructure

    • Smart deployments at scale: Leveraging ApplicationSets and Helm with cluster labels in Red Hat Advanced Cluster Management for Kubernetes

    • How to verify container signatures in disconnected OpenShift

    Red Hat Developers logo LinkedIn YouTube Twitter Facebook

    Products

    • Red Hat Enterprise Linux
    • Red Hat OpenShift
    • Red Hat Ansible Automation Platform

    Build

    • Developer Sandbox
    • Developer Tools
    • Interactive Tutorials
    • API Catalog

    Quicklinks

    • Learning Resources
    • E-books
    • Cheat Sheets
    • Blog
    • Events
    • Newsletter

    Communicate

    • About us
    • Contact sales
    • Find a partner
    • Report a website issue
    • Site Status Dashboard
    • Report a security problem

    RED HAT DEVELOPER

    Build here. Go anywhere.

    We serve the builders. The problem solvers who create careers with code.

    Join us if you’re a developer, software engineer, web designer, front-end designer, UX designer, computer scientist, architect, tester, product manager, project manager or team lead.

    Sign me up

    Red Hat legal and privacy links

    • About Red Hat
    • Jobs
    • Events
    • Locations
    • Contact Red Hat
    • Red Hat Blog
    • Inclusion at Red Hat
    • Cool Stuff Store
    • Red Hat Summit
    © 2025 Red Hat

    Red Hat legal and privacy links

    • Privacy statement
    • Terms of use
    • All policies and guidelines
    • Digital accessibility

    Report a website issue