SQL Tūmau Express: Tāuta, Whirihoranga,

Hoki te whakahaere o tetahi pūnaha centralized Me te tūmau e taea hapai i tono i te pūmanawa kiritaki. karere Instant, whatunga pāpori, kaute me ngā pūnaha pūtea - tenei katoa he aronuinga raraunga noa. SQL - etahi momo o ngā tūmau whakamahia ki te rokiroki me te tiki mōhiohio. E hāngai ana ratou i runga i te Reo Uinga Whakaraupapa. E whakarato ana i te whai wāhi tere, me te pono ki ngā raraunga rongoa rite te pai kia rite ki to ratou tukatuka "i runga i te ngaro".

Tūmau SQL Microsoft: he whakaahuatanga iti

Tenei hua - he otinga noa e taea ki a koe tohatoha hohoro te pätaka haumaru mō te rokiroki me te tukatuka nui o ngā mōhiohio. Ka taea te whakamahi i te tūmau ki te waihanga papa matotoru hoki Tukutuku, tono, me ētahi atu momo o te pūmanawa motuhake. I roto i te meka, tetahi pae i roto i te tukutuku nui i roto i te tahi mau toe fanau'i whakamahi Tūmau SQL.

Tikiake i te putanga hou o te hua ki te rā i te pae tukutuku mōhiohio Microsoft.

Rāhuitanga SQL Tūmau Express i runga i ngā rauemi pūnaha

kia kōrero hoki tatou i te wahi e pā ana ki te whakaritenga. Hei tīmata, me ki te whakarite mahi ore o SQL Tūmau Express he tika ki te kawe i te whirihoranga pūnaha ki te puka e whai ake nei:

• Ka taea te whakamahi pūnaha whakahaere e rua moka-64 32- ko Windows i te aho;
• kia tere pūtukatuka nui ake i 1.4 GHz;
• RAM - e kore e iti iho i 512 MB, pai 2 GB;
• mokowā free i runga i te puku mārō - 2.2 GB.

Tāuta: te whaktauiratia me mita

Whakaaro ki te kia mahi ki Tūmau Windows 2008 R2 pūhara. Kei te riro te reira e SQL Server Express 2012 te kua tīkina me he reira i runga i te rorohiko. Whakahaere i te pūtāuta ko reira e tika ana rite kaiwhakahaere. Ko te "Tāuta tētahi tauira hou o te SQL Tūmau» matapihi e puta, he mea e tika ana ki te tīpako i te tūemi.

Next, ka te whakaaetanga raihana kia te aroaro ki te e hiahia ana koe ki te pānui i me te farii i te reira. Na, ki te kitea te whakahōunga i, o nāianei i te kau, ka ākina reira kia ki te tāuta me ratou. Tenei e taea te mahi, a ka, i roto i te tūmau kua tāuta.

I roto i te wāhanga i muri o te kōwhiringa o wāhanga ka kia te aroaro. Ka taea e koe te waiho nga mea katoa kia rite ki te whakaaro e te pūtāuta. Here me whakapūtā koe te ara mo te kōnae.

Next, ka tirohia te pūtāuta ahakoa he rite hoki tāutanga te pūnaha. A kia tupu te reira e ka kitea e ia, kahore he wāhanga o te Anga .NET 3.5. Na whai koe wa ki te faaea ka doustanovit pūmanawa e hiahiatia ana.

Tāuta i te Anga .NET i runga i te rorohiko

Kei tēnei wāhanga he huinga o whare pukapuka me ngā tono ki te mahi ki ngā tūmau, me ngā ratonga whatunga. Te kore e kore e taea e te reira rere pūnaha me ngā hōtaka maha. A kia roto i nga putanga kotahi te huinga.

I roto i te Tūmau Windows 2008, meatia tenei e i roto i te "Tīmata" tahua, ka "Whakahaere". I roto i te hanganga rakau i runga i te maui ki te tīpako Āhuatanga, a i roto i te matapihi matua - Tāpiri Āhuatanga. faauru te pūnaha koutou hoki hi'opo'ai te e wātea ana mō te tāutanga wae. I roto i tenei āhuatanga, paanga i roto i te mōkihi katoa o te Anga NET. I roto i te taahiraa i muri mai tūtohu mahue tatou te checkmarks taunoa. Ka waiho i te atamira whakamutunga he matapihi ki te karere e pā ana ki te tāutanga angitu o te wae.

Hoki ki SQL Tūmau Express 2012

mutu tāutanga i Ture Tāutanga Hipanga. Me ki kia whakahoutia te reira. kite koe i "Whirihoranga Tauira". Here taea e koe te whakapūtā te ingoa me kia atu tautuhinga noho rite he. Na, i roto i te "Whirihoranga Tūmau" Kei te pai mahue ki te uara taunoa.

"Pūkaha pātengi raraunga Whirihoranga" ka whakahere ki te tāuta i te aratuka motuhēhēnga. He pai ki te whiriwhiri aratau whakauru. E tano ia tapao e kore e taea te huri i tēnei tautuhinga i roto i te heke mai.

Next, faauru te pūtāuta koe ki te tīpako i tētahi huarahi ki te "tāuta anake" ranei "Tāuta me Whirihoranga." Ka taea te whakamana ā whirihoranga kaupae, na kia tīpako koe i te tūemi tuatahi.

I runga i te mata i muri e taea tika koe pēhi "Next", rite ki reira whakapumautia te he tohu, ahakoa ki te tonoa ngā mōhiohio hapa ki Microsoft. A te mutunga - he matapihi ki te karere e pā ana ki te tāutanga angitu.

whakatikatikanga

I muri i te tāutanga he oti, e hiahia ana koe ki te mahi i etahi whirihoranga tuatahi o SQL Tūmau Express.

Tuatahi e hiahia ana koe ki te whakaturia te uru tūmau. Ki te mahi i tenei, haere ki "Tīmata" tahua, ka "katoa Papatono», MS SQL Tūmau Express me Whirihoranga Utauta.

Ka whakatuwhera te matapihi i roto i te rōpū maui, e kua he hanganga rakau o te huānga. Tona moni i roto i te tūemi "Kawa mō SQLEXPRESS». Ka puta te matapihi tika ki te huānga tauroto. Me tīpako e koe TCP / IP. Na roto i Taui monoa tēnei ki Whakahohea te tahua horopaki taunoa, tahuri e te i runga i.

Next, tīpako i te āhuatanga kawa. Ko te ripa tuarua he te IP-wāhitau o te tūemi IPAll. Kei reira nga uara o TCP Port, e me te whakakapi i te 1433.

Na e hiahia ana koe ki te hoki ki te rakau huānga. Tenei te mea e tika ana ki te whiriwhiri i te runga - Ratonga Tūmau SQL. Me tika koe ki te tirohia mēnā kei te rere i te pūtirotiro Tūmau SQL. Ki te kore, whai koe ki te pāwhiri whawhati-runga taua mea, ka whakaturia te Aratau Tīmata aratau tikanga tīmatanga "Aunoa". Na tīmata te pūtirotiro tūmau ā mā te pēhi i te tahua pokatata Tīmata.

Na to tatou ki te tīmata anō te SQL-tūmau rawa.

Whirihora karere taumai

Ki te mahi i tenei, whakaturia te pātūahi i roto i te Windows i te tikanga hou mo te tūmau. Ki te whiwhi ki enei tautuhinga, ka taea e koe na runga i te "Tīmata" - "Ngā Utauta Whakahaerenga". Ka rite ki mua, te rōpū whiriwhiri maui-ringa - te rakau huānga, tika - tautuhinga. E ti'a ia tatou ki te kitea te tūemi Araroto Ture. A i roto i te "Hohenga" - "Ture New." Ko te "Ruānuku Tatūnga". Here e hiahia ana koe ki te tīpako i te Port. Next, te kawa - tau TCP, me tauranga - 1433. I roto i te Mahi Hipanga whakaturia te Tukua te hononga. Na, i te mata o te Kaiwhakamahi Profile, e hiahia ana koe ki te whakapūtā te ture o te rohe kapinga. Ka taea e koe te whakaturia katoa pouakataki e toru.

Na te atamira whakamutunga - i te ingoa tāutanga. He pai ki te tautuhi mārama, me te wātea.

I muri ka te ture e whirihora ka ora, he mea e tika ana ki te kia e te mahi i te reira, me te rere.

hononga kiritaki

I roto i te tikanga ki te hono atu ki te tūmau i roto i te SQL Tūmau Managment Studio, e hiahia ana koe ki te waihanga i tētahi tikanga mo te pātūahi, i roto i te ara ano kua rite kua whakakitea hoki SQL Tūmau Express. Ko te rerekētanga anake ko e te kawa ko te UDP, me te tauranga - 1434.

Ki te kore e mahi i te hononga, ka hiahia koe ki te tiro i te āhuatanga Hononga ki SQL Tūmau Managment Studio. Here kōwhiringa hiahia "Tukua tūhononga mamao ki tenei tūmau." kia tohua te reira i whakauru. Na kei te haere nga mea katoa ki te mahi.

mutunga

whakakitea te tuhinga ki te tāuta me te whirihora i te MS SQL Tūmau Express 2012. I a koutou e taea te kite, e kore te mea pera matatini te tukanga, me te mahi ki a reira e te viivii ore o tetahi kaiwhakamahi rorohiko. Tāuta i te iti rawa e taea e paku rerekē i te putanga whakaahuatia i roto i te tuhinga i te rongonui Tūmau SQL 2008 Express, ko te tikanga, a ka waiho i te taua i te hātepe.

Ka rite ki te hua, ka whakaturia ake wātea tūmau me te mahi o te whare putunga raraunga, me te whakahaere i te pūnaha ki a ratou.