Hng dn ci t h qun tr c s d liu Microsoft SQL Server 2005 (Express Edition)

SQL Server 2005 c nhiu phin bn khc nhau, trong bn Express l bn thp nht, c Microsoft cung cp min ph cho ngi dng vi mc ch hc tp v ng dng vo nhng ng dng nh, khng yu cu cao v cc tnh nng khc ngoi vic lu tr v x l n gin.

Yu cu v phn cng v h iu hnh s dng

o o H iu hnh ti thiu: Windows 2000 Service Pack 4; Windows Server 2003 Service Pack 1; Windows XP Service Pack 2 Phn cng: My tnh chip Pentium III 600 MHz tr ln (Cu hnh ngh: Chip 1 GHz hoc cao hn.) Ti thiu 192 MB RAM (Cu hnh ngh: 512 MB RAM.) cng cn trng ti thiu 525 MB

B ci t: o o o o 1. ci t SQL Server 2005 Express, my bn phi c b Windows Installer 3.1 tr ln, download v ti a ch: http://go.microsoft.com/fwlink/?LinkId=46459 2. Microsoft .Net Framework 2.0 H iu hnh 32bit: http://go.microsoft.com/fwlink/?LinkId=55731 H iu hnh 64bit: http://go.microsoft.com/fwlink/?LinkId=55734 3. Bn phi c file ci t SQL Server 2005 Express, c th download min ph t Website ca Microsoft ti a ch: http://www.microsoft.com/downloads/details.aspx?familyid=220549b5-0b07-4448-8848dcc397514b41&displaylang=en 4. SQL Server Management Studio Express: http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B85A0F62BF7796&displaylang=en

Sau khi download v, hy lu vo mt th mc no bt u tin hnh ci t Trong hng dn di y, cc thnh phn trn c tn file ci t ln lt l 7. 8. 9. 10. WindowsInstaller-KB893803-v2-x86.exe: Windows Installer 3.1 dotnetfx.exe: Microsoft .Net Framework 2.0 SQLEXPR.EXE: SQL Server 2005 Express SQLServer2005_SSMSEE.msi: Cng c qun l SQL Server Management Studio Express

Bc 1: Ci Windows Installer 3.1 Nhn vo file WindowsInstaller-KB893803-v2-x86.exe Nhn Next

Chn I agree, nhn Next

Click Finish

Bc 2: Ci Framework 2.0 File ci: dotnetfx.exe

Nhn Finish

My s khi ng li Sau tip tc bc 3

Bc 3: Ci Microsoft SQL Server 2005 Nhn vo file SQLEXPR.EXE

Trn mn hnh tip theo, nh du vo mc: "I accept the licensing terms and conditions", nhn Next

Trn mn hnh tip theo, nhn Install

Nhn Next

Tip tc nhn Next

Trn mn hnh tip theo, b du check m mc "Hide advanced configuration options", nhn Next.

Nhn Next trn mn hnh tip theo

Khai bo Instance name, chn Default Instance (Server Name s trng vi tn my) Nhn Next

Nhn Next trn ca s tip theo

Trn ca s tip theo, chn ch chng thc user o o Windows Authentication Mode: S dng chng thc ca Windows Mixed Mode: Kt hp c chng thc ca Windows v chng thc ca SQL Server

y c th mc nh: "Windows Authentication Mode"

Nhn Next

Nhn Next

Nhn Next

Nhn Next

Click Install bt u ci t

Qu trnh ci t c th mt 5 -> 10 pht

Khi mn hnh bo ci t thnh cng nh hnh di, click Next

Tip tc click Finish

Bc 4: Ci Microsoft SQL Server Management Studio Express: File ci t SQLServer2005_SSMSEE.msi Nhn Next

Click chn "I accept the terms in the license agreement", nhn Next

G tn ngi dng, n v s dng, sau nhn Next

Mn hnh tip theo, nhn Next

Click Install

i trong vi pht

Nhn Finish

n y chng ta ci t xong SQL Server 2005 Express v cc cng c qun l database ca n. T y bn c th bt u s dng cc tnh nng qun l ca h qun tr c s d liu ny ri. Cch thc s dng cc tnh nng ph bin cng nh mt vi tnh nng hay ca n mnh s cp n trong cc bi sau. T kha i din: SQL Server, Ci t SQL Server, SQL Server 2005, hng dn ci t SQL Server 2005
value:T%E1%BB%