Microsoft KB Archive/219079

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

Article ID: 219079

Article Last Modified on 10/1/2001

-

APPLIES TO


 * Microsoft FrontPage 2000 Standard Edition

-



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.

Additional query words: front page

Keywords: kbbug kbpending KB219079

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.