MS SQL Server: chokugadza configuration. Version of MS SQL Server. MS SQL Server uye 1C

MS SQL Server ari Database utariri hurongwa Data kubva kuzivikanwa panguva Microsoft. The chigadzirwa iri kwazvo yemakwikwi uye rinoshandiswa senzira guru maindasitiri emakambani, uye vanhu. Iye zvino inoshandiswa nevakawanda Database ukuwo, ari kudiwa chirongwa richikura. Development of chigadzirwa rakatanga muna 1985, uye kubvira ipapo mutsva shanduro anobuda ose gore, Developers kusuma itsva hunoshatisa zvinhu uye kubvisa unneeded okuberekwa.

History, 90s

1989 - chiedza rinowanika wokutanga shanduro usashandisa mudziyo, vagari kukura Microsoft uye boka Ashton-Tate. The chirongwa haana kuwanikwa akatarisirwa mukurumbira. Chekutanga, vakuru vanoshandisa chigadzirwa aizofanira chinja mumwe uchishandisa hurongwa. Chechipiri, pakazotanga vakwikwidzi vaigona kusika SUDB pamwe yakakura functionality.

1990 - goho shanduro MS SQL Server 1,1. The dzichipfekeka nezvaanogona shanduro itsva haana akasiyana zvikuru kubva yaimbovapo (basa pamwe data, iyo SQL mutauro rutsigiro), asi yakawanda zvikanganiso uye zvikanganiso zvave kugadziridzwa.

1993 - anenge panguva imwe chete kwebhuku idzva uchishandisa hurongwa rinowanika SQL Server nokuda Windows NT, yekudyidzana kupfuura vakwikwidzi ayo vaita.

1995 - Exit Microsoft SQL Server 6.0, chigadzirwa rokutanga kubudiswa aparadzane Sybase (makambani izvo Microsoft ari kugadzira Software kubva 1987). The chiziviso rakabudirira chaizvo.

1998 - Las Vegas, mutsva shanduro SQL Server 7.0. kutadza zhinji uye waivako kuvandudzwa zvave kugadziridzwa. Shanduro iyi yakagadzirwa kuti Makambani makuru anoshanda yakawanda mashoko.

History, 2000

1999 - chiedza rinowanika MS SQL Server 2000 Shanduro yakatanga pasi chete uchishandisa hurongwa. Version akanga zvakawanda functionality pane yapfuura mumwe. Pakati pavo, nzira itsva yokusvika nemashoko apore algorithms, injini itsva (iyo inovhura mikana mitsva kukura).

2003 - Kuumba MS SQL Server 2005. kusunungurwa iyi nyore zvikuru Database kukura, rikurumidze basa zhinji Vhoriyamu mashoko uye vakabuda pamwe kugadziriswa zvikanganiso dzaiva yapfuura shanduro.

2008 - The chidzoke rutsva shanduro chirongwa. Kutaura zvazviri, ndizvo zvimwe dzichipfekeka shanduro MS SQL Server 2005. Hapana kuchinja zvikuru shanduro iyi hazvirevi.

chipo

Muna 2010, ivo Mobile shanduro Compact 4.0 pakaziviswa. Version kunoda hapana chokugadza inowirirana platforms dzakadai API, uye NET Pakuumbwa, Visual Studio 2010. Muna 2014, vanoshandisa shanduro itsva dzawanika. Zvizhinji pfungwa unobhadharwa kuti kuwedzera dzingangoitika vhoriyamu Databases (kusvika mazana terabytes), mabhizimisi njere. Panewo kuitika kushuma ari Database nzvimbo. Inotevera shanduro chigadzirwa achanzi SQL Server 2016, uye iye zvino basa kukura kwayo rinoitwa.

kugadzwa

Asati atanga installation, iva nechokwadi kuti kutarisa hurongwa zvinodiwa. Minimum anotevera:

• Processor - Intel (kana enderana) Pentium III 1000MHz kana yepamusorosoro.
• RAM - 512 MB kana kupfuura.
• Hard dhisiki nzvimbo - 20 GB kana kupfuura.

Varumbidzwa maitiro zvinodiwa:

• Processor - Intel Core I7 3000 MHz kana yepamusorosoro.
• RAM 4 GB kana kupfuura;
• Hard dhisiki nzvimbo inofanira kuva pakati 100 GB kana kupfuura.

Kana kombiyuta iwe kuisa program iro, kundosangana pamusoro zvinodiwa, iwe wagadzirira kuisa. Kugadzwa MS SQL Server haisi zvakaoma uye asingauyi wakasiyana kwakajairika kugadzwa zvirongwa musi Windows. Pane zvimwe zvinoita zvinhu zvinorondedzerwa munyaya ino.

1. Kutanga unofanira kumhanya setup faira ave mutarisiri (unofanira tinya faira, kodzero-baya uye sarudza "Mhanyai se mutariri").
2. "Installation Center" hwindo anovhura. It sarudza chikamu "Planning", apo kombiyuta configuration zvinosimbiswa.
3. Kana zvose zvikafamba zvakanaka, mune imwe hwindo, sarudza mashoko "Setup" iri kuitwa pasi, sarudza chinhu chokutanga, izvo isu zvamaronga kuisa Software kana kuwedzera zvimwe zvitsva pazviri.
4. Kupinda inodiwa kiyi (kazhinji zvakanyorwa mubhokisi pamwe software).
5. Gamuchira mashoko zvinorondedzerwa rezinesi, uye akaisa gupa iri rakakodzera nzvimbo.
6. Zvadaro baya "gadza" bhatani.
7. Kusarudza kuurongwa kuisa.
8. Sarudza "Default Somuenzaniso".

For optimum kuita, usashandisa maturusi zvakafanira kuti kugadzira pamberi installation. Chitsauko chinotevera vachatarira sei kuzviita.

kuchinja

Configuring MS SQL Server anoitwa asati installation. Naizvozvo, kana kuisa tafura kungwarira zvikuru, nekuti vamwe configuration nzira chamuchatadza kuchinja pashure installation.

1. Mu "Server Configuration" Takabvunza kuti ndezverudzii rokushumira (zvaitika kana manually). On mabasa ose kunze Full Text Filter Daemon Launcher, sarudza "Auto". Click "Next."
2. In chikamu inonzi "Server Configuration" hapana chikonzero chokuchinja chinhu, isu saka zvakare tinya "Next."
3. Mu "Database Engine Configuration", sarudza "Mixed Mode" uye akaisa Username uye mutariri password. In chete hwindo, enda Tab "Data Directories". Agadzikepo nzira apo mafaira hunowanikwa kuti Database. Click Next.
4. Kusarudza default marongero (wokutanga chinhu).
5. Kukanganisa Mushumo Kurongwa hwindo, sarudza kana chirongwa vachangoerekana kutumira mushumo Microsoft kukanganisa kuvandudza software.

The chokugadza setup kwapera, purogiramu yacho yagadzirira kushanda.

Kugadzira Remote Access

Funga kuisa nzira purogiramu kure kuwana. Nyaya iyi inobatsira kana sangano purogiramu iri yakaiswa pa-computer kupfuura mumwe. Mushure kugadzwa software, MS SQL Server, ita zvinotevera:

1. Mu "Start" Muterere, sarudza "Zvirongwa All"> MS SQL Server> Configuration Kurongwa.
2. Sarudza Protocols nokuti SQLEXPRESS, ipapo TCP / IP.
3. TCP / IP haizoshandisi kuti Enable.
4. Sarudza "Properties", ipapo IP Adresses Tab.
5. Next, sarudza SQL Server Services.
6. Restart kuti SQL Server Services, sarudzai restart.

Next, unofanira dzinoita firewall uchishandisa hurongwa kugamuchira kuuya mashoko. Kuti izvi zvidaro, isu tiite anotevera zviito:

1. Access kuti mashandiro anoita firewall, tinogona kuwana ari Muterere "Start"> "Administrative Tools".
2. Mune Firewall hwindo, sarudza Inbound Rules.
3. Next, sarudza Port.
4. Ipapo iwe unofanira kutaura TCP uye nhamba yacho runoenzanirana, muna 1433 iyi.
5. Danho rinotevera, sarudza Bvumira papi.
6. In danho rinotevera, Profile anofumura mabhokisi zvose.
7. Kusarudza zvakarurama zita.

Kana waita zvakarurama, MS SQL Server Database inogona kumhanya ari kure.

anobatsira zvahungava hwakaita zvakavimbika

Vaiona Software turusi chinhu-software nokururamisira yakaoma. Heino mazano mashoma zvichaita kuti zvive nyore kushanda MS SQL Server Software:

• Nokuremara kana tichishanda pamwe 1C anoshanda kune dzimwe shanduro, saka asati Implementation wegadziriro vanofanira kujekesa nyaya usashandisa interoperability.
• Kana iwe mhanya Database ari akazotevera shanduro, haugoni kumhanya naro mushanduro adarika.
• Kana uchida kutumira Server mabasa akawanda mukati chete kutengeserana, zvakakodzera kutaridzwa kwakarurama mhando mutengapwe. Kuti aite izvi, zvakanaka kuti kuisa chimiro kuti vapiwa kuona kutengeserana: Isai IMPLICIT_TRANSACTIONS Off.
• Kana chirongwa zvinowanisa kukanganisa kana akawanda Databases, zvinoreva kuti Database mafaira haawirirani shanduro. Panyaya iyi, mukuru Database anofanira exchange kuti pashure shanduro.
• Kuti tizive nzira iri Database watinya kurudyi mbeva bhatani uye sarudza "Properties."

pachinzvimbo mhedziso

Pari, ndeyeukama Databases anoshandiswa anenge masangano zvose kuti vanofanira asike makuru uye zviduku zvitoro. The akasiyana kugovera software iyi rinopa Developers kurudziro huru kuti kukura, saka kuti kumiririra nyika yose gore zvakawanda uye nani zvikuru neshanduro yayo software. Kugoverana MS SQL Server uye 1C nyore ichitanga mabhizimisi akawanda kwazvo, achiponesa kubva zvisingakoshi nyaya dzemapepa. Pachayo vaiona Software hazvina kuoma kushandisa uye anobvumira vanoshandisa nokukurumidza kudzidza zvose dzinokosha zviito hunodiwa kushanda pamwe nepurogiramu.