WordPress.com



Introduction This topic provides a walkthrough of how to install SQL Server vNext CTP1 on Ubuntu 16.04.System RequirementUbuntu 16.04 64 bits desktop edition. Downlod the ISO file using this link and click Download button.Oracle VirtualBox 5.1.8 or latest version (free edition) Download exe file (windows) using this link and click ther linkCreating Ubuntu Virtual MachineOpen Oracle Virtual Manager and click New from menubar.This will open a new windows and fill the following information.Name: SQLLinuxType: Select Linux from drop down box.Version: Ubuntu (64-bit) from drop down box.Click Next button Memory size selection extend the memory at least 4 GB (4096 MB) and click NextHard disk selection choose “Create a virtual hard disk now” and click CreateHard disk file type selection chooses “VDI (Virtual Disk Image)” and click Next.Storage on physical hard disk section choose Fixed size and click Next.File Location and size section make sure size should at least 20 GB and click Create.At this point the virtual machine storage will be created and this step may take 2-3 minutes. we will see disk initializing progress with below screenshot.Once the step is completed, the virtual machine created successfully and this new virtual machine will be shown to the left side of the VirtualBox console.Click the virtual machine from VirtualBox console and click the setting in menu-bar. This will open a new window has every possible setting of virtual machine.left2679700Choose Storage option and on the right side Click Controller: IDE and click Empty (CD Icon). Click the browse (CD icon) to browse the Ubuntu ISO file.Find the “Ubuntu-16.04.1-desktop-amd64.iso” file and click Open.Confirm the location label is point to correct “Ubuntu iso” file. Click OK This will close the setting page and bring to summary page. Verify “iso file” location, memory and storage are correct and accurate.Select the virtual machine from virtual machine console and click Start This will boot up the virtual machine with I selected SO file and it will show welcome sign.14. Click “Ubuntu install” button.Don’t select any option to “Preparing to install Ubuntu” page. keep it default and click Continue.Chose “Erase disk and install Ubuntu” option and click “Install Now”.Pop up window will prompt with “write the changes to disk” for conformation. Click Continue.Choose the time zone and click ContinueChoose “Keyboard layout” and keep default to English (US) and click ContinueEnter the super user name and password.User name: dbasPassword: xxxxxxxChoose “Log in automatically” and click ContinueThis will start installing Ubuntu and this step may take 10 minutes. During this time several screen will change.Once the installation is completed “Restart Now” message will be appeared and click “Restart Now”When virtual machine startup again installation medium remove message will appear and press Enter in where the virtual machine.Continue to startup…YES virtual machine is created and Ubuntu desktop will be seen to virtual machine. (Definitely looks better than Windows 10)Click the search icon and type terminal. Terminal icon will show in search panel and click Terminal.Install curl utilityOpen terminal window (shown how to get Terminal in previous step) and run following command. sudo apt-get install –y curlAsk for dbas user password. Enter dbas user password (created during installing Ubuntu) and press enter.Once curl utility is installed and following messages will be seen in terminal window.Install SQL ServerChange user context to super user and run following command to terminal window and press entersudo su This will switch current use to super-user mode and root@dbas will be seen to user context in terminal console.Run the following command to terminal window to Import the public repository GPG keyscurl | apt-key add -If command run successfully, check “OK” message to terminal window.Run following command in terminal window to register the Microsoft SQL Server Ubuntu repository. curl > /etc/apt/sources.list.d/mssql-server.listIf command run successfully, following output will be seen to terminal window.Exit the super-user model by typingexit root context will be disappeared and only dbas will see to console. Update apt repository by running following command.sudo apt-get updateIf update is successful, terminal window will display “Reading package lists … Done”Run following command to download as well as Install mssql server repository and press enter sudo apt-get install -y mssql-serverFollowing messages will display to terminal window once the download and install is completed.Also “please run the SQL Server setup” will show at the end of message.Run sqlserver setup file with following command and press entersudo /opt/mssql/bin/sqlservr-setupType YES to accept the terms license. Enter sa password. (xxxxxxx)Re-confirm sa password Also confirm SQL Server startup and select [y]Confirm “Do you wish to enable SQL Server to start on boot?” select [y] and press enter.Installation may take 2-3 minutes to complete. If no error during installation “Setup completed successfully” message will be end in terminal window.Check the sql services status. using the following command.systemctl status mssql-serverAll SQL services run status will be seen in terminal window and confirm following message is displaying. Active: active (running) Install tools on UbuntuSwitch to super-user mode with following command.sudo suRun following command in terminal window to Import the public repository GPG keys.curl | apt-key add -If command run successfully OK message will be shown in terminal window.Run the following command to register the Microsoft Ubuntu repositorycurl > /etc/apt/sources.list.d/msprod.listOnce the registration is successful similar output will be seen.Exit super-user mode with following command exitUpdate SQL tools to Ubuntu repository by running the following command.sudo apt-get update Once the update is completed in terminal window, “Reading package list .. Done” messages will be shown.Install mssql-tools by run the following command.sudo apt-get install mssql-toolsDuring installation process there will be few conformations. “Do you want to continue?” type [y] and press enter.Select YES in the “Configuring mssql-tools” license term and press enter.Select “YES” to “Configuring msodbcsql” license term.The following messages will be shown in the terminal window once the successful installation is completed.Open port 1433 in firewall by run the following commandsudo ufw allow 1433/tcpoutput will show Roles updatedSQL INSTALLATION IN UBUNTU IS COMPLETED ... CONGRATUALATIONS Login to SQL serverRun the following command to login SQL Server in sqlcmd utility. sqlcmd -S localhost -U SA -P '<YourPassword>' Change database context to master later query to all databases name in the server. At very beginning ONLY system databases (master, model, msdb, tempdb) will return from the statement.Run few SQL Statements like create a new database, table and later add few rows to table. Query the table to return the rows that are inserted.WE ARE GOOD NOWSQL IS INSTALLED AND WE CAN EXTRACT DATATHANK YOU FOR READING THIS. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download