Now we can connect our GIS software to this new SQL Server. Use this command to connect to the SQL Server sqlcmd -S localhost -U sa -P Create a new Database CREATE DATABASE gisĭone. Source ~/.bashrc Connect to SQL Server and Create a New Database Now we need to add the mssql-tools to Ubuntu PATH echo 'export PATH="$PATH:/opt/mssql-tools/bin"' > ~/.bash_profileĮcho 'export PATH="$PATH:/opt/mssql-tools/bin"' > ~/.bashrc We can install this tool using this command: curl | sudo tee /etc/apt//msprod.list Optionally, we can install mssql-tools that is important for us to connect and manage the SQL Server from the Terminal. Finally, I can install Microsoft SQL Server 2017 on Ubuntu Server 20.04. Now after the installation completes, run this command to configure SQL Server sudo /opt/mssql/bin/mssql-conf setupĬhoose the SQL Server version you wish to installĭone. Mssql-server python-is-python2 python2 python2-minimal python2.7 python2.7-minimalĠ upgraded, 21 newly installed, 0 to remove and 0 not upgraded.Īfter this operation, 1,094 MB of additional disk space will be used. The following NEW packages will be installed: Gdb-doc clang python2-doc python-tk python2.7-doc binutils binfmt-support Python-is-python2 python2 python2-minimal python2.7 python2.7-minimal Libpython2-stdlib libpython2.7-minimal libpython2.7-stdlib libsasl2-modules-gssapi-mit libsss-nss-idmap0 Gdb gdbserver libbabeltrace1 libc++1 libc++1-10 libc++abi1-10 libc6-dbg libcc1-0 libdw1 libjemalloc1 Launching the PMP Web Client Using MS SQL Server as the Backend Database. The following additional packages will be installed: Silent Install Starting and Shutting Down PMP. Now let’s try again to install SQL Server sudo apt update Now install it sudo dpkg -i libssl1.0.0_1.0.2n-1ubuntu5.3_b If the command above does not work, then use this new update: wget First download the package with this command: wget Next, we still need to install one more package: libssl1.0.0. Sudo dpkg -i percona-release_latest.$(lsb_release -sc)_all.debĮnable Repository sudo percona-release setup ps80
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |