Home Database Mysql Tutorial 烂泥:SQL Server 2005数据库安装

烂泥:SQL Server 2005数据库安装

Jun 07, 2016 pm 03:06 PM
server sql Install database

本文由 秀依林枫 提供友情赞助,首发于 烂泥行天下 。 为了能更好的利用服务器,所以打算把该业务进行迁移。因为该业务比较特殊,需要服务器上有相应的硬件支持,所以打算直接升级该服务器目前的操作系统。目前公司服务器使用的windows server 2003 32bit企

本文由秀依林枫提供友情赞助,首发于烂泥行天下

为了能更好的利用服务器,所以打算把该业务进行迁移。因为该业务比较特殊,需要服务器上有相应的硬件支持,所以打算直接升级该服务器目前的操作系统。目前公司服务器使用的windows server 2003 32bit企业版。如果使用虚拟机的话,只能安装32bitOS,所以打算直接升级OS,安装成windows server 2008 R2 64bit。

但是在进行升级之前,需要对该业务的数据库进行备份。该业务数据库使用的是SQL Server 2005。说实话,以前对SQLServer数据库不是很熟悉。只能先在测试机器上进行测试。

首先在测试机器上安装windows server 2008 R2,如下图:

烂泥:SQL Server 2005数据库安装

下载SQLServer2005 64bit进行安装,然后进行安装。

烂泥:SQL Server 2005数据库安装

点击下一步

烂泥:SQL Server 2005数据库安装

监测安装必备组件

烂泥:SQL Server 2005数据库安装

烂泥:SQL Server 2005数据库安装

烂泥:SQL Server 2005数据库安装

检查安装SQLServer 2005所需要的条件

烂泥:SQL Server 2005数据库安装

烂泥:SQL Server 2005数据库安装

在这要选择SQL Server Database Services组件,如果要使数据库可以自动备份数据库的话,在此一定要选择Intergration Services组件。同时也可以根据实际的情况,进行选择具体所要安装的组件。

烂泥:SQL Server 2005数据库安装

烂泥:SQL Server 2005数据库安装

实例名称我们在此选择默认。

烂泥:SQL Server 2005数据库安装

在服务帐户中选择“使用内置系统帐户”中的“本地系统”。

烂泥:SQL Server 2005数据库安装

“身份验证模式”中我们选择“混合模式”。

烂泥:SQL Server 2005数据库安装

烂泥:SQL Server 2005数据库安装

烂泥:SQL Server 2005数据库安装

烂泥:SQL Server 2005数据库安装

烂泥:SQL Server 2005数据库安装

安装完毕后,我们来配置SQLServer相关IP地址,如下图:

烂泥:SQL Server 2005数据库安装

烂泥:SQL Server 2005数据库安装

可以看到TCP/IP是禁用状态

烂泥:SQL Server 2005数据库安装

烂泥:SQL Server 2005数据库安装

烂泥:SQL Server 2005数据库安装

烂泥:SQL Server 2005数据库安装

烂泥:SQL Server 2005数据库安装

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

What is the difference between HQL and SQL in Hibernate framework? What is the difference between HQL and SQL in Hibernate framework? Apr 17, 2024 pm 02:57 PM

What is the difference between HQL and SQL in Hibernate framework?

How does Go language implement the addition, deletion, modification and query operations of the database? How does Go language implement the addition, deletion, modification and query operations of the database? Mar 27, 2024 pm 09:39 PM

How does Go language implement the addition, deletion, modification and query operations of the database?

Essential PHP programs: Install these to run smoothly! Essential PHP programs: Install these to run smoothly! Mar 27, 2024 pm 05:54 PM

Essential PHP programs: Install these to run smoothly!

Detailed tutorial on establishing a database connection using MySQLi in PHP Detailed tutorial on establishing a database connection using MySQLi in PHP Jun 04, 2024 pm 01:42 PM

Detailed tutorial on establishing a database connection using MySQLi in PHP

How to download 360 Secure Browser on your computer How to download 360 Secure Browser on your computer Apr 12, 2024 pm 01:52 PM

How to download 360 Secure Browser on your computer

PHP FFmpeg extension installation guide: easy-to-follow tutorial PHP FFmpeg extension installation guide: easy-to-follow tutorial Mar 28, 2024 pm 02:17 PM

PHP FFmpeg extension installation guide: easy-to-follow tutorial

How does Hibernate implement polymorphic mapping? How does Hibernate implement polymorphic mapping? Apr 17, 2024 pm 12:09 PM

How does Hibernate implement polymorphic mapping?

iOS 18 adds a new 'Recovered' album function to retrieve lost or damaged photos iOS 18 adds a new 'Recovered' album function to retrieve lost or damaged photos Jul 18, 2024 am 05:48 AM

iOS 18 adds a new 'Recovered' album function to retrieve lost or damaged photos

See all articles