Slime: SQL Server 2005 Database installation

This article consists of Su Yi Lin Feng provide sponsorship, 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:

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

Click Next

Monitoring Installation Prerequisites

check the conditions required to install SQL Server 2005

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.

Instance Name here we choose Default.

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

in "Authentication Mode" We select "Mixed Mode".

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

you can see that TCP/IP is disabled state