Ungayifaka kanjani i-SQL Server ku-Ubuntu bethu

Joaquín García

Imizuzu ye-2

I-SQL Server

Ukufika kweSQL Server ye-Microsoft kwenze abasebenzisi abaningi baphelelwa yisineke futhi bafuna ukuzama iMicrosoft entsha ye-Ubuntu kodwa ungakhohlwa ukuthi isathuthuka futhi hhayi ukusetshenziselwa okokukhiqiza.

Kunoma ikuphi kukhona ithuba lokufaka i-SQL Server ku-Ubuntu bethu ngaphandle kokwenza izinto ezingajwayelekile, sidinga kuphela ukuba no-Ubuntu kwikhompyutha yethu kanye nokuxhumeka kwe-inthanethi ukufaka iSQL Server ye-Microsoft.

Ukufakwa kwe-SQL Server

Amaseva weMicrosoft asengabanikazi, ngakho-ke kulokhu ukufaka iSQL Server esinayo okokuqala ngibe nemininingwane yokulanda amafayela, ngakho-ke sivula ukuphela ku-Ubuntu bese senza okulandelayo:

sudo su

Ukufaka izimvume zomlawuli weqembu.

curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -

Ngalokhu sicela ubufakazi bokukwazi ukukwazi landa amafayela avela endaweni yokugcina iMicrosoft. Manje sibhala okulandelayo:

curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list & /etc/apt/sources.list.d/mssql-server.list

Futhi ngalokhu sizokwengeza okugcinwa kweMicrosoft kwimithombo yethu.list ngakho-ke Ubuntu izohlala ivuselela le software.

exit
sudo apt-get update
sudo apt-get install -y mssql-server

Ukucushwa Kweseva ye-SQL

Lokhu kuzoqala ukufakwa kwe-SQL Server. Kepha manje kufanele siyilungiselele. Ngenxa yalokhu sizosebenzisa umbhalo owenzelwe yiMicrosoft ngale njongo. Ngakho-ke sibhala okulandelayo:

sudo /opt/mssql/bin/sqlservr-setup

Uma sesiqedile, kufanele nje sebenzisa insiza ukuze i-SQL Server iqale kuseshini ye-Ubuntu, noma ngabe noma nini lapho siqala Ubuntu kuzoqala ngokuzenzekelayo, ngakho-ke sibhala okulandelayo ukuqala iseva:

systemctl status mssql-server

Isiphetho

Njengoba ukwazi ukubona, inqubo yokufaka ilula, inqubo elula esingayisebenzisa sonke, kepha khumbula ukuthi i-SQL Server isakhiwaYinguqulo yokubuka kuqala futhi ingadala izinkinga, ngakho-ke sincoma ukuthi yenziwe emshinini obonakalayo futhi uma ukwazi ngezinsizakalo ezimbalwa, kungcono, ngoba ingadala ukwehluleka okubucayi. Ungakhohlwa.


Shiya umbono wakho

Ikheli lakho le ngeke ishicilelwe. Ezidingekayo ibhalwe nge *

*

*

  1. Ubhekele imininingwane: Miguel Ángel Gatón
  2. Inhloso yedatha: Lawula Ugaxekile, ukuphathwa kwamazwana.
  3. Ukusemthethweni: Imvume yakho
  4. Ukuxhumana kwemininingwane: Imininingwane ngeke idluliselwe kubantu besithathu ngaphandle kwesibopho esisemthethweni.
  5. Isitoreji sedatha: Idatabase ebanjwe yi-Occentus Networks (EU)
  6. Amalungelo: Nganoma yisiphi isikhathi ungakhawulela, uthole futhi ususe imininingwane yakho.

  1.   Luis kusho
    kwenza iminyaka 7

    Nina bafana nishintsha kakhulu muva nje.

    Phendula uLuis
  2.   UDaniel Castillo kusho
    kwenza iminyaka 7

    Ingabe ingafakwa ku-16.04 32bit?

    Phendula uDaniel Castillo
  3.   Orlando nuñez kusho
    kwenza iminyaka 7

    Ngabe ukhona kini okwazile ukuthola i-phpmyadmin ukuthi isebenze ku-Ubuntu 16.04 nge-apache2, php7.0 ne-mysql-server ???

    Phendula u-Orlando Nuñez
    1.    isithandwa kusho
      kwenza iminyaka 7

      Yebo, ukufaka i-LAMPP noma nge-XAMPP

      Phendula ubumnyama
      1.    UJoseph Barrios kusho
        kwenza iminyaka 7

        Ngiyazi ukuthi ayihlangene kakhulu nayo kepha ngidinga isiphakamiso.
        Ngine-xampp, futhi ngifaka i-phpmyadmin kanye ne-postgres pgadmin, lapho ngibhala i-localhost / phpmyadmin inhlawulo ivula umphathi we-sql bd, noma kunjalo lapho ngibhala i-localhost / phppgadmin (lena kungaba yiyo evela kuma-postgres) ayingivuleli ngilandela

        Iphutha 404

        localhost
        I-Apache / 2.4.23 (Unix) OpenSSL / 1.0.2j PHP / 5.6.24 mod_perl / 2.0.8-dev Perl / v5.16.3

        Noma iziphi iziphakamiso zokuthi uzolungisa ini?

        Phendula uJose Barrios
  4.   UJuanjo kusho
    kwenza iminyaka 7

    Akusizi ukuphinda amakhasi wokufundisa we-MS (https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-ubuntu#install-sql-server) beshiya izikhala ezifanayo abazishiya

    Phendula uJuanjo
  5.   joas kusho
    kwenza iminyaka 7

    Ngiyazi ukuthi ungamisa inkonzo nge
    i-systemctl yeka mssql-server
    kepha ngiyilungiselela kanjani ukuthi ibe yincwajana
    akuqali lapho ama-boot system?

    Phendula kuma-joas
  6.   Jorge kusho
    kwenza iminyaka 7

    Sawubona, ngifuna ukuyifaka ku-Ubuntu 17.04, kepha ngithola iphutha lokuthi ayikwazi ukuthola okugcinwa yi-MS.

    Phendula uJorge
  7.   UJose lujan kusho
    kwenza iminyaka 4

    Sawubona, esivele ifakiwe, ngingawenza kanjani imibuzo ye-sql bese ngixhuma? Sengivele ngifuna imininingwane ku-sqlcommand kepha ngithola iphutha elilandelayo:
    "/ Opt / mssql-tools / bin / sqlcmd: iphutha ngenkathi kulayishwa imitapo yolwazi eyabiwe: libodbc.so.2: ayikwazi ukuvula ifayela lezinto ezabiwe: Alikho lelo fayela noma umkhombandlela"

    Ukulawula,
    ULujan

    Phendula uJose Lujan