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 Tutorial of installing MSSQL and SP4 patches](https://images.laozuo.org/wp-content/uploads/2013/03/MSSQL1.jpg)
Click "AUTORUN. EXE" to see the figure above, and then click "Install SQL Server 2000 Components".
Step 2: Install the database server.
![mssql2](https://images.laozuo.org/wp-content/uploads/2013/03/mssql2.jpg)
The third step is step by step installation.
![MSSQL3](https://images.laozuo.org/wp-content/uploads/2013/03/MSSQL3.jpg)
Select the local computer.
![MSSQL4](https://images.laozuo.org/wp-content/uploads/2013/03/MSSQL4.jpg)
Create a new SQL instance.
![MSSQL5](https://images.laozuo.org/wp-content/uploads/2013/03/MSSQL5.jpg)
The default user information is the same as installing other software.
![MSSQL6](https://images.laozuo.org/wp-content/uploads/2013/03/MSSQL6.jpg)
![MSSQL7](https://images.laozuo.org/wp-content/uploads/2013/03/MSSQL7.jpg)
Server and Client Tools is selected by default.
![MSSQL8](https://images.laozuo.org/wp-content/uploads/2013/03/MSSQL8.jpg)
![MSSQL9](https://images.laozuo.org/wp-content/uploads/2013/03/MSSQL9.jpg)
Select a custom path. You need to create a directory folder in our disk D to store SQL data.
![MSSQL11](https://images.laozuo.org/wp-content/uploads/2013/03/MSSQL11.jpg)
Select Use Local System Account.
![MSSQL12](https://images.laozuo.org/wp-content/uploads/2013/03/MSSQL12.jpg)
It is important here to enter the SA password.
![MSSQL13](https://images.laozuo.org/wp-content/uploads/2013/03/MSSQL13.jpg)
![MSSQL-14](https://images.laozuo.org/wp-content/uploads/2013/03/MSSQL-14.jpg)
Confirm that the port is 1433.
![MSSQL16](https://images.laozuo.org/wp-content/uploads/2013/03/MSSQL16.jpg)
![MSSQL17](https://images.laozuo.org/wp-content/uploads/2013/03/MSSQL17.jpg)
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.
Scan the code to follow the official account
Get more news about webmaster circle!
Entrepreneurship, operation and new knowledge