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


The information in this article applies to:

  • Microsoft FrontPage 2000
This article was previously published under Q219079

SYMPTOMS

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 Drivers Number: -2147217843 (0x80040e4d)
NOTE: The text of the error message may vary, depending upon the specific database and user information.

CAUSE

In FrontPage, after you create a database connection using a system DSN, the user name and password are not automatically populated.

-or-

If you specified a user name and password, your user name and password are incorrect.

RESOLUTION

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.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MajorLast Reviewed:10/1/2001
Keywords:kbbug KB219079
©2002 Microsoft Corporation. All rights reserved.