At my clients SharePoint 2007 farm we have had a very hard to solve error. The error decription in the Application log was:
Failure trying to synch site 3e545b3e-4ddf-4fd2-8c46-00f73fad5864 for ContentDB ecabb92e-caa6-4a37-bebe-cacf64bc31d6 WebApp d2fc32fc-607b-4c5b-902e-b33f58705e74. Het uitzonderingsbericht is: Cannot insert duplicate key row in object ‘dbo.UserMemberships’ with unique index CX_UserMemberships_RecordId_MemberGroupId_SID’. The statement has been terminated.
and the second [...]
Continue reading about Failure trying to synch contentdb error 5553 7888
I’m having, well to be precise the SharePoint farm I’m dealing with, performance issues with SharePoint 2007 search queries. Let me introduce the farm first to give you an idea:
2x WFE
CPU 4x Xeon 2 GHz E5504 (1x CPU quad core), 24 GB RAM
Hardware load balanced
OS Windows 2003 R2 SP2 x64
SP2007 untill April 2010 CU
both search query [...]
Continue reading about SharePoint 2007 search query results in 100 percent cpu time
I had to install, not for the first time, the Report Viewer and Report Explorer web parts at a client farm. Last time I did not write down what I had done so that is why I post it here.
It is very simple. The cab file that contains this web parts can be found here:
C:\Program [...]
Pricing for MOSS can be complex, especially when calculating the cost of optional products. For your convenience and information, Bamboo Solutions developed the SharePoint Price Calculator. This tool can help you develop a good ballpark estimate of your total licensing expenditures. At the moment it is only for SharePoint 2007
Find here the calculator site.
Microsoft also [...]
SharePoint Prerequisites
In this second part I’ll let you see how to install the prerequisites that are needed for a successful SharePoint 2010 installation.
In part 1 of these series you might have read that I install everything on one server. Windows 2008 R2, Active Directory and SQL 2008 R2 CTP. When you’re in the same situation [...]
Continue reading about SharePoint 2010 scripted install with powershell part 2
At a client SharePoint 2007 farm, installed on Windows Server 2008 servers, I had to install SQL Server Reporting Services Add in for Sharepoint. I already know that one has to install with elevated privileges at 2008 but this installation required some specific steps to complete.
At first I tried this installation:
Open a command prompt with [...]
Continue reading about SSRS 2008 SharePoint Add in installation on Windows Server 2008 Howto
Microsoft has announced the upcoming delivery of the November community technology preview (CTP) of Microsoft SQL Server 2008 R2. Microsoft also announced two new editions providing a high level of scalable solutions: Microsoft SQL Server 2008 R2 Datacenter and Microsoft SQL Server 2008 R2 Parallel Data Warehouse.
SQL Server R2 Datacenter delivers a high-performing information platform [...]
Continue reading about New SQL Server 2008 R2 Premium Editions
Recently I had to make a SharePoint test farm at a customer site completely identical to the production farm. Therefore I backed up all production databases (including the Config and Admin databases) and restored them to the SQL server in the test environment.
Before I use the Configuration Wizard to disconnect the test servers from the [...]
Continue reading about SharePoint backup and restore database trick
Very interesting article at Ian’s blog about some issues with SSRS 2008 and SharePoint.
When installing, think about:
Integrated mode only works for SharePoint Web Applications on the Default Zone
Integrated mode will not work on a Web Application that has Anonymous access enabled
Read more about SSRS 2008 installation at the source.
Continue reading about Reporting Services 2008 in SharePoint Integrated Mode
Recently I posted an article (here) about getting SQL Server Reporting Services 2005 to work at a Windows 2008 Server. It worked so far that SSRS is now working in Native mode but not yet in SharePoint Integrated mode. There are some Kerberos errors in the eventlogs. So, I searched the internet for information about [...]
Continue reading about SSRS 2005 and Kerberos settings on Windows Server 2008
