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

Installation environment:

Windows:2003 server sp2

SQL: 2005 sp3

Master the knowledge points:

Installation of Vm virtual machine

Installation of operating system and database

Installation and upgrade of 2005SQL database patch

Version view (interface and commands) understanding of database properties

Peripheral data service understanding

Name resolution:

Instances: default and named instanc

Default instance: directly access the local user name for use, the default instance is only 1. SQL1

Named instance: you can name multiple instance names. From a security perspective, sql1\ SALE SQ1\ MASKET

Database Services:

Analysis service: the service that business intelligence needs!

Report service:

Integrated Services:

Notification service:

Service account:

Authentication mode: Windows authentication and mixed mode authentication

Peripheral function point usage: a predetermined piece of code xp_cmdshell in the stored procedure database

Configuration Manager: can manage all services and ports used in sql

Preparation before installation:

1. Sql2005 management tool, command: adminpak.Msi (can be installed on another machine separately, can remotely control the sql server)

two。 Install the system component IIS, report service reportserver

Installation problem points:

1. Sql cannot be installed, so it is not suitable for this kind of computer?

Answer: should be mostly database software, change to sql software to see whether it is successful!

2. For installation steps, see Baidu Tips?

Answer: the installation needs to open the directory to find the application. See you later, Baidu!

3. Can't find the sql server icon after installation?

A: you need to restart the computer to appear and use it.

4. How to upgrade the patch?

Answer: go to the network to download patch sp3 or other patches, pay attention to the version, Chinese and English, etc., directly install the next step!

5. How to restart the database service? (2 ways)

Click the database instance and right-click to restart

Restart SQL service (MSSQLSERVER) by using services.msc to start computer services

Operation and use

View the version: click the instance properties to view the version information.

Use select @ @ version to view the version

Database property view: the database path can be modified to view the database settings in the properties. (restart sql service) there are two instructions for configuration and operation. Configuration: after modification, it will take effect next time. Run: current effective situation.

Peripheral service operations: there are many extensible features and configurations in the database, which are not enabled by default

Peripheral operation: there are various data services in the peripheral services that can be enabled separately and can be switched remotely.

1433 the database port is open, that is, it can be remote: command whether telnet 192.168.80.1 1433 in cmd is open (the database uses TCP 1433 port to listen to client requests)

Peripheral function points: the stored procedure xp_cmdshell can be connected to another computer to view all the information that can be achieved on the command line. Such as: xp_cmdshell "ipconfig" to view all the information of the computer

Configuration Manager: the protocol of mssqlserver can be set and viewed!

Database type: system database

Master database records the global data in sql can not be corrupted, similar to the operating system, can not be damaged.

The Mode database creates a new database for users using this model database as a standard.

The Msdb database stores task plans.

Tempdb tempdb is equivalent to virtual memory of database.

Create a temporary table: crete table # # student

(snmame varchar (10)

Shomevarchaer (20))

ADWENTUREWORK household database sample database

Command collation:

Delete database: drop database test1

Create a new database: create database test1

Check the version: select @ @ version

Xp_cmdshell "net user zhangsan123! / add" increases computer users

Xp_cmdshell "net localgroup administrators zhangsan / add" joins Zhang San to the administrator group

Net stopmssqlserver1 enter in cmd: stop database service

Net startmssqlserver1 enter in cmd: start database service

Services.msc enters the service command interface in CMD

You can make these two commands into BAT (batch command): create a new txt:netstop mssqlserver1 net start mssqlserver1 and restart the service directly.

Netstat-an enter in cmd: view Port Command (digitize)

Netstat-an enter in cmd: view port command (text)

Netstat/? View all command data

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.