Focus on cloud service provider activities
Notes on website operation and maintenance

Windows VPS Tutorial Series 10: Installing MSSQL and SP4 Patches Tutorial

Unconsciously, Lao Zuo's blog has reached the tenth chapter about the sharing of basic tutorials on Windows VPS. At present, we have been able to build ASP, ACCESS, PHP, and MYSQL database websites in our own configured environment. This morning, thinking about the shortcomings, it suddenly occurred to many webmasters that they need to use MSSQL database websites when using the WIN system host, and the number of users is also very large. Lao Zuo tried to use MSSQL on a CPS website before, but he didn't know how to configure it.

Today's article, mostly based on pictures, shares how to install MSSQL 2000 components and install SP4 patches. For the download of components, we can“ Install PHP environment+MYSQL+N-point panel "All the toolkits mentioned in the article are available. You can see them after unzipping them directly.

The first step is to install. After unzipping, you will see the SQL2000+SP4 folder. You need to install SQL2000 first.

 Tutorial of installing MSSQL and SP4 patches

Click "AUTORUN. EXE" to see the figure above, and then click "Install SQL Server 2000 Components".

Step 2: Install the database server.

 mssql2

The third step is step by step installation.

 MSSQL3

Select the local computer.

 MSSQL4

Create a new SQL instance.

 MSSQL5

The default user information is the same as installing other software.

 MSSQL6

 MSSQL7

Server and Client Tools is selected by default.

 MSSQL8

 MSSQL9

Select a custom path. You need to create a directory folder in our disk D to store SQL data.

 MSSQL11

Select Use Local System Account.

 MSSQL12

It is important here to enter the SA password.

 MSSQL13

 MSSQL-14

Confirm that the port is 1433.

 MSSQL16

 MSSQL17

Prompt interface after installation. One thing to note is that when installing our system, you may need to prompt us to restart the system. We can restart it as needed. You can install SP4 only after installing SQL2000, and you need to restart it. The old left doesn't install SP4. Everyone installs it by themselves. It's very simple. It can be realized directly in the next step.

Domain name host preferential information push QQ group: six hundred and twenty-seven million seven hundred and seventy-five thousand four hundred and seventy-seven Get preferential promotion from merchants.
Like( zero )
Do not reprint without permission: Lao Zuo's Notes » Windows VPS Tutorial Series 10: Installing MSSQL and SP4 Patches Tutorial


Scan the code to follow the official account

Get more news about webmaster circle!
Entrepreneurship, operation and new knowledge