Cannot connect to the server at this time error SOLVED

One of my clients have had this persistent issue bugging them.

Problem.

When trying to export a list from SharePoint Teamsites to Excel (Office 2007 on Vista), this error always pops up. Sometimes it works once and then the error shows up again on subsequent attempts.

After weeks of trying out different scenarios, the solution is pretty simple.

Solution
Turn off the setting for checking server certification revocation list. :)

How
Using network analysis tools to see the communication between client and sharepoint server.

Kilimanjaro, Excel analyzing 20 m rows and WYSIWYA

Here is a post about the new Excel add in which wil support the BI specific release of SQL Server

http://sharepoint.microsoft.com/blogs/GetThePoint/Lists/Posts/Post.aspx?List=8d9e2a99%2Df288%2D47c2%2D916b%2D2f32864f7b82&ID=131

Note the collaboration component at the end of the post in the link above.

SQL Server 2005 Service Pack 2: Extending the Functionality of Your SQL Server 2005 System

Download SQL Server 2005 SP2

Download SQL Server 2005 Express Edition SP2

Download the Updated SQL Server 2005 Books Online
--> Well books online.

Download SQL Server 2005 Feature Pack (February 2007)
--> The Feature Pack is a collection of standalone install packages that provide additional value for SQL Server 2005. It includes: latest versions of redistributable components for SQL Server 2005, latest versions of add-on providers for SQL Server 2005, latest versions of backward compatibility components for SQL Server 2005

Download Updated Samples and Sample Databases
--> 100 over new samples for all SQL 2005 services (Database Engine, including administration, data access, Full-Text Search, Common Language Runtime (CLR) integration, Server Management Objects (SMO), Service Broker, XML, Analysis Services, Integration Services, Notification Services, Reporting Services, Replication

Download SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies ---> this download allows you to run complete reporting functions within a SharePoint site. No need for report center site that is provided by SRS 2005 installation.
http://blogs.msdn.com/sharepoint/archive/2007/02/19/microsoft-sql-server-2005-sp2-reporting-services-integration-with-wss-3-0-and-moss-2007.aspx


Download SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007
--> Provides Excel and Visio add-in for Data Mining and Table Analysis