Microsoft KB Archive/898721

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

Article ID: 898721

Article Last Modified on 9/27/2006

-

APPLIES TO


 * Microsoft Office FrontPage 2003

-



SYMPTOMS
In Microsoft Office FrontPage 2003, you receive the following error message:

Database Results Wizard Error

The operation failed. If this continues, please contact your server administrator.

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:

Database Results Wizard Error

Invalid authorization specification.



CAUSE
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.



RESOLUTION
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.



WORKAROUND
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
 * 1) Save the file to your desktop. Use a .udl file name extension.
 * 2) Open the Web site in FrontPage.
 * 3) Import the UDL file into your FrontPage Web site. Store the UDL file in the Fpdb folder.
 * 4) On the Tools menu, click Site Settings.
 * 5) Click the Database tab.
 * 6) Click Add.
 * 7) Click Custom definition.
 * 8) Click Browse.
 * 9) Locate the Fpdb folder in the Web site.
 * 10) Click Universal Data Link (*.udl) for the file type.
 * 11) Click the UDL file, and then click OK.
 * 12) Type a name for the database connection.
 * 13) Click OK.
 * 14) Click Verify to verify the connection.
 * 15) 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:

Database Results Wizard Error

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

If you receive this error message, you cannot use the workaround for this issue. You must follow the steps in the &quot;Resolution&quot; section.



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

325877 How to control access to a database on a Web server in Windows Server 2003

313077 How to control access to a database on a Web server in Windows 2000

318287 What you need to use Active Server Pages (ASP) in FrontPage 2002

Additional query words: fp fp2003 front page drw

Keywords: kbdatabase kbasp kbtshoot kbprb KB898721

-

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

© Microsoft Corporation. All rights reserved.