Only the database information can be displayed on the website background, but the deletion and addition information cannot be changed.

 

Allows you to view database information normally.

However, if you want to modify or delete the added information, the http500 error will pop up.

 

Error analysis:

 

1. Since the information can be viewed, the database is connected.

2. The information cannot be changed. It is very likely that the database is set to read-only.

 

However, I set the database to full permissions based on the online method, and also set the local site and local server to full permissions, but still cannot modify the database.

 

Because I used win7. When I clicked on the default web site in IIS Manager-default web site of win7, I found that there was an "Identity Authentication" option in the window on the right,

 

Right-click identity authentication, select Edit permission, and then select security,

 

Click Edit in the lower-right corner of the group or user name, and set the permissions of all users to full control,

After setting the permissions of all user names to full permissions, we were surprised to find that the database could be modified and deleted. :

 

Note: the permissions of the Creator Owner cannot be modified, but you only need to set the permissions of other users to full control...

 

Analysis:

 

Click "select Properties on my computer"> "Security Settings". The reason why the permission does not affect the database is that the permission to modify the folder of the default website is not available.

Select the identity permission from the default website and modify the folder permission of the default website. Of course, it also modifies the database files in the default website folder, which is the right remedy.

 

That is to say, in the case of a similar database browsing that cannot be modified, you can try to modify the "Identity Authentication" security permission in the IIS manager...