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镓嶈兘椤哄埄锏诲綍