Install, Update, Remove SqlServer in Linux (Tested in Ubuntu)

Install SQL Server

To install the mssql-server Package on Ubuntu, follow these steps:

  1. Import the public repository GPG keys:
    bashCopy
    curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
    
  2. Register the Microsoft SQL Server Ubuntu repository:
    bashCopy
    curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list | sudo tee /etc/apt/sources.list.d/mssql-server.list
    
  3. Run the following commands to install SQL Server:
    bashCopy
    sudo apt-get update
    sudo apt-get install -y mssql-server
    
  4. After the package installation finishes, run mssql-conf setup and follow the prompts. Make sure to specify a strong password for the SA account (Minimum length 8 characters, including uppercase and lowercase letters, base 10 digits and/or non-alphanumeric symbols).
    bashCopy
    sudo /opt/mssql/bin/mssql-conf setup
    
  5. Once the configuration is done, verify that the service is running:
    bashCopy
    systemctl status mssql-server
    
  6. To allow remote connections, you may need to open the SQL Server TCP port on your firewall. The default SQL Server port is 1433.

Upgrade SQL Server

To upgrade the mssql-server package on Ubuntu, follow these steps:1

  1. Update the apt-get repository lists:
    bashCopy
    sudo apt-get update
    
  2. Re-run the installation command, this will upgrade the specific mssql-server package:
    bashCopy
    sudo apt-get install mssql-server
    

These commands will download the newest package and replace the binaries located under /opt/mssql/. The user generated databases and system databases will not be affected by this operation.

Uninstall SQL Server

To remove the mssql-server package on Ubuntu, follow these steps:

  1. Run the remove command. This will delete the package and remove the files under /opt/mssql/. However, this command will not affect user-generated and system databases.
    bashCopy
    sudo apt-get remove mssql-server
    
  2. Removing the package will not delete the generated database files. If you want to delete the database files use the following command:
    bashCopy
    sudo rm -rf /var/opt/mssql/
    

Offline installation

If your Linux machine does not have access to the online repositories used in the previous sections, you can download the package files directly. These packages are located in the Microsoft repository, https://packages.microsoft.com.

Tip

If you successfully installed with the steps in the previous sections, you do not need to download or manually install the package(s) below. This is only for the offline scenario.

To manually install the SQL Server database engine package for Ubuntu, use the following steps:

  1. Download the .deb database engine package. Find package download links in the package details section of the Release Notes.
  2. Move the downloaded package to your Linux machine. If you used a different machine to download the packages, one way to move the packages to your Linux machine is with the scp commmand.
  3. Install the database engine package. Use the dpkg command. Replace versionnumber with your package version number.
    bashCopy
    sudo dpkg -i mssql-server_versionnumber_amd64.deb
    
  4. Resolve missing dependencies: Typically, there are missing dependencies at this point. If you have access to approved repositories containing those dependencies, the easiest solution is to use the apt-get command:
    bashCopy
    sudo apt-get -f install
    
    Note

    This command completes the installation of the SQL Server package as well.

    In some cases, you might have to manually install the dependencies. Inspect the package’s dependencies with the following command:

    bashCopy
    dpkg -I mssql-server_versionnumber_amd64.deb | grep "Depends:"
    
  5. Complete the SQL Server setup. Use mssql-conf to complete the SQL Server setup:
    bashCopy
    sudo /opt/mssql/bin/mssql-conf setup
    

    *Source –> https://docs.microsoft.com

Advertisements

Images & CSS missing in IIS

It’s a strange problem. Installed the IIS correctly. Running good but suddenly I notice that the Images & CSS are not working. After some googling I found the solution.

  1. Go To Control Panel
  2. Programs & Features
  3. Turn Windows Features on or off
  4. From the tree select ‘Internet Information Service’
  5. World Wide Web Services
  6. Common HTTP Features
  7. Check the Static Content

Here you go. Enjoy!

Cascading dropdown in MVC Razor

Let us have two dropdown list. When one of them is changed the another one will populated. So far I know, the mvc dont have postback method. So, we are going to use javascripts and so on.
Here is our dropdowns. One is populated by the controller with the “DepartmentList” viewdata. And another one by the change event of the first one.
View
Now, add a javascripts change event for first dropdown which will call the “Test” function of the controller “Registration” and the function will return a JSON result. It is also sending a string named “did” consisting the selected value of the dropdown’s. After getting the result, bindings the text and values to the targeted dropdown.
javascripts
At last create a function which will return a JSON type result. Here, the function calls another one to make a list for the selected index. Don’t be afraid about the “clsDesignation”. Its a model class consiting Designation ID and Name.
Continue reading