SQL neeg rau zaub mov Express: Installation, Configuration,

Rau cov koom haum ntawm tej centralized systems xav tau ib tug neeg rau zaub mov uas yuav lis kev thov los ntawm tus neeg software. Instant txib, kev tes hauj lwm, accounting thiab cov nyiaj txiag tshuab - tag nrho cov no muaj ib qho ntaub ntawv schema. SQL - ib co hom servers siv los khaws thiab muab cov lus qhia. Lawv yog raws li nyob rau hauv lub Structured Lus nug lus. Nws muab ib tug ceev thiab txhim khu kev qha kev nkag mus rau muab cov ntaub ntawv raws li tau zoo raws li lawv cov ua "rau tus yoov".

Microsoft SQL neeg rau zaub mov: ib tug me me hauj lwm

Cov khoom no - ib tug free tshuaj uas tso cai rau koj sai sai deploy ib tug ruaj ntseg repository rau khaws cia thiab ua loj nyiaj ntawm cov ntaub ntawv. Cov neeg rau zaub mov yuav siv tau los tsim Web portals, daim ntaub ntawv, thiab lwm yam kev tshwj xeeb software. Nyob rau hauv qhov tseeb, tej qhov chaw nyob rau hauv lub loj heev web nyob rau hauv ib co thawj siv SQL neeg rau zaub mov.

Download tau qhov tseeb version ntawm cov khoom rau hnub tim los ntawm cov nom Microsoft lub website.

Txwv SQL neeg rau zaub mov Express rau chaw muab kev pab

Peb kuj yuav tsum tham ib tug me ntsis txog cov uas yuav tsum tau. Yuav pib thiab los xyuas kom meej uninterrupted lag luam los ntawm SQL neeg rau zaub mov Express yog tsim nyog los coj lub system configuration rau cov nram qab no daim ntawv:

• kev khiav hauj lwm systems yuav siv tau ob qho tib si 32- thiab 64-ntsis lub qhov rais ntawm lub kab;
• Processor ceev yuav tsum ntau dua li 1.4 GHz;
• RAM - tsis tsawg tshaj li 512 MB, dua li 2 GB;
• qhov chaw dawb rau cov nyuaj tsav - 2.2 GB.

Installation: lub subtleties thiab nuances

Xam tias yog yuav tsum tau ua hauj lwm nrog lub qhov rais neeg rau zaub mov 2008 R2 platform. Nws yog assumed tias SQL neeg rau zaub mov Express 2012 yog twb downloaded thiab yog tam sim no nyob rau hauv lub computer. Khiav lub installer nws yog tsim nyog raws li thawj tswj. Lub "Txhim kho ib tug tshiab lom ntawm SQL neeg rau zaub mov» rais uas zoo nkaus li, nws yog tsim nyog los xaiv yam khoom no.

Tom ntej no, daim ntawv tso cai pom zoo yuav tsum muab cob rau uas koj xav mus nyeem thiab txais nws. Ces, yog hais tias tus tshiab nyob sab, tam sim no nyob rau lub caij, nws yuav tsum tau sim hawm caij nyoog rau nruab lawv zoo li. Qhov no yuav ua tau, thiab ces, nyob rau hauv ib tug twb ntsia neeg rau zaub mov.

Nyob rau hauv lub tom ntej no theem ntawm cov kev xaiv ntawm Cheebtsam yuav tsum tau nthuav tawm. Koj ua tau tawm txhua yam mus raws li cov installer. Ntawm no koj yuav tsum qhia kom meej rau txoj kev rau cov ntaub ntawv.

Tom ntej no, lub installer yuav xyuas seb tus system yog npaj txhij rau installation. Thiab tej zaum nws yuav tshwm sim tias nws yuav nrhiav tau tias yog tsis muaj feem ntawm cov .NET moj khaum 3.5. Yog li ntawd koj muaj sij hawm rau kev ncua thiab doustanovit yuav tsum tau software.

Txhim kho lub .NET moj khaum nyob rau hauv lub computer

Qhov no feem muaj ib co ntawm cov tsev qiv ntawv thiab daim ntaub ntawv ua hauj lwm nrog network servers thiab cov kev pab cuam. Yog tsis muaj nws yuav tsis khiav ntau systems thiab cov kev pab cuam. Thiab txhua txhua ib leeg version yuav muaj ib tug set.

Nyob rau hauv lub qhov rais neeg rau zaub mov 2008, qhov no yog ua los ntawm lub "Start" ntawv qhia zaub mov, ces "Administration". Nyob rau hauv tsob ntoo qauv nyob rau sab laug mus xaiv nta, thiab nyob rau hauv lub ntsiab qhov rai - Ntxiv nta. Lub system qhia rau koj rau zuam Cheebtsam yog muaj rau installation. Nyob rau hauv no qhov teeb meem no, xav nyob rau hauv tag nrho cov pob ntawm NET moj khaum. Nyob rau hauv lub kauj ruam tom ntej peb pom zoo tawm hauv lub neej ntawd checkmarks. Cov theem kawg yuav tsum muaj ib tug qhov rais nrog ib tug cov lus hais txog qhov zoo installation ntawm cov tivthaiv.

Rov qab mus rau SQL neeg rau zaub mov Express 2012

Installation nres ntawm cov kauj ruam Installation kev cai. Nws yuav tsum tau tshiaj. Koj saib "Piv txwv li Configuration". Ntawm no koj yuav hais kom meej lub npe thiab lwm qhov chaw cia nyob twj ywm li no. Ces, nyob rau hauv lub "neeg rau zaub mov Configuration" yog zoo tshaj plaws sab laug mus rau lub neej ntawd qhov tseem ceeb.

"Configuration database engine" yuav muaj mus rau nruab ib lub authentication txoj kev. Nws yog zoo dua mus xaiv mixed hom. Nws yog ib nqi sau cia hais tias qhov chaw tsis tau hloov nyob rau hauv lub neej yav tom ntej.

Tom ntej no, lub installer tshoov koj siab kom xaiv ib txoj kev los "nruab tsuas" los yog "Installation thiab Configuration." configuration cov kauj ruam yuav tsum tau manually, yog li ntawd koj yuav tsum xaiv tus thawj yam khoom no.

Rau qhov tom ntej screen koj yuav cia li nias "Tom ntej", raws li muaj yog tsim ib tug zuam, seb puas yuav xa yuam kev ntaub ntawv rau Microsoft. Thiab thaum kawg - ib lub qhov rais nrog ib tug cov lus hais txog qhov zoo installation.

hloov

Tom qab lub installation no tiav lawm, koj yuav tsum tau ua ib co thawj zaug configuration ntawm SQL neeg rau zaub mov Express.

Ua ntej koj yuav tsum tau teem neeg rau zaub mov nkag tau. Ua li no, mus rau "Start" ntawv qhia zaub mov, ces "Tag nrho cov kev pab cuam», MS SQL neeg rau zaub mov Express thiab Configuration cuab yeej.

Ib qhov rais yuav qhib nyob rau hauv rau sab laug vaj huam sib luag, uas muaj ib tsob ntoo cov qauv ntawm lub ntsiab. Nws tus paj laum nyob rau hauv cov yam khoom no "kev cai rau SQLEXPRESS». Muaj txoj cai lub qhov rais yuav tshwm nrog lub nested ntsiab. Koj yuav tsum xaiv TCP / IP. Los ntawm lub ntsiab lus teb ntawv qhia zaub mov neej ntawd hais Disbled hloov mus Enabled, uas yog muab rau.

Tom ntej no, xaiv lub raws tu qauv zog. Qhov thib ob tab muaj tus IP-qhov chaw nyob ntawm qhov khoom IPAll. Nws muaj lub qhov tseem ceeb ntawm TCP Chaw nres nkoj, uas yuav tsum tau hloov los ntawm 1433.

Tam sim no koj yuav tsum rov mus rau lub caij tsob ntoo. Ntawm no nws yog tsim nyog los xaiv lub sab saum toj - SQL neeg rau zaub mov Services. Koj cia li yuav tsum xyuas seb qhov browser yog khiav SQL neeg rau zaub mov. Yog hais tias tsis tau, koj yuav tau ob npaug nias rau nws thiab muab lub Start hom pib txoj kev hom "Tsis Siv Neeg". Thiab pib lub neeg rau zaub mov browser manually los ntawm nias lub shortcut Start ntawv qhia zaub mov.

Tam sim no peb muaj mus pib dua lub SQL neeg rau zaub mov kiag li.

Configuring khoom lus

Ua li no, koj muab cov firewall nyob rau hauv lub qhov rais ib tug tshiab txoj cai rau lub neeg rau zaub mov. Yog xav tau rau cov chaw, koj muaj peev xwm los ntawm lub "Start" - "Administrative cuab yeej". Raws li ib txwm, rau sab laug-tes vaj huam sib luag - lub caij tsob ntoo, txoj cai - qhov chaw. Peb yuav tsum nrhiav yam khoom ntawd Inbound kev cai. Thiab nyob rau hauv lub "tej yam ua" - "Tshiab Txoj Cai." Lub "Teeb Wizard". Ntawm no koj yuav tau xaiv qhov chaw nres nkoj. Tom ntej no, lub raws tu qauv - TCP, thiab chaw nres nkoj tooj - 1433. Nyob rau hauv cov kauj ruam Action teev cov Cia lub kev twb kev txuas. Ces, at the point of Profile Neeg, koj yuav tsum qhia kom meej rau cov kev cai ntawm kev pab them nqi rau thaj tsam. Koj yuav teev tag nrho peb checkboxes.

Thiab lub xeem theem - lub installation lub npe. Nws yog zoo dua kom meej meej thiab siv tau.

Tom qab txoj cai yuav tsum teeb thiab txais kev cawmdim, nws yog tsim nyog kom paub tseeb tias nws ua hauj lwm thiab khiav.

neeg kev twb kev txuas

Nyob rau hauv thiaj li yuav txuas mus rau lub neeg rau zaub mov los ntawm ib tug neeg rau zaub mov SQL Managment Studio, koj yuav tsum tau tsim ib txoj cai tswj rau cov firewall, nyob rau hauv tib txoj kev raws li tau qhia rau SQL neeg rau zaub mov Express. Qhov txawv tsuas yog hais tias lub raws tu qauv yog lub UDP, thiab qhov chaw nres nkoj - 1434.

Yog hais tias lub kev twb kev txuas tsis ua hauj lwm, ces koj yuav tau saib cov khoom txuas rau SQL neeg rau zaub mov Managment Studio. Ntawm no xav xaiv "Cia tej thaj chaw deb txuas rau qhov no neeg rau zaub mov." Nws yuav tsum tau ho xam. Tam sim no txhua yam yog mus ua hauj lwm.

xaus

Cov tsab xov xwm tsom yuav ua li cas rau nruab thiab configure cov MS SQL neeg rau zaub mov Express 2012. Raws li koj tau saib, tus txheej txheem no tsis yog kom complex thiab kam nrog nws los ntawm virtue ntawm tej computer siv. Nruab tsawg kawg yog tus nrov SQL neeg rau zaub mov 2008 Express yuav ua tau txawv me ntsis los ntawm cov version piav nyob rau hauv tsab xov xwm, tab sis cov txheej txheem thiab cov algorithm yuav tau tib yam.

Raws li ib tug tshwm sim, neeg rau zaub mov txaus thiab kev ua tau zoo ntawm cov ntaub ntawv warehouse yuav tau teem caij mus, thiab tswj cov system nrog lawv.