Search This Blog & Web

Sunday, May 28, 2017

Changing and verifying SQL Server Status from Linux (Ubuntu)

Recently we learn how to install SQL Server on Linux and how to use it. As a database administrator we need to check current database status as well as need to enable and disable it on demand. In the following post we will learn how to check current database status and change it using Linux command shell.

Once you install MSSQL Server in Ubuntu, You need to restart Linux machine in order to finish installation. SQL Server engine will automatically start as “Active” after restart. In the following post we will learn how to verify and change its status like Start, Stop, Disable and Enable.
1-      Verify running status for MSSQL Server using following command
“ systemctl status mssql-server”
You can see the status in green color.

2-      We can change MSSQL Server status using following sudo command
“sudo systemctl stop mssql-server”
To verify current database status you will repeat same step as above “ systemctl status mssql-server”.

3-      Using following command We can disable MSSQL Server engine using following sudo command
“sudo systemctl disable mssql-server” and can verify by executing as “ systemctl status mssql-server”.

4-      To enable MSSQL Server engine we can using same sudo command
“sudo systemctl enable mssql-server” and can verify by executing as “ systemctl status mssql-server”

5-      Finally MSSQL Server is up and active.



Thursday, May 25, 2017

SQL Server on Linux step 3: Linux (Ubuntu ) Installing SQL SERVER vNext

In my previous post we learn how to install Linux through Oracle Vitual box that you can found from following link

After finishing your Ubuntu installation, you are ready to install SQL Server. You can install it through Ubuntu or your host windows using command line. Installing from Windows you need to install putty easily available on internet. Install it and connect it using Network IP and run all steps mentioned below. 
I am installing it through Ubuntu plate form and following are the steps for that

1-      Execute “sudo apt-get update”
2-      Execute “sudo apt-get upgrade” is an optional step


3-      Run curl command to import GPG key. GPG keys also provide cryptographic privacy and authentication. If curl command is not installed on this machine so we need to run the suggested command to install the curl command first.


4-      After successful installation of curl, we can import key using following command and add it using sudo command.
“curl https://packages.microsoft.com/key/microsoft.asc | sudo apt-key add –“


5-      Due to some network and internet problem I was unable to register key directly from Microsoft site. So if key download fails download key from mentioned path. https://packages.microsoft.com/key/microsoft.asc you can find it in downloads, Open the file, Save it as .asc file and open it in terminal


6-      From the terminal windows register key from the following command
“ sudo apt-key add microsoft.asc”


7-      After successfully registering GPG key download mssql server from following path.
“curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list | sudo tee /etc/apt/sources.list.d/mssql-server.list”


8-      You can check the folder and rights to the downloaded file by executing ls -lrt
“ls –lrt /etc/apt/sources.list.d”


9-      After executing all run “sudo apt-get update” before installing SQL Server.


10-   Now you are ready to install SQL Server now. Start SQL Server installation using following command.
“sudo apt-get install –y mssql-server”


11-   Installation will continue as we can see installation percentage. It will take some time depending on internet connection. Installation will complete with the config setup message.


12-   As mentioned in the message, To complete SQL Server setup run following command
“sudo opt/mssql/bin/mssql-conf setup”
It will prompt license agreement message.


13-   After completing above step Microsoft will ask for administrator password and will start SQL Server. During my installation I set password as “vSqlserver2017”. In the end you will get Setup completed successfully message.


14-   You have successfully completed MSSQL Server installation. On restarting you linux server, you can check SQL Server status by executing following command.


15-   We need to Install SQL Server tools by using following command. Using wget we need to download and copy prod.list on sources.list.d path.


16-   On getting permission message I am unable to copy on given path. I used same path as I did to register key for SQL Server.
17-   I downloaded prod.list file and copy it to sources.list.d


18-   Opening root as file manager by entering following command
“sudo nautilus”


19-   Following root path will open


20-   Reaching at sources.list.d path copyà paste prod.list as follows


21-   It is recommended to run get-update command before and after any installation and then start installing tools by following command
“sudo apt-get install mssql-tools –y”


22-   Installation will start once all required data will be downloaded.



After completing installation we are going to perform basic SQL Server queries using linux Ubuntu command prompt.

23-   SQL Server is active and running. You can connect SQL Server using following command “sqlcmd –S (Server name) –U (username) –P (Password)”


24-   Performing basic SQL Server testing through command prompt.
a.       Create  database
b.      Create Table
c.       Insert data
d.      Query data


Monday, May 15, 2017

SQL Server on Linux step 2: Linux (Ubuntu ) installation using Virtual Box VM

In my previous post we learn how we can get free Virtual machine to install another operating system on our existing windows. We downloaded Oracle virtual Box Virtual Machine and decided to install Linux plate form on it. We downloaded Linux flavor Ubuntu 17.10 64 bit Server .iso image from given link and now we will learn how to install Ubuntu on Virtual Box VM. You can find previous post under following link.



Linux Ubuntu 17.10 installation on Virtual Box VM


1-      From your VM box right click -> on your VM and press “Start” or “Normal Start”.




2-      This will start Ubuntu setup. Load downloaded .iso file and press Start


3-      Setup will load Ubuntu from .iso file. Press Install ubuntu


4-      For installation of new operating system, either select erase and install Ubuntu or manual setup. As I am installing on a separate partitioned drive, I select Erase disk and install Ubuntu.


5-      You will get partition formation message. Press Continue


6-      You need to select time zone settings


7-      Press language for your keyboard.


8-      You need to create username and password. Remember password or write it somewhere for future use. I set password is same as username.


9-      You will setup complete message and need to restart setup.


10-   There are some settings needs to change in order to get better performance from installed virtual machine. Open Ubuntu VM settings. Move to System tab and base memory option under Motherboard.


11-   Switch to Processor tab and change your processor setting.


12-   In left side tab go to Network under Adapter 1 tab.
a.       Enable Network Adapter and select Bridged Adapter to select same network that is on your Windows system.
b.      Under Name: Select Network of wireless setting as required.
c.       Promiscuous Mode: Select Allow All.
d.      Tick Cable connected to work with Bridged Adapter.


13-   Setup your network setting as you setup in your windows machine.
a.       Start your Ubuntu VM and on top right corner. Open setting press Network.
b.      Under Network Proxy press proxy server to connect network server.
c.       Press Apply system wide and restart Ubuntu to apply new changes.


14-   Install putty on your windows system and you can use command prompt to connect Ubuntu from outside Ubuntu.



15-   Starting Linux (Ubuntu). To open root command Press Ctrl+Alt+T to open a terminal window. For security purposes (and to avoid damage), the root user account is locked by default. To safely run commands as root, you should use sudo instead. Enabling the root user can put your system at risk and is not recommended by Ubuntu.


16-   You can use Sudo apt-get update as follows