SSRS 2008 - Sharepoint integrated mode error after KB installation

You may encounter following error on some of your sharepoint integrated reports:
“Operation is not valid due to the current state of the object”

It occurs after following KB installation on Sharepoint Server:

http://technet.microsoft.com/en-us/security/bulletin/ms11-100

Affected reports are reports with many parameters and/or many distinct values for a single parameter.

You have to uninstall KB in order to avoid this error and refer to the MS support.

SQL Server 2012 - Free ebook

Microsoft provides freely “Introducing SQL Server 2012″ ebook:

http://blogs.msdn.com/b/microsoft_press/archive/2012/03/15/free-ebook-introducing-microsoft-sql-server-2012.aspx

It’s a good way to take a look at SQL Server 2012 new features.

SSRS 2008 - Windows 7: blank page in Report Manager

After installing Reporting Services 2008 on Windows 7, you may encounter blank page when accessing to the Report Manager:

Typical display of a rightless user despite the fact that you are local admin on your machine…an access to the ReportServer URL will confirm it.

A slight manipulation is necessary to retablish rights correctly:

  • Open Internet Explorer with the “Run As Administrator” mode.
  • Go to the Report Manager, this time display should be normal.
  • Give necessary rights to you local user through the “Properties -> Security” tab and “Site Parameteres -> Security” link. 

PPS 2007: Microsoft abandons Planning module

Microsoft has decided to rethink it’s BI strategy and to concentrate various modules.

Many changes are planified:
- PPS Planning will be abandoned.
- PPS Monitoring & Analytics will be entirely integrated in MOSS.

More details here:
http://blogs.msdn.com/bi/archive/2009/01/23/microsoft-bi-strategy-update.aspx

MCITP: goal achieved!

I passed successfully exam 70-452 PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008. I’m now officially a Microsoft Certified IT Professional Business Intelligence Developer 2008.

PPS 2007: dealing with “could not load file or assembly” error

When installing .NET Framework 3.5 on a server hosting PerformancePoint, you may encounter following error when connecting to the PPS WebService through Dashboard Designer:

Could not load file or assembly ‘System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35′ or one of its dependencies

Generaly, installing AJAX extensions will resolve it:
http://www.microsoft.com/downloads/details.aspx?FamilyID=ca9d90fa-e8c9-42e3-aa19-08e2c027f5d6&displaylang=en

MCTS SQL Server 2008

Time for self-satisfaction: i’ve just successfully passed 70-432 and 70-448 exams.

I’m now officially MCTS SQL Server 2008, Implemention et Maintenance et MCTS SQL Server 2008, Business Intelligence Development and Maintenance.

Next objective: MCITP!

SSIS 2008: new connectors for Oracle and Teradata

Microsoft has just published new connectors for Oracle and Teradata databases.

Those components are intended to achieve optimal performances.

http://www.microsoft.com/downloads/details.aspx?FamilyID=d9cb21fe-32e9-4d34-a381-6f9231d84f1e&displaylang=en

PPS 2007: Move PPSMonitoring database

To specify new connection details to a recently moved PPSMonitoring database, you have to modify Bpm.MonitoringConnectionString in following Web.config files:

  • C:\Program Files\Microsoft Office PerformancePoint Server\3.0\Monitoring\<instance_PPS>\WebService
  • C:\Program Files\Microsoft Office PerformancePoint Server\3.0\Monitoring\<instance_PPS>\Preview
  • C:\Inetpub\wwwroot\wss\VirtualDirectories\80

PerformancePoint Server 2007: SP1 is out!

What else ?

  • View Grégory Leandro's profile on LinkedIn