StarQuest Technical Documents

StarSQL and Microsoft Internet Information Server (IIS) Frequently Asked Questions

Last Update: 26 June 2008
Product: StarSQL
Version: 5.x
Article ID: SQV00SQ026

Abstract

This document describes solutions to the most common problems using StarSQL with Microsoft's Internet Information Server.

• Where do I install StarSQL?
• DB2 login: "incorrect userid or password"
• Anonymous Logon and APPC network errors
• Running applications in a separate memory space

Solution

Where do I install StarSQL?

StarSQL must be installed on the Windows Server where the IIS web service is installed.

Return to the top

The DB2 logon

IIS will not prompt your user for the DB2 userid and password (i.e. the StarSQL connection dialog), so you must do one of the following:

• hardcode the userid and password in your web applications,
• pass the userid and password to your web applications from an html form, or
• add UID (userid) and PWD (password) entries in the registry key of your StarSQL data source

Return to the top

Anonymous Logon

If you are allowing anonymous logins and connecting to your DB2 host through Microsoft Host Integration Server, the IIS web service anonymous user must be a valid user of the Windows Server where Host Integration Server is installed. If the Windows Server with IIS web service is in a separate domain from the Windows Server with the Host Integration Server installed, you must configure both the Windows user and domain permissions.

By default, IIS creates a user for anonymous with the name IUSR_ComputerName where ComputerName is the Windows Server name. Check with your Windows Domain Administrator to see if this account has been granted guest rights.

If you do not configure the IIS anonymous web user correctly, you can connect to DB2 and see data with Visual Interdev or Microsoft Query, but when you browse your ASP web page you may receive one of the following error messages:

• Failed to load library WAPPC32.DLL
• APPC Network Error: AP COMM SUBSYSTEM NOT LOADED. Verbid 1400. Primary return code F004, Secondary Return code 0100000F0 or 020000F0
• Microsoft OLE DB Provider for ODBC Drivers error '80004005' [StarSQL][StarSQL ODBC Driver]The APPC network subsystem is not ready (APPC startup error 61443)
• Data source name not found and no driver specified

Note: If you receive an APPC Network error with all your ODBC enabled applications, please consult the following Microsoft Knowledge Base article for corrective action, "SNA Server APPC Error: F004 AP_COMM_SUBSYSTEM_NOT_LOADED" (Article ID: 148359).

Additional References

The majority of problems with IIS are configuration issues between Microsoft Host Integration Server and Windows domain security. We recommend that you review the articles under the Security topic at the Microsoft's Internet Information Services 6.0 Solution Center. Some additional articles that might be useful are:

• Web Pages Not Serving from IIS (Article ID: 279729)

• How to disable Windows Integrated authentication for Web sites that require only Anonymous access (Article ID: 837139)

• Recommendations for connecting to databases through Internet Information Services (Article ID: 258939)

Return to the top

IIS 4.0: Running applications in its own memory space

In IIS, you can run an application in its own separate memory space. If you are running an application in its own memory space, you must configure the network rights for the IWAM_ComputerName user because it is the memory management user. In other words, if you use Microsoft Host Integration Server, IWAM_ComputerName must also be a valid user of the Windows Server where the Host Integration Server resides.

Return to the top