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

Article translations Article translations
Article ID: 219079 - View products that this article applies to.
This article was previously published under Q219079
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

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.

Properties

Article ID: 219079 - Last Review: October 26, 2013 - Revision: 2.0
Applies to
  • Microsoft FrontPage 2000 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug KB219079

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com