安装你的第一台SQL 2008 Server

 测试环境：

dc01 DC服务器

cndb02 域中成员服务器用于安装sql server

第一步：

为sql服务和sql管理员增加用户

服务启动帐户

sqlsvc 密码：liy6$Z92

SQL管理员用户

sqladmin 密码：K3$f0z6  密码可自行设定，这里为了符合AD域的密码策略。

<a href="http://blog.51cto.com/attachment/201304/171334711.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/171334279.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/171334205.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/171334796.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/171457621.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/171457974.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/171457957.png" target="_blank"></a>

第二步：

以本地管理员身份登录cndb02进行程序安装

<a href="http://blog.51cto.com/attachment/201304/174149944.png" target="_blank"></a>

插入安装光盘后，自动安装sql所需的系统组件

<a href="http://blog.51cto.com/attachment/201304/174308378.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/174308164.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/174308630.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/174308564.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/174417877.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/174417305.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/174417203.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/174417279.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/174458482.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/174458925.png" target="_blank"></a>

按要求重启服务器

登录后，双击安装光盘开始安装

<a href="http://blog.51cto.com/attachment/201304/174659466.png" target="_blank"></a>

打开系统配置检查器

<a href="http://blog.51cto.com/attachment/201304/174747510.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/174747263.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/174747949.png" target="_blank"></a>

打开全新SQL Server独立安装

<a href="http://blog.51cto.com/attachment/201304/174945780.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/174945372.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/174945238.png" target="_blank"></a>

输入序列号

<a href="http://blog.51cto.com/attachment/201304/175028388.png" target="_blank"></a>

接受许可条款

<a href="http://blog.51cto.com/attachment/201304/175139833.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/175352488.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/175352599.png" target="_blank"></a>

如果是64位系统需要在选项中修改版本

<a href="http://blog.51cto.com/attachment/201304/175503971.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/175749181.png" target="_blank"></a>

如果是最小化安装，选择数据库引擎服务和SQL Server复制即可

<a href="http://blog.51cto.com/attachment/201304/175749926.png" target="_blank"></a>

由于需要在本机管理数据库服务器，因此勾选管理工具，联机丛书在不会使用时可以用来查查帮助。

<a href="http://blog.51cto.com/attachment/201304/175749226.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/180219753.png" target="_blank"></a>

设置服务启动用户为sqlsvc

<a href="http://blog.51cto.com/attachment/201304/180530982.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/180530265.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/180530992.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/180530638.png" target="_blank"></a>

添加SQL Server管理员为sqladmin

<a href="http://blog.51cto.com/attachment/201304/180652701.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/180807413.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/180807256.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/180807109.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/180807139.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/180911878.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/180911698.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/180911120.png" target="_blank"></a>

查看安装日志，各项服务已经顺利安装

<a href="http://blog.51cto.com/attachment/201304/181041889.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/181041235.png" target="_blank"></a>

第三步：

以sqladmin登录cndb02验证权限是否可用

<a href="http://blog.51cto.com/attachment/201304/181146547.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/181146426.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/181146165.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/181146301.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/181241821.png" target="_blank"></a>

<a href="http://blog.51cto.com/attachment/201304/181241579.png" target="_blank"></a>

创建数据库成功，到此安装完成。欢迎各位博友拍砖

本文转自 tao61 博客，原文链接：http://blog.51cto.com/tao61/1188566如需转载请自行联系原作者