sqlexpress_2008 Installation and Configuration

A: Pre-installation system environment preparation;

1. Installation of netfx20sp2_x86 and ndows Installer 4.5 (windowsserver2003-kb942288-v4-x86)

Two: Install sqlexpress_2008

2.1 Environmental Testing

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M01/88/33/wKioL1frx2jAg46TAAHkS2S6cLE810.png-wh_500x0-wm_3 -wmp_4-s_3005852347.png "style=" Float:none; "title=" 1.png "alt=" Wkiol1frx2jag46taahks2s6cle810.png-wh_50 "/>

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M01/88/37/wKiom1frx2mQk-8uAAFbslFPTq8949.png-wh_500x0-wm_3 -wmp_4-s_876465503.png "style=" Float:none; "title=" 2.png "alt=" Wkiom1frx2mqk-8uaafbslfptq8949.png-wh_50 "/>

2.2 Consent Agreement

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M00/88/33/wKioL1frx2mDuDUaAAF__BVRMyQ136.png-wh_500x0-wm_3 -wmp_4-s_1149570701.png "style=" Float:none; "title=" 3.png "alt=" Wkiol1frx2mduduaaaf__bvrmyq136.png-wh_50 "/>

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M02/88/37/wKiom1frx2qxI7b7AAFRrFj8zHA571.png-wh_500x0-wm_3 -wmp_4-s_2661596343.png "style=" Float:none; "title=" 4.png "alt=" Wkiom1frx2qxi7b7aafrrfj8zha571.png-wh_50 "/>

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M01/88/33/wKioL1frx2uiBuaXAAFRFXz1xAE711.png-wh_500x0-wm_3 -wmp_4-s_583428369.png "style=" Float:none; "title=" 5.png "alt=" Wkiol1frx2uibuaxaafrfxz1xae711.png-wh_50 "/>

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M02/88/37/wKiom1frx2uwkE-SAADIUHTcKgw590.png-wh_500x0-wm_3 -wmp_4-s_751405801.png "style=" Float:none; "title=" 6.png "alt=" Wkiom1frx2uwke-saadiuhtckgw590.png-wh_50 "/>

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M02/88/33/wKioL1frx2zBwQOUAADcjiXpXWY177.png-wh_500x0-wm_3 -wmp_4-s_140979289.png "style=" Float:none; "title=" 7.png "alt=" Wkiol1frx2zbwqouaadcjixpxwy177.png-wh_50 "/>

2.3 Default instance Name

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M00/88/37/wKiom1frx2zQ4l_xAADWbg2Zp2A175.png-wh_500x0-wm_3 -wmp_4-s_4278750578.png "style=" Float:none; "title=" 8.png "alt=" Wkiom1frx2zq4l_xaadwbg2zp2a175.png-wh_50 "/>

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M00/88/33/wKioL1frx22xNawtAADPTEmX-CA437.png-wh_500x0-wm_3 -wmp_4-s_2213805765.png "style=" Float:none; "title=" 9.png "alt=" Wkiol1frx22xnawtaadptemx-ca437.png-wh_50 "/>

2.4 Select Run Service Account

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M00/88/37/wKiom1frx23iOJCYAADVaYaH8WA420.png-wh_500x0-wm_3 -wmp_4-s_2911524021.png "style=" Float:none; "title=" 10.png "alt=" Wkiom1frx23iojcyaadvayah8wa420.png-wh_50 "/>

2.5 Setup SQL account and Windows System account login are supported

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M02/88/33/wKioL1frx27gZNKPAADi_QTUo1E105.png-wh_500x0-wm_3 -wmp_4-s_827785190.png "style=" Float:none; "title=" 11.png "alt=" Wkiol1frx27gznkpaadi_qtuo1e105.png-wh_50 "/>

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M01/88/37/wKiom1frx26CWEfSAADkuiutyT4812.png-wh_500x0-wm_3 -wmp_4-s_733165661.png "style=" Float:none; "title=" 12.png "alt=" Wkiom1frx26cwefsaadkuiutyt4812.png-wh_50 "/>

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M01/88/37/wKiom1frx27BW5cEAADFOqOG3aA087.png-wh_500x0-wm_3 -wmp_4-s_2752910157.png "style=" Float:none; "title=" 13.png "alt=" Wkiom1frx27bw5ceaadfoqog3aa087.png-wh_50 "/>

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M00/88/33/wKioL1frx2-xTsVAAADhAQlULeg681.png-wh_500x0-wm_3 -wmp_4-s_2926167472.png "style=" Float:none; "title=" 14.png "alt=" Wkiol1frx2-xtsvaaadhaqluleg681.png-wh_50 "/>

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M02/88/37/wKiom1frx2_jhiXCAACxvzSo8Mg655.png-wh_500x0-wm_3 -wmp_4-s_1584542604.png "style=" Float:none; "title=" 15.png "alt=" Wkiom1frx2_jhixcaacxvzso8mg655.png-wh_50 "/>

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M01/88/33/wKioL1frx3DBtXfhAADG6Ach4Dk316.png-wh_500x0-wm_3 -wmp_4-s_3791005263.png "style=" Float:none; "title=" 16.png "alt=" Wkiol1frx3dbtxfhaadg6ach4dk316.png-wh_50 "/>

The installation is successful.

Three: Configuring SQL 2008 snooping

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M02/88/34/wKioL1fryvfiRl6_AAGT9nZlAPM197.png-wh_500x0-wm_3 -wmp_4-s_3190759794.png "style=" Float:none; "title=" opens the Configuration tool alt= "Wkiol1fryvfirl6_aagt9nzlapm197.png-wh_50"/>

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M00/88/38/wKiom1fryvjzszVOAACH2WAM91E119.png-wh_500x0-wm_3 -wmp_4-s_2383542334.png "style=" Float:none; "title=" Stop Service "alt=" Wkiom1fryvjzszvoaach2wam91e119.png-wh_50 "/>

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M00/88/34/wKioL1fryvjzuu_sAACLs4_dijw195.png-wh_500x0-wm_3 -wmp_4-s_2489694499.png "style=" Float:none; "title=" Modify TCP/IP Properties "alt=" wkiol1fryvjzuu_saacls4_dijw195.png-wh_50 "/ >

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M01/88/38/wKiom1fryvmz8ffMAABxvLSbweU729.png-wh_500x0-wm_3 -wmp_4-s_2932570627.png "style=" Float:none; "title=" modifies the port and enables "alt=" Wkiom1fryvmz8ffmaabxvlsbweu729.png-wh_50 "/>

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M01/88/34/wKioL1fryvnwmHMUAABWE8pFTKA429.png-wh_500x0-wm_3 -wmp_4-s_3127916060.png "style=" Float:none; "title=" Start Server "alt=" Wkiol1fryvnwmhmuaabwe8pftka429.png-wh_50 "/>

Last Telnet 192.168.41.51 1433 test listening port

Four: Configure the Client Connection tool

4.1 Install DOTNET35_SP1 patch tool, download Sqlmanagementstudio_x86_chs.exe Client Connection tool

4.2 Installing the Sqlmanagementstudio_x86_chs.exe Client Connection tool

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M02/88/34/wKioL1frzV2AeusFAAFB7Y68ICU118.png-wh_500x0-wm_3 -wmp_4-s_3774693544.png "style=" Float:none; "title=" Environment Detection "alt=" wkiol1frzv2aeusfaafb7y68icu118.png-wh_50 "/>

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M01/88/38/wKiom1frzV_iAtFZAAJMqNZcifk561.png-wh_500x0-wm_3 -wmp_4-s_3752660584.png "style=" Float:none; "title=" Windows PowerShell failed "alt=" wkiom1frzv_ Iatfzaajmqnzcifk561.png-wh_50 "/>

Download Windows PowerShell patch Windowsserver2003-kb926140-v5-x86-chs.exe after installation re-detection

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M02/88/34/wKioL1fr1D2xp1i9AAG1rWeNYPU681.png-wh_500x0-wm_3 -wmp_4-s_168208219.png "style=" Float:none; "title=" 1.png "alt=" Wkiol1fr1d2xp1i9aag1rwenypu681.png-wh_50 "/>

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M01/88/34/wKioL1fr1D7hmOzFAAFEjVYtYHY959.png-wh_500x0-wm_3 -wmp_4-s_3969725186.png "style=" Float:none; "title=" 2.png "alt=" Wkiol1fr1d7hmozfaafejvytyhy959.png-wh_50 "/>

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M00/88/38/wKiom1fr1D7xxMZRAAEdocS9Pac515.png-wh_500x0-wm_3 -wmp_4-s_4023554194.png "style=" Float:none; "title=" 3.png "alt=" Wkiom1fr1d7xxmzraaedocs9pac515.png-wh_50 "/>

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M00/88/34/wKioL1fr1D-wgoc_AAEQzUE9-_A892.png-wh_500x0-wm_3 -wmp_4-s_4093837651.png "style=" Float:none; "title=" 4.png "alt=" Wkiol1fr1d-wgoc_aaeqzue9-_a892.png-wh_50 "/>

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M01/88/38/wKiom1fr1EDwtuYkAAC5Xj0qIk8980.png-wh_500x0-wm_3 -wmp_4-s_4252762088.png "style=" Float:none; "title=" 5.png "alt=" Wkiom1fr1edwtuykaac5xj0qik8980.png-wh_50 "/>

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M01/88/34/wKioL1fr1ECx-xmMAAC6FfVXxm0484.png-wh_500x0-wm_3 -wmp_4-s_383656322.png "style=" Float:none; "title=" 6.png "alt=" Wkiol1fr1ecx-xmmaac6ffvxxm0484.png-wh_50 "/>

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M02/88/38/wKiom1fr1EDAV15DAADGQuLqYtI044.png-wh_500x0-wm_3 -wmp_4-s_2301737233.png "style=" Float:none; "title=" 7.png "alt=" Wkiom1fr1edav15daadgqulqyti044.png-wh_50 "/>

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M00/88/38/wKiom1fr1IyDGNr5AAE2__swfm0045.jpg-wh_500x0-wm_3 -wmp_4-s_1940829734.jpg "title=" 8.jpg "alt=" Wkiom1fr1iydgnr5aae2__swfm0045.jpg-wh_50 "/>

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M00/88/34/wKioL1fr1L_DSfyxAADWDufoKZ0400.png-wh_500x0-wm_3 -wmp_4-s_3998218437.png "style=" Float:none; "title=" 9.png "alt=" Wkiol1fr1l_dsfyxaadwdufokz0400.png-wh_50 "/>

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M00/88/38/wKiom1fr1L_yDMxaAADABBJrNFE603.png-wh_500x0-wm_3 -wmp_4-s_2605524817.png "style=" Float:none; "title=" 10.png "alt=" Wkiom1fr1l_ydmxaaadabbjrnfe603.png-wh_50 "/>

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M01/88/38/wKiom1fr1MDivztKAADHXhxhkhk841.png-wh_500x0-wm_3 -wmp_4-s_3803380703.png "style=" Float:none; "title=" 11.png "alt=" Wkiom1fr1mdivztkaadhxhxhkhk841.png-wh_50 "/>

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M02/88/34/wKioL1fr1MDxh7jjAAC7aF30Bf8962.png-wh_500x0-wm_3 -wmp_4-s_1314043118.png "style=" Float:none; "title=" 12.png "alt=" Wkiol1fr1mdxh7jjaac7af30bf8962.png-wh_50 "/>

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M01/88/34/wKioL1fr1Q2AMt7qAADXmg43Z3E739.png-wh_500x0-wm_3 -wmp_4-s_1155838482.png "title=" 18.png "alt=" Wkiol1fr1q2amt7qaadxmg43z3e739.png-wh_50 "/>

V: Test Connection database

5.1 Windows Identity Login to verify database connections

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M02/88/34/wKioL1fr1rihqT3GAAE_OcGa6k8316.jpg-wh_500x0-wm_3 -wmp_4-s_2389902288.jpg "style=" Float:none; "title=" 1.jpg "alt=" Wkiol1fr1rihqt3gaae_ocga6k8316.jpg-wh_50 "/>

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M00/88/38/wKiom1fr1riDXlkhAACqjbpyVj0858.jpg-wh_500x0-wm_3 -wmp_4-s_690547642.jpg "style=" Float:none; "title=" 2.jpg "alt=" Wkiom1fr1ridxlkhaacqjbpyvj0858.jpg-wh_50 "/>

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M00/88/38/wKiom1fr1rnA3JCrAAC2LL2gTO4862.jpg-wh_500x0-wm_3 -wmp_4-s_2142191063.jpg "style=" Float:none; "title=" 3.jpg "alt=" Wkiom1fr1rna3jcraac2ll2gto4862.jpg-wh_50 "/>

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M02/88/34/wKioL1fr1rmic8BzAACzwlWFtjc348.jpg-wh_500x0-wm_3 -wmp_4-s_3367430806.jpg "style=" Float:none; "title=" 4.jpg "alt=" Wkiol1fr1rmic8bzaaczwlwftjc348.jpg-wh_50 "/>

5.2 SQL Server Identity login to verify database connections

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M01/88/38/wKiom1fr1rnA_AaFAACWVZFW_44554.jpg-wh_500x0-wm_3 -wmp_4-s_3602567076.jpg "style=" Float:none; "title=" 5.jpg "alt=" Wkiom1fr1rna_aafaacwvzfw_44554.jpg-wh_50 "/>

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M00/88/34/wKioL1fr1rriXQ9NAACpAxegl90886.jpg-wh_500x0-wm_3 -wmp_4-s_4113305994.jpg "style=" Float:none; "title=" 6.jpg "alt=" Wkiol1fr1rrixq9naacpaxegl90886.jpg-wh_50 "/>

This article is from the "httpblog.mvp-610163.com" blog, make sure to keep this source http://341103.blog.51cto.com/331103/1857527

sqlexpress_2008 Installation and Configuration