Microsoft KB Archive/831092

= You receive a &quot;Server Error: An error occurred while retrieving the list of Databases&quot; error message when you open a Windows SharePoint Services Web site in FrontPage 2003 and configure a database connection =

Article ID: 831092

Article Last Modified on 9/26/2007

-

APPLIES TO


 * Microsoft Windows SharePoint Services
 * Microsoft Office FrontPage 2003

-





SYMPTOMS
When you open a Microsoft Windows SharePoint Services Web site in Microsoft Office FrontPage 2003, and add a data source to the data source catalog (on the Data menu, click Insert Data View, under Database Connections, click Add a Catalog, and then click Configure Database Connection), you may receive an error message that is similar to the following when you try to specify a connection to a remote server that is running Microsoft SQL Server:

Server Error: An error occurred while retrieving the list of Databases from : The data retrieval service encountered an error during connection to the data source. Contact the server administrator for more information.



CAUSE
This issue may occur if the information that you specify in the Configure Database Connection dialog box is incorrect or if certain settings on the server are not configured correctly.



RESOLUTION
To troubleshoot and resolve this issue, do one or more of the following (as appropriate to your situation):  If you use a custom connection string to authenticate to the database server, and you click Use custom connection string in the Configure Database Connection dialog box, make sure that you specify an OLEDB connection string, and not an Open Database Connectivity (ODBC) connection string in the Edit Connection String dialog box.

The following is an example of an OLEDB connection string:

Provider=Provider; Data Source=DataSourceName; Initial Catalog=CatalogName; User id=UserName; Password=Password

 For connections between the Web server and the server that is running SQL Server, enable SQL Server Authentication on the server that is running Microsoft SQL Server. Make sure that the Web.config file is configured with the correct proxy server settings on the server that is running Windows SharePoint Services. To configure the Web.config file to include proxy server settings for the virtual server, follow these steps:  Start Notepad. Locate, and then open the Web.config file that is located in the following folder on the server that is running Windows SharePoint Services:



 Locate the </system.web> entry near the end of the Web.config file.</li> Copy and paste the following lines to the Web.config file, immediately after the </system.web> entry, where  is the name of your proxy server and   is the port that you are using:

<pre class="fixed_text"><system.net> <defaultProxy> <proxy proxyaddress=&quot;http://ProxyServer:port&quot; bypassonlocal = &quot;true&quot;/>    </defaultProxy> </system.net>

</li> Save the Web.config file, and then quit Notepad.</li></ol> </li> If you want to use update queries, configure data retrieval services on the server that is running Windows SharePoint Services to permit update query support. To do so, follow these steps: <ol> Start Microsoft SharePoint Central Administration.</li> Under Component Configuration, click Configure data retrieval service settings.</li> On the Data Retrieval Service Settings page, under Update Support, click to select the Enable update query support check box, and then click OK.</li></ol> </li></ul>

<div class="moreinformation_section">

MORE INFORMATION
For additional information about how to configure and administer Windows SharePoint Services, see the Microsoft Windows SharePoint Services 2.0 Administrator's Guide. To obtain the Microsoft Windows SharePoint Services 2.0 Administrator's Guide, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=a637eff6-8224-4b19-a6a4-3e33fa13d230&amp;displaylang=en

For additional information about Microsoft FrontPage, visit the following Microsoft Web site:

http://office.microsoft.com/assistance/topcategory.aspx?TopLevelCat=CH79001803&amp;CTT=6&amp;Origin=ES790020011033

For more information about Windows SharePoint Services, visit the following Microsoft Web site:

http://technet.microsoft.com/windowsserver/sharepoint/default.aspx

Additional query words: wss

Keywords: kberrmsg kbtshoot kbdatabase kbprb kbwebservices kbopenfile KB831092

-

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

© Microsoft Corporation. All rights reserved.