SQL Server Express: Ukufakwa, okuhlela,

Ngoba inhlangano izinhlelo eyodwa okudingeka iseva abakwazi ukuphatha izicelo ezivela isofthiwe iklayenti. izithunywa osheshayo, ukuxhumana nomphakathi, ezimali kanye nezinhlelo zezimali - konke lokhu has a ezivamile idatha schema. SQL - ezinye izinhlobo amaseva asetshenziselwa ukugcina kanye ukubuyisa ulwazi. Basuke esekelwe Ulimi Lokusebenza Oluhlelekile. Inikeza ukufinyelela okusheshayo nethembeke idatha egcinwe kanye ukucutshungulwa zabo "on the fly".

Microsoft SQL Server: incazelo encane

Lo mkhiqizo - isixazululo khulula elikuvumela ukuba ngokushesha phaka Igumbi ephephile for ukugcina futhi sicubungula esiningi ulwazi. Iseva ingasetshenziswa ukwakha Web Intanethi, izicelo, kanye nezinye izinhlobo ze-software ezikhethekile. Empeleni, noma yimuphi isayithi kuwebhu enkulu kwezinye ukuphindukuzalwa isebenzisa SQL Server.

Landa inguqulo yakamuva komkhiqizo lingelekhulu Microsoft website esemthethweni.

Imikhawulo SQL Server Express ku system imithombo

Kufanele futhi sikhulume kancane mayelana nezidingo. Ukuze uqale futhi ukuqinisekisa ukusebenza ungaphazanyiswa SQL Server Express kuyadingeka ukuletha ukucushwa kwesistimu kufomu elilandelayo:

• wokusebenza ingasetshenziswa kokubili 32- no-64-bit Windows kusukela umugqa;
• isivinini processor Kufanele libe likhulu 1.4 GHz;
• RAM - hhayi ngaphansi kuka-512 MB, okungcono 2GB;
• Isikhala free on the hard drive - 2.2 GB.

Ukufakwa: ubuqili kanye umehluko wemisindo nemiqondo yamagama

Babonwa ukusebenza Windows Server 2008-R2 platform. Kusolwa ukuthi SQL Server Express 2012 isivele ulande likhona kukhompyutha. Qalisa isifaki kubalulekile njengoba umlawuli. I "Ukufaka isenzakalo esisha SQL Server» ewindini elivelayo, kubalulekile ukuba ukhethe into.

Okulandelayo, isivumelwano selayisense izokwethulwa ofuna ukufunda futhi balamukele. Khona-ke, uma izibuyekezo Kwatholakala, zamanje okwamanje, ke uzokwaziswa ukufaka kubo futhi. Lokhu kungenziwa, bese, i-server isivele ifakiwe.

Ngo esigabeni esilandelayo ukukhethwa izingxenye izokwethulwa. Ungakwazi ukushiya konke njengoba kuphakanyiswe isifaki. Lapha kumele icacise indlela amafayela.

Ngokulandelayo, isifaki uzohlola ukuthi uhlelo ilungele ukufakwa. Futhi kungase kwenzeke ukuthi uzothola ukuthi akukho ingxenye i-.NET Framework 3.5. Ngakho une isikhathi ukuba ume bese doustanovit zesofthiwe.

Ukufaka .NET Framework kukhompyutha

Le ngxenye equkethe iqoqo yezincwadi izicelo ukusebenza amaseva zenethiwekhi kanye namasevisi. Ngaphandle-ke asikwazi ukusebenzisa izinhlelo eziningi nezinhlelo. Futhi zonke version olulodwa ingaqukatha iqoqo.

Ngo-Windows Server 2008, lokhu kwenziwa ngokusebenzisa "Qala" imenyu, bese "Isimiso Sokuqondisa". Ngo isakhiwo isihlahla ngakwesokunxele ukukhetha Izici, futhi kuwindo - Engeza Izici. Uhlelo ushukumisa kuwe imikhaza izingxenye ziyatholakala ukufakwa. Kulesi simo, abanesifiso lonke iphakethe of Framework NET. In the isinyathelo esilandelayo sincoma kokushiya checkmarks okuzenzakalelayo. Isigaba sokugcina kuyoba iwindi nge umlayezo mayelana ukufakwa ngempumelelo uphiko.

Buyela SQL Server Express 2012

Ukufakwa sima Isinyathelo Ukufakwa Imithetho. Kumele kuvuselelwe. Uyabona "Ngokwesibonelo Ukucushwa". Lapha ungakwazi ucacise igama nezinye izilungiselelo niyosala njengoba. Khona-ke, esigabeni se- "Iseva Ukucushwa" is kungcono ishiyelwe amagugu okuzenzakalelayo.

"Ukucushwa semininingwane injini" izonikela ukufaka indlela ubuqiniso. Kungcono ukukhetha imodi okuxubile. Kuyaphawuleka ukuthi lokhu kulungiselelwa ayikwazi ukushintshwa esikhathini esizayo.

Ngokulandelayo, isifaki yenza ukuba ukhethe indlela "ukufaka kuphela" noma "Ukufakwa Ukucushwa." ukumiswa izinyathelo engenziwa ngesandla, ngakho-ke kufanele ukhethe into yokuqala.

Esikrinini esilandelayo ungavele cindezela "Okulandelayo", njengoba kukhona Kumiswa umkhaza, kungakhathaliseki ukuthumela ukwaziswa phutha Microsoft. Futhi ekugcineni - ifasitela nge umlayezo mayelana ukufakwa yimpumelelo.

ukulungiswa

Ngemva ukufakwa kuqedile, okudingeka ukwenze ezinye ukucushwa sokuqala SQL Server Express.

Okokuqala udinga ukusetha ukufinyelela iseva. Ukuze wenze lokhu, iya ku "Qala" imenyu, bese uthi "Zonke Izinhlelo», MS SQL Server Express ne Ukucushwa Amathuluzi.

Iwindo lizovula kuphaneli yesokunxele, okuyinto has a isakhiwo nomuthi izakhi. Isithakazelo sakhe kule nto "Izivumelwano for SQLEXPRESS». Iwindi kwesokudla lizovela izakhi ahlanganisiwe. Kufanele ukhethe TCP / IP. Through the okuzenzakalelayo imenyu yengqikithi Disbled izinguquko Inikwe amandla, ukuthi kuvuliwe.

Okulandelayo, khetha izakhiwo olandelwayo. Ithebhu kwesibili IP-ikheli le nto IPAll. Iqukethe amagugu TCP Port, okuyinto kumelwe ithathelwe isikhundla 1433.

Manje udinga ukubuyela kwesihlahla isici. Lapha kubalulekile ukukhetha phezulu - SQL Server Services. Udinga nje hlola ukuthi siphequluli SQL Server. Uma kungenjalo, kufanele chofoza kabili kuso bese usetha Qala Mode isiqalo indlela imodi "Okuzenzakalelayo". Futhi uqale isiphequluli iseva ngesandla ngokucindezela imenyu yamashothikhathi Qala.

Manje kufanele kabusha ngokuphelele SQL-server.

Ilungiselela imilayezo engenayo

Ukuze wenze lokhu, setha firewall kwi-Windows umthetho omusha seseva. Ukuze uthole kulezi zimiso, ungakwazi esebenzisa "Qala" - "Amathuluzi Administrative." Njengenjwayelo, iphaneli sobunxele - kwesihlahla isici, kwesokudla - izilungiselelo. Sidinga ukuthola into kwangaphakathi Imithetho. Futhi "Izenzo" - "UMthetho okusha." I "Isethaphu wizadi". Lapha udinga ukukhetha Port. Ngokulandelayo, umthetho olandelwayo - inombolo TCP, kanye ne-port - 1433. Ngo-Isinyathelo Action ukusetha Vumela uxhumano. Khona-ke, endaweni iphrofayela yomsebenzisi, udinga ukucacisa imithetho Ukusabalala endaweni. Ungasetha zonke amabhokisi amathathu.

Futhi esigabeni sokugcina - igama ukufakwa. Kungcono ucacise ecacile nelula.

Ngemva kokubusa uzobe amisiwe futhi zilondolozwe, kubalulekile ukuze wenze isiqiniseko sokuthi ngokuthi usebenza futhi egijima.

iklayenti uxhumano

Ukuze ukuxhumeka kwiseva ngokusebenzisa SQL Server Managment Studio, udinga ukwakha umthetho lokuvikela, ngendlela efanayo njengoba kuye kwaboniswa i-SQL Server Express. Umahluko owokuthi ukuthi olandelwayo iyona UDP, kanye ne-port - 1434.

Uma uxhumano akusebenzi ke udinga ukubuka izakhiwo Ukuxhunywa SQL Server Managment Studio. Lapha inketho nesithakazelo "Vumela ukuxhumeka kwesilawuli kude kule seva." Kumele kuhloliwe ukufakwa. Manje konke kulapho ezosebenza.

isiphetho

Lesi sihloko sabonisa ukuthi ukufaka futhi ulungiselele MS SQL Server Express 2012. Njengoba ubona, inqubo akuyona uyinkimbinkimbi futhi ubhekane naso ngenxa noma yimuphi umsebenzisi computer. Faka okungenani ethandwa SQL Server 2008 Express kungaba ukuhluka version echazwe esihlokweni, kodwa le nqubo abese algorithm kuyoba okufanayo.

Ngenxa yalokho, i-server ukutholakala kanye nokusebenza ishede idatha azosethwa, futhi uphathe uhlelo nabo.