准备以及安装SQL SERVER 2008 R2

本文主要介绍如何准备,部署SQL Server 2008 R2.

可能用到的链接:

.Net Framework 4.0
下载地址: http://www.microsoft.com/download/en/details.aspx?id=17851

Windows Installer 4.5

下载地址:http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=8483
在安装SQL Server 2008 R2 之前需要调试以下内容.

修改计算机名

12

 

在组策略在添加两条防火墙规则(1433和4022), 如下图:

22

 

然后安装.net framework 3.5.1

36

然后安装.net Framework 4.0

下载地址: http://www.microsoft.com/download/en/details.aspx?id=17851

43

根据提示重启电脑

53

重启后安装IIS的以下服务:

Common HTTP Features

Static Content

Default Document

Directory Browsing

HTTP Errors

HTTP Redirection

Application Development

ASP.NET

.NET Extensibility

ASP

ISAPI Extensions

ISAPI Filters

Health and Diagnostics

HTTP logging

Logging tools

Request Monitor

Tracing

Security

Basic Authentication

Windows Authentication

URL Authorization

Request Filtering

IP and Domain Restrictions

Performance

Static Content Compression

Management Tools

IIS Management Console

IIS Management Scripts and Tools

Management Service

IIS 6 Management Compatibilty

IIS 6 Metabase Compatibility

IIS 6 WMI Compatibility

IIS 6 Scripting Tools

IIS 6 Management Console

(Windows Server 2008 R2可以略过此步骤)

安装Windows Installer 4.5

注意:

For Windows Vista, Windows Vista Service Pack 1 and Windows Server 2008:

x86 Platform: Windows6.0-KB942288-v2-x86.msu

x64 Platform: Windows6.0-KB942288-v2-x64.msu

IA64 Platform: Windows6.0-KB942288-v2-ia64.msu

For Windows XP Service Pack 2 and Windows XP Service Pack 3 (32-bit platforms):

x86 Platform: WindowsXP-KB942288-v3-x86.exe

For Windows Server 2003 Service Pack 1, Windows Server 2003 Service Pack 2 and Windows XP 64-bit Editions:

x86 Platform: WindowsServer2003-KB942288-v4-x86.exe

x64 Platform: WindowsServer2003-KB942288-v4-x64.exe

IA64 Platform: WindowsServer2003-KB942288-v4-ia64.exe

然后就可以进入SQL Server的安装了

62

按照下图来修改你的server配置

71

选择database engine configuration

81

添加Rules

9

安装中

10

安装成功

111