SharePoint 2010 Excel Services Error cannot open workbook

After completing an in-place upgrade Excel Services was unable to open workbooks in the browser. I was confident I had everything configured properly. When trying to open a workbook in the browser I got the nondescript Error – Workbook cannot be opened. There was nothing in the server application log and the SP logs didn’t …

SharePoint 2010 Excel Services Error cannot open workbook Read More »

SharePoint 2010 There was an error in communicating with Excel Calculation Services

There was some differences between my development farm and production farm after doing an in-place upgrade to SharePoint 2010. As a result I had some troubles with Excel Services. I was having trouble getting web parts to connect or open spreadsheets in a browser. Basically it came down to two things after making configuration changes: …

SharePoint 2010 There was an error in communicating with Excel Calculation Services Read More »

SharePoint 2010 Upgrade – Database is too old and upgrade is required

So you upgraded your MOSS 2007 farm to SharePoint 2010 instead of doing a new install? Yeah me too…ouch. I had a database that didn’t get upgraded (MOSS_SSP_SEARCH_DB). I decided to rebuild the service applications where I could which included search. The object was still referenced in the configuration database and was creating a configuration …

SharePoint 2010 Upgrade – Database is too old and upgrade is required Read More »

SharePoint HTTP/1.1 404 Connection

HTTP/1.1 404 Connection: close Date: Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET MicrosoftSharePointTeamServices: 12.0.xxxx.xxxx If you receive the error message above when accessing a SharePoint site, it’s most likely because you haven’t created a top level site collection. SharePoint doesn’t create a top level site collection by default. To create the top-level site collection go to Central Administration …

SharePoint HTTP/1.1 404 Connection Read More »

Windows SharePoint Services MOSS 2007 Content Deployment to a Different Server using Empty Site Collection

There was a need to create a sandbox site for end-user training. This would allow all the new content editors to get a hands-on experience during training without compromising the staging environment. We have a virtual server that’s used for development, but didn’t want to people playing with our stuff. The solution was to create …

Windows SharePoint Services MOSS 2007 Content Deployment to a Different Server using Empty Site Collection Read More »

Web Service in Visual Basic .NET Calling a Stored Procedure using Typed Dataset

This web service was created to interact with hosted IVR solution to create an automated interactive routing script where  clients can check the status of their records via telephone. Essentially, the IVR makes a single element SOAP request over HTTP, the web service generates a Typed Dataset from a stored procedure and builds the formatted …

Web Service in Visual Basic .NET Calling a Stored Procedure using Typed Dataset Read More »