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:
- On the Tools menu, click Web Settings.
- Click the Database tab.
- Select the database that is causing the error, and click the Modify button.
- Click the Advanced button.
- Insert the correct user name and password for the database, and click OK.
- Click OK again.
- 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