Tataiso ea ho bopa SQL Server 2012 Litlaleho tsa basebelisi

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:

  1. Bula SQL Server Management Studio.
  2. Tlanya konteraka ea SQL Server moo u batlang ho kena ho kena.
  3. Bula fensetere ea Tšireletso .
  4. Tlanya ka ho le letona Foleng ea Li- Logins 'me u khethe Inthaneteng .
  5. 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 .
  6. 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.
  7. Haeba o kgethile bopaki ba SQL Server, o tlameha ho fana ka leseli le matla ho lebokose le leng la Motsoako le la Bopaki .
  8. 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.
  9. 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:

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.