Shulou(Shulou.com)06/01 Report--

Http://xiaorenwutest.blog.51cto.com

SQL Server database deployment

Summary: database is now an indispensable storage tool in enterprises, which is used for member login, website, dynamic web content transfer, and now it is mostly used in relational database. Then the necessity of database is introduced.

(1) it can store a large amount of data and information structurally, and it is convenient for users to retrieve and access it effectively.

(2) it can effectively maintain the consistency and integrity of data information and reduce data redundancy (avoid data duplication).

(3) it can meet the sharing and security requirements of the application.

1. Basic concepts of database

Data: symbols that describe things

Datasheet: consists of records (rows) and fields (columns)

Databases: collection of data tables

Database management system: manage and maintain the database DBMS

Database administrator: DBA is responsible for database management and maintenance

Database system: composed of hardware, operating system, database, database management system, application software and users

2. DBMS data model:

Mesh model: supports many-to-many and many-to-one relationships

Hierarchical model: supports one-to-many

Relational model: through the Emurr model (entity-diagram)

3. Mainstream databases:

SQL Server: only on Windows platform, simple and easy to use

Oracle: produced by Oracle, mainstream platform, security, perfection and complex operation

DB2:IMB Company, large, safe and perfect

Mysql: open source, small, fast and stable

4. the concept of relational database:

Primary key Primary Key:

It consists of one or more fields and is unique. Null values are not allowed. A table can only have one primary key.

Candidate key:

Optional key for primary key, which can have more than one

Foreign key:

Add the primary key to the second table, which is called the foreign key in the second table, and is used to contact other tables. It is not allowed to reference tuples that do not exist.

5. Data integrity rules:

Entity integrity: cannot be empty

Domain integrity rules: whether the values of a column are valid

Referential integrity: references to tuples that do not exist are not allowed

User-defined integrity: constraints on specific data

6. SQL 2008R2 64-bit installation preparation:

CPU: supports 64-bit and above 1.4G

Memory: more than 1G

Hard disk: more than 3.6g

Operating system: 2003 sp2 64-bit except web version

2008 64-bit all versions

Security: use firewalls, isolate other services, configure secure file systems, and disable unnecessary protocols

7. Start and stop SQL

① Server Manager

② configuration Manager

③ ssms Management console

8. Registration server: save instance connection information for easy linking and management

You need to specify:

Server type, instance name, authentication method

Verification method:

① Windows authentication, allowing only operating system accounts to log in

② mixed authentication: allows Windows and SQL Server authentication, and sa is the SQL administrator

9. Database classification:

System database: (automatically created, not deleted)

Master: record system-level information

Model: template database

Msdb: agents schedule alerts and jobs

Tempdb: temporary database

User database: created manually, can be deleted

10. Common tools:

SSMS:SQL management console, configuration, management, development of SQL components, the most commonly used tools

Configuration Manager: network configuration settings, port number: 1433

Experimental case:

Two host sqlserver servers ip 192.168.10.251

Client ip 192.168.10.126

Deploy the sql server service:

Installation process: first run setup.exe in the installation directory to open the SQL server2008 installer

The installation process loads the completed installation components, and the installation center interface appears because this is the first installation. So you have a choice.

Fresh installation

In the product key;, you can select the temporary key, which defaults to 180 days of use. If you want to purchase the secret key in a production environment, then proceed to the next step

Then there are the license terms, choose to accept the license terms; next

Click install in the installation support file interface.

After each rule status is passed or warned, you can continue with the installation, but if there is a problem, you need to check the contents of the inspection report, and then follow the prompts to resolve the relevant problems, the next step

You can select the sql server function in the role setting, because this is the first time to install a sql service application on this machine

In the function selection, you can choose the installed function item according to the actual application situation. You can click the function item to view the description below to see the usefulness of the function. Check all here.

Installation rules interface, if there are warnings or failure options that affect the installation process, please check the solution and confirm that you can take the next step.

In the "instance configuration interface", you can select the default instance or the "named instance" radio button. The default instance name is MSSQLSERVER, and you can connect without the client specifying the instance name. The named instance is specified by the user and can be configured by yourself. Choose the default configuration here.

Specify the required account for the sqlserver service and click the same user used by the sqlserver service

In database engine configuration, there are two ways to set accounts

(1) windows authentication: users use the account and password of the windows system when connecting to sql server.

(2) mixed mode: allows users to use windows authentication and sql server authentication when connecting to sql server services

In the Analysis Service configuration interface, click add current user. The current user is an Analysis Service administrator

During the installation and configuration process, the installer runs the rules to determine whether the installation process will be blocked, and if there is no problem, proceed to the next step of installation

After that, you can install directly. The front belongs to the installation preparation work, and then you can start the installation.

The sql server service can be used after the installation is complete

Allows clients to connect to sql server services through ssms management tools

The client tools that need to install the sql server service on the client side are the same as the previous server installation, except that the server files are not installed, which is not described here.

Note: the firewall of the windows system is turned off, otherwise you cannot connect

Database system with successful connection to sql server

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.