FP2000: Error Message: "The server encountered an error while processing the database request"

This article was previously published under Q219079
This article has been archived. It is offered "as is" and will no longer be updated.
When you verify the connection to a database that uses DSN (Data Source Name), the following error message appears:
The server encountered an error while processing the database request. For more information, click Details.
If you click the Details button, you see the following:
Server error: Unable to connect to a database from the web server using the connection string 'DSN=database1 ;DRIVER={SQL Server}'.

The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured.
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User: Reason: Not defined as a valid user of a trusted SQL Server connection.

Source: Microsoft OLE DB Provider for ODBC DriversNumber: -2147217843 (0x80040e4d)
NOTE: The text of the error message may vary, depending upon the specific database and user information.
In FrontPage, after you create a database connection using a system DSN, the user name and password are not automatically populated.


If you specified a user name and password, your user name and password are incorrect.
To resolve this issue, use the following method:
  1. On the Tools menu, click Web Settings.
  2. Click the Database tab.
  3. Select the database that is causing the error, and click the Modify button.
  4. Click the Advanced button.
  5. Insert the correct user name and password for the database, and click OK.
  6. Click OK again.
  7. Click the Verify button.
If Verify does not work, recreate your system DSN and recreate the database connection in FrontPage.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
front page

Article ID: 219079 - Last Review: 10/26/2013 01:47:00 - Revision: 2.0

  • Microsoft FrontPage 2000 Standard Edition
  • kbnosurvey kbarchive kbbug KB219079