ASP+SQLSERVER2000 Programming Experience Accumulation Summary

asp+|server|server2000|sql|sqlserver| programming

A few days ago to help people debug a asp+sql2000+iis5.1/6.0 Web site program, debugging process encountered in the following questions:

　　One, SQL Server login

There was a backup database, imported to SQL Server via an additional database, and the original web site database did not log in properly. And the user role has been added to security. Give administrator permissions and database owner permissions. Found a problem with the role added, check the reason, the original import database contains a user role, removed and then added.

Attempt to log on, still error: Not with trusted SQL connection. Select Properties-〉 security, and modify authentication as: Windows and SQL Server. or modify the registry:

The value of Hkey_local_machine\software\microsoft\mssqlserver\mssqlserver\loginmode determines what authentication mode SQL Server will take.

1, the use of Windows authentication mode

2. Represents the use of mixed mode (Windows authentication and SQL Server authentication). After normal landing.

　　Two, IIS5 HTTP 500 Internal Server error

The main error is that the ASP program can not browse but the HTML static Web page is not affected, the query network belongs to the "IWAM account in the ActiveDirectory, IIS metabase database and COM + Applications three passwords can not sync" issue, Workaround Reference Network attempts (in parentheses for trial results and processing):

Manual modification: (I follow the steps but manual changes did not succeed, depressed)

1, reset the IIS IWAM account password. Right-click My Computer-> management, open the Computer Management interface open Local Users and Groups-> user right-click to start IIS process account iwam_**** (NOTE: * * * is generally the computer name) Click Set Password, set to a password you want.

2, synchronous IIS metabase in the Iwam_myserver password, in cmd: C:\inetpub\adminscripts>adsutil set W3svc/wamuserpass "YourPassword" You can also: Select the Site Properties-> Directory Security tab-> edit anonymous access and authentication control-> Select Anonymous access in the pop-up box, click the Edit button-> user name browsing, select IWAM_machine, enter the same password in the Password box, select Allow IIS to control password "-> OK.

Attention:

In WIN2000, see the password is an asterisk, to be not an asterisk, you must first modify the Adsutil.vbs file.

A. To C disk Inetpub\adminscripts find Adsutil.vbs (depending on the system setup, some paths may be different)

B. Right-click and open with Notepad

C. Find IsSecureProperty = True Note = There is a space before and after

D. Change IsSecureProperty = True to IsSecureProperty = False

Obtain IWAM account password command: cscript.exe adsutil.vbs get W3svc/wamuserpass
Obtain IUSR account password command: cscript.exe adsutil.vbs get W3svc/anonymoususerpass

Enter the above command and press ENTER to view the IWAM and IUSR passwords separately.

Modify Password command:

Modify the IWAM account password cscript.exe adsutil.vbs set w3svc/wamuserpass "password" 
Modify the IUSR account password cscript.exe adsutil.vbs set w3svc/anonymoususerpass "password"

Password set to the password you want to modify, that is, you set the first step of the user iwam_**** the same, press ENTER to modify the completion.

Be sure to stop all Internet Information Services before you modify your password, or you may have an error later, and the IWAM account may be locked.

3, synchronous COM + applications using the Iwam_myserver password, in cmd:

C:\inetpub\adminscripts>cscript Synciwam.vbs–v. Not succeed. can also be:

(1) Start the Component Services Snap-in: "Run"-> "MMC", start the management console, open the Add/Remove snap-in dialog box, and add the Component Services snap-in.

(2) Locate "Component Services"-> "Computer"-> "My Computer"-> "COM + application"-> "Out-of-process Pooled Applications", right-click "Out-of-process Pooled Applications the "->" attribute.

(3) Switch to the Identification tab of the Out-of-process Pooled Applications Properties dialog box. Select "This user", browse, select the username "IWAM_machine". These are all by default. Enter the correct password in the "password" and "Confirm password" text boxes below to confirm the exit.

(4) If the system prompts "the application is created by more than one external product." Are you sure you want to be supported by these products? "is OK.

(5) If some other Web application protection is set to high (standalone) in IIS, the IWAM account password for the COM + application used by the web will also need to be synchronized.

However, the third step is always reported 8004e00f error. Go to Component Services to view Component Services/Computers/My Computer/com+ applications, resulting in an error "COM + cannot talk to Microsoft distributed Transaction Coordinator" and cannot view the objects inside. The MSDTC service does not start properly in Event Viewer. Workaround: Run Msdtc-resetlog
Finally resolved: "COM + cannot talk to Microsoft distributed Transaction Coordinator" When you install Message Queuing in a Windows component, this error does not occur, and the Message Queuing component distributed Transaction in the service Coordinator "(that is, the MSDTC service) is dependent, this service must be enabled before you can install Message Queuing components! When Message Queuing is installed, the COM + application menu opens to indicate that it is working properly! If you install IIS at this time or unload the IIS load, it's normal! In fact, manual sync password is too troublesome, the success rate is not high!

　　Third, the storage content in the database in the ASP page does not resolve

Problem performance: The original use of the Web page is normal, but after a period of time after using a lot of content can not be normal display.

Problem analysis: Start to think is the connection pool problem, later found that there is no relationship, on the page to see the source has been the contents of the database read out, but did not show on the page. found that the "\" symbol appears. This symbol is considered to be a special character of the escape character in ASP and cannot be parsed, so it cannot be displayed properly.