Server Settings Database File WSPBCH32.MDB or WSPINDEX.MDB was not found

From Support

If you have a question or seek clarification, please call Technical Support.

Problem:

When the WinSpool/400 Web Report Server is run on a Windows NT PC with IIS 4.0 (Microsoft Internet Information Server) the message listed above is given when the user attempts to access the Web Report Server and the actual report files and settings database files WSPBCH32.MDB or WSPINDEX.MDB are stored on network drives instead of the C: drive on the IIS PC.

Solution:

In the IIS Administration Screens, find the "Anonymous Access and Authentication Control" screen for the "Default Web Site" and edit the authentication information for anonymous access to the web server. Check the following settings:

Recommended Option - Allowing Anonymous Access

1. "Allow anonymous access" should be enabled.

2. There should be a valid NT Domain User name and password entered for the anonymous access. Usually the IUSR_[Machine Name] user is used.The anonymous user name must be registered as a DOMAIN USER in Windows NT so the user can access files on other servers if authorized.

Note: The user must also have Windows NT permission to access the data directory if the reports will be stored on a file server with secured directories.

3. Disable the "Enable Automatic Password Synchronization" setting.

Note: This is the setting that can cause problems when the web server and CGI process is running on a Windows NT web server PC and the report files or .MDB files being accessed are on another Windows NT Workstation or Server. Another user has also reported that when the report files or .MDB files are on the local drive this problem will also occur, so you will need to test after changing this setting.

4. Disable the "Basic Authentication" and "Windows NT Challenge/Response" settings.

Secondary Option - Forcing User Authentication 1. Disable the "Windows NT Challenge/Response" and "Allow anonymous access" settings.

2. "Basic Authentication" should be enabled.

3. When the user accesses the Web Report Server, IIS will first ask them for a user name and password before passing control to the Web Report Server CGI program. This option is only recommended when the Web Report Server is running on an Intranet because the user ID's and password are sent in plain text over the Internet connection, however the Web Report Server does its own user name/password encryption before sending data over the web, so the risk of password exposure is minimized.