Article ID: 831092 - View products that this article applies to.
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 ServerName: The data retrieval service encountered an error during connection to the data source. Contact the server administrator for more information.
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.
To troubleshoot and resolve this issue, do one or more of the following (as appropriate to your situation):
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&displaylang=enFor additional information about Microsoft FrontPage, visit the following Microsoft Web site:
http://office.microsoft.com/assistance/topcategory.aspx?TopLevelCat=CH79001803&CTT=6&Origin=ES790020011033For more information about Windows SharePoint Services, visit the following Microsoft Web site:
Contact us for more help
Connect with Answer Desk for expert help.