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

ID: Q219079

The information in this article applies to:

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 this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: front page 


Keywords          : kbdta 
Version           : WINDOWS:
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: July 23, 1999