SQL Server Express: unsembe, kasinthidwe,

Kwa gulu la machitidwe aliyense centralized muyenera Seva kuti angazichite zopempha ku mapulogalamu kasitomala. amithenga Instant, Intaneti, kuwerengera ndi machitidwe ndalama - zonsezi ali deta wamba chithunzithunzi. SQL - mitundu ina ya maseva ntchito kusunga ndi kupeza mfundo. Iwo zochokera Structured akafufuzidwe Language. Limatipatsa mwayi mwamsanga ndipo odalirika deta kusungidwa komanso processing awo "pa ntchentche".

Microsoft SQL Server: ikulongosola ang'onoang'ono

Izi mankhwala - njira ufulu kuti amalola kuti msanga atumiza zapamwamba ndiponso achitetezo kwa osunga ndi processing yambiri zambiri. Seva angagwiritsidwe ntchito kulenga Web makonde, ofunsira, ndi zina mapulogalamu apadera. Ndipotu, malo aliwonse mu ukonde lalikulu ena mulo amagwiritsa SQL yawonongeka.

Koperani Baibulo atsopano a mankhwala chibwenzi ku tsamba lovomerezeka Microsoft.

Zoletsa SQL Server Express pamanambala dongosolo

Tiyeneranso kulankhula pang'ono za zofunika. Kuyamba ndi kuonetsetsa ntchito mosadodometsedwa wa SQL Server Express ndikofunikira kubweretsa dongosolo kasinthidwe ku mawonekedwe zotsatirazi:

• kachitidwe opaleshoni akhoza kugwiritsidwa ntchito 32- 64-bit Windows ku mzere;
• Purosesa liwiro ayenera kukhala woposa 1.4 GHz;
• RAM - osachepera 512 MB, makamaka 2 GB;
• danga ufulu pa galimoto yovuta - 2.2 GB.

Unsembe: ndi subtleties ndi mokoma

Ankaona kuti ntchito ndi Windows Server 2008 R2 nsanja. Amaganiza kuti SQL Server Express 2012 kale dawunilodi ndipo alipo pa kompyuta. Kuthamanga okhazikitsa m'pofunika woyang'anira. The "Kuika nthawi yatsopano SQL Server» zenera limapezeka, m'pofunika kusankha katunduyo.

Kenako, pangano chilolezo Adzaperekedwa limene mukufuna kuwerenga ndi kuvomereza izo. Ndiye, ngati zosintha anali azindikira panopa pa nthawiyo, adzakhululukidwa chinachititsa kukhazikitsa amenewa. Izi zikhoza kutheka, ndipo mu makina ndi anaika kale.

Mu siteji yotsatira kusankha zigawo Adzaperekedwa. Mukhoza kusiya zonse malinga ndi okhazikitsa. Apa muyenera mwachindunji njira kwa owona.

Kenako, okhazikitsa adzakhala kufufuza ngati dongosolo ndi wokonzeka unsembe. Ndipo izo zikhoza kuchitika kuti adzapeza palibe chigawo chimodzi cha .NET M'chilamulo 3.5. Choncho nthawi kaye ndi doustanovit chofunika mapulogalamu.

Khazikitsa M'chilamulo .NET pa kompyuta

chigawo muli m'ndandanda wa malaibulale komanso ofunsira ntchito ndi maseva maukonde ndi ntchito. Popanda sangathamange machitidwe angapo ndi mapulogalamu. Ndipo iliyonse Baibulo limodzi anyamula akonzedwa.

Mu Windows Server 2008, izi zimachitika ndi "Start" menyu, ndiye "Administration". Mu dongosolo mtengo kumanzere kusankha Features, ndi zenera chachikulu - Onjezerani Features. Kachitidwe chimakulimbikitsani chifukwa nkhupakupa zigawo zilipo kwa unsembe. Imeneyi, chidwi mu phukusi lonse la M'chilamulo NET. Mu sitepe yotsatira Mpofunika kusiya checkmarks ndi kusakhulupirika. Chomaliza adzakhala zenera ndi uthenga za unsembe bwino chigawo cha.

Bwererani SQL Server Express 2012

Unsembe anaima pa Gawo unsembe Malamulo. Lifunika watsopano. Inu mukuona "Mwachitsanzo kasinthidwe". Pano mukhoza mwachindunji dzina ndi m'malo ena akhale ali. Ndiyeno, "kasinthidwe Server" bwino kumanzere kwa mfundo ndi zotsatira.

"Kasinthidwe Nawonso achichepere injini" adzadzipereka kukhazikitsa njira kutsimikizika. Ndi bwino kusankha mode losanganikirana. Dziwani kuti angapezeke uku sizingasinthidwe m'tsogolo.

Kenako, okhazikitsa chimakulimbikitsani kusankha njira "kukhazikitsa yekha" kapena "unsembe ndi kasinthidwe." masitepe kasinthidwe angathe kuchitidwa pamanja, choncho muyenera kusankha chinthu choyamba.

Pa nsalu yotchinga lotsatira inu mungakhoze basi tilimbikire "Kenako", monga pali anakhazikitsa mudzichonga, kaya kutumiza zolakwa zambiri kwa Microsoft. Ndipo potsiriza - zenera ndi uthenga za unsembe bwino.

kusintha

Pambuyo unsembe uli wathunthu, muyenera kuchita zina kasinthidwe koyamba SQL Server Express.

Choyamba muyenera anapereka mwayi Seva. Kuchita izi, kupita "Start" menyu, ndiye "Mapologalamu onse», MS SQL Server Express ndi kasinthidwe Zida.

zenera A adzatsegula mu gulu lamanzere lomwe lili ndi dongosolo mtengo wa zinthuzo. Chidwi chake mu item "ndondomeko chifukwa SQLEXPRESS». Zenera bwino adzaoneka ndi zinthu Mathithiŵa. Muyenera kusankha TCP / IP. Kudzera nkhani menyu kusakhulupirika Disbled akusintha chinathandiza, amene anatembenuka pa.

Kenako sankhani katundu protocol. Tabu chachiwiri ali IP-adiresi ya katunduyo IPAll. Lili ndi mfundo za TCP Port, amene ayenera m'malo mwa 1433.

Tsopano muyenera Bwezerani ku mtengo amafotokozera. Apa m'pofunika kusankha pamwamba - SQL Server Services. Inu basi ayenera kufufuza ngati osatsegula ikutha SQL yawonongeka. Ngati ayi, inu muli ndi iwiri Dinani pa izo ndi kuyatsa Start mumalowedwe chiyambi njira mode "Makinawa". Ndipo kuyamba Seva osatsegula pamanja ndi kukanikiza menyu Simungachite Start.

Tsopano tiyenera Chisudzulo Chikuwononga ndi SQL-Seva kwathunthu.

Configuring mauthenga ukubwera

Kuti tichite zimenezi, anaika makhoma oteteza ku Windows lamulo latsopano kwa makina. Kuti tifike makondawa, mukhoza mwa "Start" - "Zida Administrative". Monga mwachizolowezi, kumanzere-dzanja gulu - Mtengo amafotokozera, pomwe - Makonda. Tiyenera kupeza chinthu inbound Malamulo. Ndipo mu "Zochita" - "New Rule." The "dongosolo mfiti". Apa muyenera kusankha Port. Kenako, protocol - TCP, ndi doko chiwerengero - 1433. Kuyendera Action anapereka Amalola kugwirizana. Ndiye, pa nsonga ya mbiri wogwiritsa, muyenera mwachindunji malamulo a m'dera Kuphunzira. Inu mukhoza kuika checkboxes onse atatu.

Ndipo gawo lomaliza - unsembe dzina. Ndi bwino kuti musankhe bwino ndi mwaukhondo.

Pambuyo ulamuliro adzakhala kukhazikitsidwa ndi opulumutsidwa, m'pofunika kuonetsetsa kuti ntchito ndi akuthamanga.

kugwirizana kasitomala

Pofuna kulumikizana ndi makina kudzera SQL Server Managment situdiyo, muyenera kulenga lamulo kwa makhoma oteteza, mu njira yomweyo monga wasonyeza kuti SQL Server Express. Kusiyana komwe kulipo ndi protocol ndi UDP, ndi doko - 1434.

Ngati kugwirizana sachiza, ndiye muyenera kuona katundu kugwirizana kwa SQL Server Managment situdiyo. Apa ndi chidwi njira "Lolani kugwirizana akutali Seva uyu." Kuyenera ticked kulolerana. Tsopano zonse likhoza kugwira ntchito.

Pomaliza

Nkhani anafotokoza mmene kukhazikitsa ndi sintha pa MS SQL Server Express 2012. Monga mukuonera, ndondomeko si choncho zovuta kulimbana nazo pamaziko a wosuta kompyuta. Ikani osachepera wotchuka SQL Server 2008 Express akhoza kukhala wosiyana pang'ono kwa Baibulo anafotokoza m'nkhani, koma njira ndi aligorivimu adzakhala yemweyo.

Chifukwa, Seva kupezeka ndi ntchito ya nyumba yosungiramo katundu deta kudzakhala, ndi kukonza dongosolo nawo.