Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. FP2000: Error Message: "The server encountered an error while processing the database request"

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

View products that this article applies to.

This article was previously published under Q219079

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Status

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

↑ Back to the top

Keywords: KB219079, kbpending, kbbug

↑ Back to the top

Article Info
Article ID : 219079
Revision : 1
Created on : 10/1/2001
Published on : 10/1/2001
Exists online : False
Views : 241