SQL Server 2008 Installation and Configuration Graphics Tutorial (with official download address)

Time:2019-9-7

We can also experience many new features from SQL Server 2008, but for the installation of SQL Server 2008, it is better to use graphics to speak. This article will start with the installation of SQL Server 2008.

SQL Server 2008 Simplified Chinese Official Edition Download Address//www.jb51.net/softs/43885.html

Originally, this article is the first one of the server functions: adrms. I didn’t expect to install it successfully several times, but there were some mistakes. Later, I didn’t do anything about it. I planned to put the database of RMS on sql. So in order not to make everyone feel abrupt, this article installs SQL Server 2008, and SQL Server 2008 is very popular in enterprises. Important applications, various financial systems, ERP systems, OA systems, etc. will use the SQL Server 2008 database, and even the website can also use the database as the backstage of the website, which is also the basic application. Let’s also experience the SQL Server 2008.

The example topology diagram is expanded again to include an additional SQL Server 2008 server as shown in the figure.

拓扑图

Here’s the main dish. Start the installation.

Put in the SQL Server 2008 CD-ROM and run it directly

直接运行

Require installation. NET then install it.

安装.NET

Ouch, there’s a mistake. You can’t install it like this. Then go to the server manager and install it.

服务器管理器

Open the Functional Installation Wizard, select. NET, and ask for the other roles required to install. NET

功能安装向导

Start installation

开始安装

IIS role, by default, we don’t want IIS

IIS角色

Start installation

开始安装

Installation completed.

安装完成

Run the SQL Server 2008 installation again

再次运行SQL Server 2008安装

Click Installation – A brand new SQL Server stand-alone installation. If we are ready for failover clustering, then we can create failover clustering SQL.

创建故障转移群集SQL

Routine examination

常规检查

Smile away

再来

Select version, or enter key auto-identifying version

选择版本

Authorization agreement

授权协议

Supporting File Installation

支持文件安装

Installation is complete and self-inspection begins

安装完成开始检查自身

Two warnings, one is. NET warning, saying that no network will delay, or need to download files.

.NET警告

A number to open the port, ignore, open later

警告

Select installed functions, SQL database and management tools

SQL数据库和管理工具

Select examples

选择实例

Driver Check

驱动器检查

Select a service account, as shown in Figure 1. Select a local system account.

选择服务账户

Verification mode: SQL and local mode. Enter password and add administrator. You can add local group or current user.

验证模式

Select Reporting Microsoft Options

选择汇报微软选项

Operational Inspection

运行检查

Information preview confirmation

信息预览确认

Start formal installation

开始正式安装

installation is complete

安装完成

Click Close to Complete

单击关闭完成

Sql2008 in the Start Menu

开始菜单中的sql2008

Open the SMSE management tool

打开smse管理工具

Open the management tool as shown in Figure 1

打开管理工具

The new database option has the boot PS option and has been integrated into sql2008

新建数据库选项

New database pages have abandoned SQL 7.0 and are compatible with SQL Server 2000, but nothing else has changed.

新建数据库页面

Start PS as shown in Figure 1

启动ps

New inbound rule in firewall, port selection 1433

端口选择1433

Establishment completed, you can work in the client. Ha-ha, next try whether there are errors in rms, and then there are errors I am depressed.

建立完成

Title: 2008 R2Win7 Management 24 SQL2008

Link: http://www.cnblogs.com/ccfxny/archive/2009/10/13/1582178.html