MarC on April 23rd, 2010

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 [...]

Continue reading about Install RsWebparts.cab in SharePoint

MarC on April 19th, 2010

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 [...]

Continue reading about SharePoint price calculator

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

MarC on November 4th, 2009

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

MarC on July 3rd, 2009

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

Today I tried to install SSRS 2005 at the Windows Server 2008 server of a client but the option for Reporting Services was greyed out. After some research on the internet I found an article by Jim Hlavin to make this work.
Look here for the solution.
Edit:
After following the solution in Jims post it still did [...]

Continue reading about SQL Server Report Service 2005 at Windows Server 2008 issue

MarC on January 27th, 2009

I blog about this error just as reminder for myself (and hopefully you also think it is helpfull). At the moment I’m building Infopath 2007 forms for a customer and I want to read from a database that is on a SQL server. At the database I made a SQL account to connect with and [...]

Continue reading about Trusted SQL connection