Experiment 5: web construction of ASP+MSSQL

Lab 5:ASP+MSSQL web architecture

Objective of the experiment: To master the process of building ASP+MSSQL web

Experimental environment: one Server, one Client

Preparation for the experiment:

1. First build a web site (find IIS in the details of adding and deleting components in the application service, select and next, such a WEB server is built.)

2. Add the path to access web files in the "Home Directory" of the default website properties, add the file index.asp in the "Documents", modify the "Allow Parent Directory" in the "Configuration" under the "Home Directory", and enable the file "index.asp" in the "Web Services Extensions".

3. Today, I want to use a new knowledge point, that is, to build a SQL server on top of this web server.

4. Let's look at today's new content

Experimental process:

Question number one?

Install SQL Server 2000 below.

Start SQL Server services after installation

Solution to Problem 1: Add an Attachment Database

Question 2?

Workaround: Modify the connection file

Question 3?

Workaround: Change SQL Administrator Password

Ok, now finally able to access

Question 4?

Solution: The reason for this problem is that the account and password are wrong.

Question 5?

Solution:

You can now log in to the background.