1 B mn H Thng Thng Tin Khoa CNTT

ng dn ci t:
SQL Server 2005 Express
c lc
1 Gioi thiu ......................................................................................................................... 2
2 Ci dt SQL Server 2005 Express Edition .................................................................... 2



2 B mn H Thng Thng Tin Khoa CNTT
1 Gii thiu
SQL Server 2005 Express l h quan tri co so du liu thu nho tu phin ban SQL Server
2005 cua Microsoft v duoc cung cp min ph.
Nguoi dng c th tai v phin ban SQL Server 2005 Express trn trang web cua
Microsoft tai dia chi:
http://www.microsoft.com/Sqlserver/2005/en/us/express-down.aspx
Tuy nhin, phin ban ny chi bao gm h quan tri co so du liu m chua c chuong trnh
h tro quan l SQL Server 2005 Express bng giao din. Do d, nguoi dng cn tai thm
chuong trnh SQL Server Management Studio Express cung tai dia chi trn.
2 Ci t SQL Server 2005 Express Edition
2.1 Ci t SQL Server 2005 Express
1. Chay tp tin ci dt SQLEXPR32.EXE (hoc SQLEXPR.EXE cho ban Windows
64 bits).

2. Nhn Next


3 B mn H Thng Thng Tin Khoa CNTT

3. Nhn Next

4. Bo chon Hide advanced configuration options. Nhn Next.




4 B mn H Thng Thng Tin Khoa CNTT
5. Nhn Next.

6. Chon Default instance nu mun giu tn th hin co so du liu mc dinh nhu
trong text box bn duoi. Tuy nhin, khi ci dt nhiu phin ban h quan tri co so
du liu SQL khc nhau ln h thng (c mt phin ban SQL Server 2005 Express
duoc ci dt sng trong lc ci dt Visual Studio) nn tai buoc ny, chng ta c
th chon Named instance v dt tn lai d d nho (v du: SQL2005Expess). Sau
d, nhn Next.

7. Nhn Next.


5 B mn H Thng Thng Tin Khoa CNTT

Nu khng mun SQL Server duoc chay tu dng khi mo my, bo chon o SQL
Server o trn.
8. Tai buoc ny, nu chon Windows Authentication Mode, chng ta chi c th
dng nhp SQL Server bng ti khoan Windows. Thng thuong, chng ta s chon
Mixed Mode (Windows Authentication and SQL Server Authentication) d c
th vua su dung cch dng nhp bng ti khoan Windows vua c th dng nhp
bng ti khoan c trong co so du liu.
Nhp mt khu cho ti khoan sa (ti khoan quan tri ton b h thng, c quyn
thuc thi tt ca cc chuc nng cua h thng).

9. Chon thit lp default collection cua co so du liu.



6 B mn H Thng Thng Tin Khoa CNTT
Nhn Next.

10. Nhn Next.

11. Nhn Next.


7 B mn H Thng Thng Tin Khoa CNTT

12. Nhn Install.

13. Nhn Next.


8 B mn H Thng Thng Tin Khoa CNTT

14. Nhn Finish.

15. Cu hnh SQL Server 2005 Express: thng thuong, chuong trnh s truy xut vo
co so du liu SQL Server 2005 qua giao thuc TCP/IP. Do d, cn phai bt giao
thuc TCP/IP cho th hin co so du liu vua tao.
Mo SQL Server Configuration Manger: Start Menu | Programs | Microsoft SQL
Server 2005 | Configuration Tools | SQL Server Configuration Manger.
Bt TCP/IP nhu hnh bn duoi:


9 B mn H Thng Thng Tin Khoa CNTT

Khoi dng lai SQL Server bng cch nhn nt trn thanh cng cu.

2.2 Ci t SQL Server Management Studio Express
Sau khi tai v SQL Server 2005 Management Studio, chay chuong trnh ci dt
SQLServer2005_SSMSEE.msi.
1. Nhn Next.


10 B mn H Thng Thng Tin Khoa CNTT

2. Chon nhu hnh v. Nhn Next.

3. Nhn Next.



11 B mn H Thng Thng Tin Khoa CNTT
4. Nhn Next.

5. Nhn Install.

6. Nhn Finish.