Mokhoa oa ho eketsa mosetsing ho database ea SQL Server
SQL Server 2012 e fana ka lisebelisoa tse fapaneng tsa ts'ireletso tse etselitsoeng ho sireletsa lekunutu, botšepehi le boitsebiso ba lintlha tse bolokiloeng boitsebisong ba khoebo. E 'ngoe ea mesebetsi ea bohlokoa ka ho fetisisa eo basebelisi ba konteraka ba e etsang ke ho kenya ts'ebetsong ho laola mokhoa oa ho fumana litsebo tse fokolang bokhoni ba basebelisi ba ho fumana le ho fetola boitsebiso boitsekareng ntle le haeba ba e-na le khoebo e hlakileng e hlokahalang. Sena se hloka ho khetholla basebelisi ka bomong ka tšebeliso ea li-akhaonto tse sebelisoang ka lebitso.
SQL Server e fana ka mekhoa e 'meli ea ho bopa litlaleho tsa basebelisi ba basebetsi: Ho netefatsa ha Windows kapa mokhoa o tsoakiloeng, o tšehetsang Windows authentication le SQL Server bopaki. Ka mokhoa oa ho netefatsa oa Windows, u fa tumello ea litokelo tsohle tsa li-database ho Windows. Sena se na le molemo oa ho fana ka phihlelo e le 'ngoe ea boitsebiso ho basebedisi le ho nolofatsa ts'ireletso ea ts'ireletso. Ho SQL Server (mode e tsoakiloeng) ho netefatsa, u ntse u ka fa litokelo ho basebelisi ba Windows, empa u ka boela ua etsa li-akhaonto tse teng feela moeling oa server ea database.
Ka kakaretso, ho molemo ho sebelisa mokhoa oa ho netefatsa oa Windows hobane o fokotsa likarolo tse rarahaneng tikolohong ea hau. Ka ho ba le mohloli o le mong oa litlaleho tsa basebelisi, u ka kholiseha haholoanyane hore basebelisi ba tlohang mokhatlong o hlophisitsoe hantle. Leha ho le joalo, hase kamehla ho ka khonehang ho finyella litlhoko tsohle tsa hau tsa bopaki ka li-akhawunti tsa domain name, kahoo ho ka 'na ha hlokahala hore u li tlatse ka lik'haonte tsa sebakeng seo ho etselitsoeng ho sebetsa feela ka marang-rang a SQL Server.
Ho theha akhaonto ea SQL Server 2012
Haeba o hloka ho hlahisa akhaonto ea SQL Server ha u sebelisa bopaki ba mefuta e tsoakiloeng, latela mokhoa ona bakeng sa SQL Server 2012:
- Bula SQL Server Management Studio.
- Tlanya konteraka ea SQL Server moo u batlang ho kena ho kena.
- Bula fensetere ea Tšireletso .
- Tlanya ka ho le letona Foleng ea Li- Logins 'me u khethe Inthaneteng .
- Ho fana ka litokelo ho akhaonto ea Windows, khetha bopaki ba Windows . Ho theha akhaonto e teng feela ho database, khetha bopaki ba SQL Server .
- Fana ka lebitso la ho kena ka lebokose la lebokose. U ka sebelisa konopo ea Browse ho khetha akhaonto e teng haeba u khethile ho netefatsa Windows.
- Haeba o kgethile bopaki ba SQL Server, o tlameha ho fana ka leseli le matla ho lebokose le leng la Motsoako le la Bopaki .
- Etsa mokhoa oa ho etsa li-database tse sa nepahalang le puo bakeng sa akhaonto, haeba ho lakatseha, u sebelisa li-boxes tse theoha tlaase fensetereng.
- Tobetsa OK ho hlahisa akhaonto.
Litlhahiso tsa ho bopa SQL Server 2012 Litlaleho
Litlhahiso ke tsena tseo u lokelang ho li latela ha u bōpa litlaleho tsa basebelisi ba SQL Server 2012:
- Etsa bonnete ba hore u sebelisa phasewete e matla haeba u ntse u bopa ho kena ha SQL Server.
- Ho tlosa akhaonto e teng (ho sebelisa bopaki ba SQL Server kapa tiiso ea Windows), tobetsa ka ho le letona ho akhaonto ea Folda folder, ebe o khetha Tlosa .
- Ho hlahisa akhaonto ha ho bōpe litumello tsa marang-rang . Mohato o latelang oa ts'ebetso ke ho eketsa litumello ho akhaonto.
- Tlhaloso ea SQL Server e fumaneha feela haeba u khethile ho netefatsa mefuta e tsoakiloeng bakeng sa mohlala oa hau oa SQL Server.
- Ho sa tsotellehe hore na u sebelisa mokhoa ofe oa ho netefatsa, etsa bonnete ba hore u iketsetsa litlaleho 'me u hlokomele litokelo tsa mosebedisi Tsamaiso ea ts'ireletso hase eona e ntle ka ho fetisisa ea ditshebeletso tsa ditshebeletso tsa ditshwantsho, empa ke e 'ngoe eo u batlang ho tiisa hore o nepahetse.
Tlhokomeliso: Sehlooho sena se sebetsa ho SQL Server 2012. Haeba u sebelisa SQL Server 2008 pejana, mokhoa ona o ts'oana, empa hlokomela hore Microsoft e khaotse ho tšehetsa SQL Server 2008 ka 2014.