Install and configure SQL Server with SP1
Part1: Create a service startup account
650) this.width=650; "title=" clip_image002 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image002 "src=" http://s3.51cto.com/wyfs02/M02/8B/99/wKioL1hSap_Q-fXUAACL62ceBDI692.jpg "height=" 248 "border=" 0 "/ >
650) this.width=650; "title=" clip_image003 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image003 "src=" Http://s3.51cto.com/wyfs02/M02/8B/99/wKioL1hSaqDyyMEQAABA9vx9XG8248.png "height=" 520 "border=" 0 "/ >
650) this.width=650; "title=" clip_image004 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image004 "src=" Http://s3.51cto.com/wyfs02/M00/8B/99/wKioL1hSaqCjHa5TAAAtQhma9Is176.png "height=" 520 "border=" 0 "/ >
Part2: Installation
650) this.width=650; "title=" clip_image006 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image006 "src=" http://s3.51cto.com/wyfs02/M00/8B/99/wKioL1hSaqGTgtDaAACe4eChP5c158.jpg "height=" 345 "border=" 0 "/ >
650) this.width=650; "title=" clip_image008 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image008 "src=" http://s3.51cto.com/wyfs02/M01/8B/99/wKioL1hSaqKjk4b2AADXp_FGdVA742.jpg "height=" 421 "border=" 0 "/ >
650) this.width=650; "title=" clip_image010 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image010 "src=" http://s3.51cto.com/wyfs02/M02/8B/9C/wKiom1hSaqShWwFZAAD0ej4PmJo870.jpg "height=" 421 "border=" 0 "/ >
650) this.width=650; "title=" clip_image012 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image012 "src=" http://s3.51cto.com/wyfs02/M01/8B/99/wKioL1hSaqXw23gaAACz5R0mjas549.jpg "height=" 420 "border=" 0 "/ >
650) this.width=650; "title=" clip_image014 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image014 "src=" http://s3.51cto.com/wyfs02/M02/8B/9C/wKiom1hSaqmQ63FOAADVL8clu60327.jpg "height=" 419 "border=" 0 "/ >
650) this.width=650; "title=" clip_image016 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image016 "src=" http://s3.51cto.com/wyfs02/M02/8B/99/wKioL1hSaqmQGExMAACSuPpDf3c203.jpg "height=" 420 "border=" 0 "/ >
650) this.width=650; "title=" clip_image018 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image018 "src=" http://s3.51cto.com/wyfs02/M00/8B/9C/wKiom1hSaquRVtxFAACtD8Q_veU180.jpg "height=" 421 "border=" 0 "/ >
650) this.width=650; "title=" clip_image020 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image020 "src=" http://s3.51cto.com/wyfs02/M01/8B/99/wKioL1hSaquDkj1qAAC0S1mjWOg099.jpg "height=" 421 "border=" 0 "/ >
650) this.width=650; "title=" clip_image022 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image022 "src=" http://s3.51cto.com/wyfs02/M01/8B/9C/wKiom1hSaq3TejJqAAEEv2Vmz-w239.jpg "height=" 423 "border=" 0 "/ >
650) this.width=650; "title=" clip_image024 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image024 "src=" http://s3.51cto.com/wyfs02/M02/8B/99/wKioL1hSaq6SWV5eAACs0uaqpco692.jpg "height=" 421 "border=" 0 "/ >
650) this.width=650; "title=" clip_image026 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image026 "src=" http://s3.51cto.com/wyfs02/M00/8B/99/wKioL1hSaq_jlncjAADl5hRowEQ902.jpg "height=" 420 "border=" 0 "/ >
650) this.width=650; "title=" clip_image028 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image028 "src=" http://s3.51cto.com/wyfs02/M02/8B/99/wKioL1hSarDCrqJjAADf-BQDxkw462.jpg "height=" 420 "border=" 0 "/ >
650) this.width=650; "title=" clip_image030 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image030 "src=" http://s3.51cto.com/wyfs02/M01/8B/99/wKioL1hSarGi9WuRAADMNA-5510535.jpg "height=" 421 "border=" 0 "/ >
650) this.width=650; "title=" clip_image032 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image032 "src=" http://s3.51cto.com/wyfs02/M02/8B/9C/wKiom1hSarKhyhFhAACffgkhPIc264.jpg "height=" 421 "border=" 0 "/ >
650) this.width=650; "title=" clip_image034 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image034 "src=" http://s3.51cto.com/wyfs02/M01/8B/9D/wKiom1hSarLgLw_-AACja-Kk3XM886.jpg "height=" 422 "border=" 0 "/ >
650) this.width=650; "title=" clip_image036 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image036 "src=" http://s3.51cto.com/wyfs02/M00/8B/99/wKioL1hSarOhRkdyAADJ7WZRQa8580.jpg "height=" 421 "border=" 0 "/ >
650) this.width=650; "title=" clip_image038 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image038 "src=" http://s3.51cto.com/wyfs02/M01/8B/9D/wKiom1hSarXB3qXPAADI3_ytB5s680.jpg "height=" 419 "border=" 0 "/ >
Part3: Configuration Chapter
650) this.width=650; "title=" clip_image039 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image039 "src=" Http://s3.51cto.com/wyfs02/M02/8B/9D/wKiom1hSarWwz1PhAAAlcydiFGM539.png "height=" 227 "border=" 0 "/ >
650) this.width=650; "title=" clip_image041 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image041 "src=" http://s3.51cto.com/wyfs02/M02/8B/99/wKioL1hSarixWuiTAADCqiXg4Fo234.jpg "height=" 404 "border=" 0 "/ >
650) this.width=650; "title=" clip_image043 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image043 "src=" http://s3.51cto.com/wyfs02/M02/8B/99/wKioL1hSarmBsZj-AACnjXeu_ss051.jpg "height=" 232 "border=" 0 "/ >
PART4: Installing SSMs
Download ssms:https://msdn.microsoft.com/en-us/library/mt238290.aspx
650) this.width=650; "title=" clip_image045 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image045 "src=" http://s3.51cto.com/wyfs02/M00/8B/99/wKioL1hSarqQk-thAACcYhqbWIQ149.jpg "height=" 475 "border=" 0 "/ >
650) this.width=650; "title=" clip_image047 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image047 "src=" http://s3.51cto.com/wyfs02/M01/8B/99/wKioL1hSarvAAtNJAABVBK-F6xg597.jpg "height=" 481 "border=" 0 "/ >
Part5: Configure SQL Server instance parameters
650) this.width=650; "title=" clip_image048 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image048 "src=" http://s3.51cto.com/wyfs02/M01/8B/9D/wKiom1hSarvyzhbbAAAkvZlRXAg127.png "height=" 225 "border=" 0 "/ >
650) this.width=650; "title=" clip_image049 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "Alt=" Clip_ image049 "src=" Http://s3.51cto.com/wyfs02/M02/8B/9D/wKiom1hSaryAJwRfAAArYTW7OFs543.png "height=" 312 "border=" 0 "/ >
650) this.width=650; "title=" clip_image051 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "alt=" clip_image051 "src=" Http://s3.51cto.com/wyfs02/M00/8B/9D/wKiom1hSar3z5B6FAACxPWaG6Cw705.jpg "height=" 507 "border=" 0 "/>
This article is from the SQL Server deep Dive blog, so be sure to keep this source http://ultrasql.blog.51cto.com/9591438/1883120
Install and configure SQL Server with SP1