本文主要介绍如何准备，部署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 之前需要调试以下内容.
修改计算机名
在组策略在添加两条防火墙规则（1433和4022）, 如下图：
然后安装.net framework 3.5.1
然后安装.net Framework 4.0
下载地址： http://www.microsoft.com/download/en/details.aspx?id=17851
根据提示重启电脑
重启后安装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的安装了
按照下图来修改你的server配置
选择database engine configuration
添加Rules
安装中
安装成功
