You receive a "Database Results Wizard Error" error message when you open or browse Database Results Wizard ASP pages or ASP.NET pages in FrontPage 2003

In Microsoft Office FrontPage 2003, you receive the following error message: You issue occurs when the following conditions are true:

• You open or browse Database Results Wizard ASP pages or ASP.NET pages.
• The ASP pages or the ASP.NET pages are connected to a computer that is running Microsoft SQL Server.

If you have verbose error messages enabled in FrontPage 2003, you may receive the following error message:

This issue occurs when the ASP pages and the ASP.NET pages use Windows authentication through the Database Results Wizard to fetch data. The ASP pages and the ASP.NET pages should use SQL Server standard authentication through the Database Results Wizard to fetch data.

To resolve this issue, you must enable SQL Server standard authentication for the computer that is running SQL Server. To do this, follow these steps:

1. On the Tools menu, click Site Settings, and then click the Database tab.
2. Click the database connection that you want modify, and then click Modify.
3. Click Advanced.
4. Under Authorization, click Save this username and password in the data connection, and then type your user name and your password.

You may be able to configure a database connection by using a Universal Data Link (UDL) file to provide connection information. To do this, follow these steps:

1. Start Notepad, and then type the following text:
   -------------------- Start of UDL file --------------------
   [oledb] ; Everything after this line is an OLE DB initstring
   Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Database_Name;Data Source=SQL_Server_Name
   -------------------- End of UDL file --------------------
2. Save the file to your desktop. Use a .udl file name extension.
3. Open the Web site in FrontPage.
4. Import the UDL file into your FrontPage Web site. Store the UDL file in the Fpdb folder.
5. On the Tools menu, click Site Settings.
6. Click the Database tab.
7. Click Add.
8. Click Custom definition.
9. Click Browse.
10. Locate the Fpdb folder in the Web site.
11. Click Universal Data Link (*.udl) for the file type.
12. Click the UDL file, and then click OK.
13. Type a name for the database connection.
14. Click OK.
15. Click Verify to verify the connection.
16. Click OK.

You should now be able to create ASP pages and ASP.NET that use this database connection.

Note When you use this workaround to test your ASP pages and your ASP.NET pages, you may receive the following error message:If you receive this error message, you cannot use the workaround for this issue. You must follow the steps in the "Resolution" section.

For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base: