sql2005安裝組件

1. sql server 2005怎麼安裝

1.運行SQL2005安裝文件

2.勾選「我接受條款和條件」。

2. win7鎬庝箞瀹夎卻ql2005

瀹屾暣瀹夎咃細
涓錛氬畨瑁呭強閰嶇疆IIS
sql server 2005闇瑕両IS鐨勬敮鎸侊紝鍦ㄢ滄墦寮鎴栧叧闂瓀indows緇勪歡鈥濋噷鍕鵑変笂Internet 淇℃伅鏈嶅姟錛屽苟涓斿睍寮鍐嶅嬀閫変笂浠ヤ笅鍑犱釜緇勪歡錛
1銆乄eb 綆＄悊宸ュ叿IIS 6 綆＄悊鍏煎規IIS 6 WMI 鍏煎規
2銆乄eb 綆＄悊宸ュ叿IIS 6 綆＄悊鍏煎規IIS 6 鍏冩暟鎹搴撳拰IIS 6閰嶇疆鍏煎規
3銆佷竾緇寸綉鏈嶅姟搴旂敤紼嬪簭寮鍙戝姛鑳紸sp.net
4銆佷竾緇寸綉鏈嶅姟甯歌丠ttp鍔熻兘Http閲嶅畾鍚
5銆佷竾緇寸綉鏈嶅姟瀹夊叏鎬Windows 韜浠介獙璇
紜瀹氬苟瀹夎匢IS銆
浜屻佸畨瑁呮爣鍑嗙増SQL Server 2005
鎸夌収鎻愮ず瀹夎呭嵆鍙
涓夈佸畨瑁匰QL Server 2005 SP3
瀹夎呭畬sql server 2005鍚庯紝鎴戜滑鐧誨綍sql 鏃跺欙紝鍙鑳藉彂鐜扮櫥褰曚笉浜嗭紝鎻愮ず18456 login error,鎴戜滑鐨刟dministrator 涓嶅啀鏈夋潈闄愮櫥褰晄ql server.榪欐槸灝遍渶瑕佷粠寰杞瀹樼綉涓婁笅杞絪ql server 2005 SP3騫跺畨瑁呭埌鐢佃剳涓娿
鍥涖佸惎鐢 SQL Server Browser 鏈嶅姟
鍗曞嚮鈥滃紑濮嬧濓紝渚濇℃寚鍚戔滅▼搴忊濄佲淢icrosoft SQL Server 2005鈥濆拰鈥滈厤緗宸ュ叿鈥濓紝鐒跺悗鍗曞嚮鈥淪QL Server 澶栧洿搴旂敤閰嶇疆鍣ㄢ濄
鍦ㄢ淪QL Server 2005 澶栧洿搴旂敤閰嶇疆鍣ㄢ濋〉涓婏紝鍗曞嚮鈥滄湇鍔″拰榪炴帴鐨勫栧洿搴旂敤閰嶇疆鍣ㄢ濄
鍦ㄢ滄湇鍔″拰榪炴帴鐨勫栧洿搴旂敤閰嶇疆鍣ㄢ濋〉涓婏紝鍗曞嚮鈥淪QL Server Browser鈥濓紝鍦ㄢ滃惎鍔ㄧ被鍨嬧濅腑鍗曞嚮鈥滆嚜鍔ㄢ濋夐」錛岀劧鍚庡崟鍑燴滃簲鐢ㄢ濄
浜斻 鍒涘緩闃茬伀澧欎緥澶
鎵撳紑 Windows 闃茬伀澧欙紝璇峰崟鍑燴滃紑濮嬧濓紝鍐嶅崟鍑燴滆繍琛屸濓紝閿鍏 firewall.cpl錛岀劧鍚庡崟鍑燴滅『瀹氣濄
鐒跺悗鍦 Windows 闃茬伀澧欎腑涓 SQL Server 2005 鍙奡QL Server Browser 鏈嶅姟鍒涘緩渚嬪栥
鍏銆侀厤緗甋QLServer2005 榪滅▼榪炴帴
1錛歋QL Server Configuration Manager -> SQL Server 2005 Services 灝 SQL Server Browser 璁劇疆涓 running錛
濡傛灉娌℃湁Enable鐨勮瘽錛屽彸閿甈roperties -> Service -> StartMode = Auotomatic
娉ㄦ剰錛屽悓鏃跺繀欏繪墦寮SQL Server Browser 鏈嶅姟

2錛 SQL Server 2005 Network Configuration -> Protocols for SQLXPRESS 涓嬪悓鏃朵嬌鐢═CP/IP鍜宯amed pipes

3錛歋QL Native Client Configuration 涓嬪悓鏃朵嬌鐢═CP/IP鍜宯amed pipes

4銆佺櫥闄嗘敼涓烘販鍚堟ā寮:
鎵撳紑manage綆＄悊鍣->浠windows鏂瑰紡榪炴帴騫惰繘鍏ユ暟鎹搴->鍙抽敭鐐瑰嚮浣犵殑鏁版嵁鏈嶅姟鍣->灞炴 ->security>閫変腑Sql server and windows Authentication

5銆佹柊寤篠QL server鏂瑰紡鐨勭敤鎴峰悕鍜屽瘑鐮:
manage綆＄悊鍣 -> security -> 鍙抽敭鐐瑰嚮logins->new login鈥-> 閫変腑sql server authentication ->璁劇疆login name 鍜宲assword(confirm password)浠ュ強 榛樿ょ殑鏁版嵁搴
鏈濂藉幓鎺夆渆nforce password expiration鈥濆墠鐨勫皬閽╋紝鍚﹀垯姣忔＄櫥闄嗛兘瑕佷慨鏀瑰瘑鐮併

娉ㄦ剰 錛 涓瀹氳佸湪User Mapping 欏甸潰涓閫夋嫨璇ョ敤鎴峰瑰簲鐨勬暟鎹搴(鍗充嬌鍓嶉潰宸茬粡閫夋嫨浜嗛粯璁ゆ暟鎹搴)錛屽惁鍒欒繕鏄浼氱櫥褰曚笉涓
濡傛灉闇瑕佷慨鏀規暟鎹搴擄紝蹇呴』鍒嗛厤 db_Owner 瑙掕壊

6銆侀噸鏂板惎鍔ㄦ湇鍔″櫒
鉶界劧緗戜笂濂藉氭枃絝犻兘璇村彧闇瑕侀噸鏂板惎鍔⊿QL鏈嶅姟灝卞彲浠ワ紝浣嗘槸緇忚繃楠岃瘉錛屽繀欏婚噸鏂板惎鍔ㄦ満鍣ㄦ墠琛
In order to get things to work. You might need to completely reboot the server machine after making the changes. There have been reports (thanks P.C.) that starting and stopping the SQL Server and Browser software is not enough.
7銆佷嬌鐢⊿QL Server Configuration Manager 嫻嬭瘯
娉ㄦ剰 錛 Server Name 涓瀹氳 SereverSQLEXPRESS

鍚屾椂榪樿佸湪 Options -> Network protocol 涓閫夋嫨TCP/IP鎵嶈兘欏哄埄鐧誨綍