Slime: SQL Server 2005 Database installation

This article is starting in Slime Line the world .

In order to make better use of the server, it is intended to migrate the business. Because the business is special and requires the appropriate hardware support on the server, it is intended to upgrade the current operating system of the server directly. The company server is currently using Windows Server 2003 32bit Enterprise Edition. If you use a virtual machine, you can only install 32bitOS, so you plan to upgrade the OS directly and install it into Windows Server R2 64bit.

However, before you upgrade, you need to back up the database for that business. The business database is using SQL Server 2005. To be honest, you were not familiar with SQL Server databases. Testing can only be done on the test machine first.

First install Windows Server R2 on the test machine, such as:

650) this.width=650; "title=" clip_image001 "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, "border=" 0 "alt=" clip_ image001 "src=" Http://img1.51cto.com/attachment/201407/11/526870_1405089565pPwV.png "height=" 532 "/>

Download SQLServer2005 64bit for installation, and then install it.

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;padding-right:0px, "border=" 0 "alt=" clip_ image002 "src=" Http://img1.51cto.com/attachment/201407/11/526870_1405089569nIjW.png "height=" 452 "/>

Click Next

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;padding-right:0px, "border=" 0 "alt=" clip_ image003 "src=" Http://img1.51cto.com/attachment/201407/11/526870_1405089574WBKp.png "height=" 452 "/>

Monitoring Installation Prerequisites

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;padding-right:0px, "border=" 0 "alt=" clip_ image004 "src=" http://img1.51cto.com/attachment/201407/11/526870_1405089576CRTJ.png "height=" 446 "/>

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;padding-right:0px, "border=" 0 "alt=" clip_ image006 "src=" http://img1.51cto.com/attachment/201407/11/526870_1405089579r4dD.jpg "height=" 460 "/>

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;padding-right:0px, "border=" 0 "alt=" clip_ image008 "src=" http://img1.51cto.com/attachment/201407/11/526870_1405089584MDw2.jpg "height=" 455 "/>

Check the conditions required to install SQL Server 2005

650) this.width=650; "title=" clip_image009 "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, "border=" 0 "alt=" clip_ image009 "src=" Http://img1.51cto.com/attachment/201407/11/526870_1405089587xtru.png "height=" 447 "/>

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;padding-right:0px, "border=" 0 "alt=" clip_ image010 "src=" Http://img1.51cto.com/attachment/201407/11/526870_1405089592yZbN.png "height=" 461 "/>

In this case, to select the SQL Server Database Services component, you must select the Intergration services component if you want the database to be backed up automatically. At the same time, according to the actual situation, you can choose the specific components to install.

650) this.width=650; "title=" clip_image011 "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, "border=" 0 "alt=" clip_ image011 "src=" Http://img1.51cto.com/attachment/201407/11/526870_1405089595Nj0J.png "height=" 453 "/>

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;padding-right:0px, "border=" 0 "alt=" clip_ image012 "src=" http://img1.51cto.com/attachment/201407/11/526870_1405089598BYnl.png "height=" 449 "/>

Instance Name here we choose Default.

650) this.width=650; "title=" clip_image013 "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, "border=" 0 "alt=" clip_ image013 "src=" Http://img1.51cto.com/attachment/201407/11/526870_1405089600dcqk.png "height=" 451 "/>

In the service account, select Local system in use built-in system account.

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;padding-right:0px, "border=" 0 "alt=" clip_ image014 "src=" http://img1.51cto.com/attachment/201407/11/526870_14050896044uDD.png "height="/>

In "Authentication Mode" We select "Mixed Mode".

650) this.width=650; "title=" clip_image015 "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, "border=" 0 "alt=" clip_ image015 "src=" Http://img1.51cto.com/attachment/201407/11/526870_1405089606IwUk.png "height=" 447 "/>

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;padding-right:0px, "border=" 0 "alt=" clip_ image016 "src=" Http://img1.51cto.com/attachment/201407/11/526870_1405089610wGj3.png "height=" 453 "/>

650) this.width=650; "title=" clip_image017 "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, "border=" 0 "alt=" clip_ image017 "src=" Http://img1.51cto.com/attachment/201407/11/526870_1405089613hXcF.png "height=" 451 "/>

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;padding-right:0px, "border=" 0 "alt=" clip_ image018 "src=" Http://img1.51cto.com/attachment/201407/11/526870_1405089618X8vD.png "height=" 426 "/>

650) this.width=650; "title=" clip_image019 "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, "border=" 0 "alt=" clip_ image019 "src=" Http://img1.51cto.com/attachment/201407/11/526870_14050896253T3v.png "height=" 429 "/>

Once the installation is complete, we will configure the SQL Server-related IP addresses such as:

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;padding-right:0px, "border=" 0 "alt=" clip_ image020 "src=" http://img1.51cto.com/attachment/201407/11/526870_140508962727R6.png "height=" 548 "/>

650) this.width=650; "title=" clip_image021 "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, "border=" 0 "alt=" clip_ image021 "src=" http://img1.51cto.com/attachment/201407/11/526870_14050896293XNK.png "height=" 297 "/>

You can see that TCP/IP is disabled state

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;padding-right:0px, "border=" 0 "alt=" clip_ image022 "src=" Http://img1.51cto.com/attachment/201407/11/526870_1405089631kwC9.png "height=" 237 "/>

650) this.width=650; "title=" clip_image023 "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, "border=" 0 "alt=" clip_ image023 "src=" http://img1.51cto.com/attachment/201407/11/526870_1405089633Zm2U.png "height=" 424 "/>

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;padding-right:0px, "border=" 0 "alt=" clip_ image024 "src=" Http://img1.51cto.com/attachment/201407/11/526870_14050896377pbY.png "height=" 197 "/>

650) this.width=650; "title=" clip_image025 "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, "border=" 0 "alt=" clip_ image025 "src=" http://img1.51cto.com/attachment/201407/11/526870_1405089639Nvfc.png "height=" 362 "/>

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;padding-right:0px, "border=" 0 "alt=" clip_ image026 "src=" Http://img1.51cto.com/attachment/201407/11/526870_1405089644WBDZ.png "height=" 707 "/>

This article is from the "Slime Row World" blog, please be sure to keep this source http://ilanni.blog.51cto.com/526870/1437243