Dabratt's SQL Server 2008 Blog (en) http://dabratt.com/sqlblog/en News and tips on technologies related to Microsoft SQL Server 2008 Wed, 18 Apr 2012 12:28:18 +0000 http://wordpress.org/?v=2.5.1 en SSRS 2008 - Sharepoint integrated mode error after KB installation http://feedproxy.google.com/~r/DabrattsSqlServer2008BlogEn/~3/VkW6gVen94A/ http://dabratt.com/sqlblog/en/?p=18#comments Wed, 18 Apr 2012 12:28:18 +0000 admin http://dabratt.com/sqlblog/en/?p=18 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.

]]> http://dabratt.com/sqlblog/en/?feed=rss2&p=18 http://dabratt.com/sqlblog/en/?p=18 SQL Server 2012 - Free ebook http://feedproxy.google.com/~r/DabrattsSqlServer2008BlogEn/~3/FTQQG7zRSAo/ http://dabratt.com/sqlblog/en/?p=17#comments Mon, 02 Apr 2012 08:51:58 +0000 admin http://dabratt.com/sqlblog/en/?p=17 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.

]]> http://dabratt.com/sqlblog/en/?feed=rss2&p=17 http://dabratt.com/sqlblog/en/?p=17 SSRS 2008 - Windows 7: blank page in Report Manager http://feedproxy.google.com/~r/DabrattsSqlServer2008BlogEn/~3/HbHgLTcYU8M/ http://dabratt.com/sqlblog/en/?p=16#comments Thu, 24 Dec 2009 07:56:35 +0000 admin http://dabratt.com/sqlblog/en/?p=16 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. 
]]> http://dabratt.com/sqlblog/en/?feed=rss2&p=16 http://dabratt.com/sqlblog/en/?p=16 PPS 2007: Microsoft abandons Planning module http://feedproxy.google.com/~r/DabrattsSqlServer2008BlogEn/~3/xPJyjAvkj_o/ http://dabratt.com/sqlblog/en/?p=15#comments Mon, 26 Jan 2009 09:15:50 +0000 admin http://dabratt.com/sqlblog/en/?p=15 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

]]> http://dabratt.com/sqlblog/en/?feed=rss2&p=15 http://dabratt.com/sqlblog/en/?p=15 MCITP: goal achieved! http://feedproxy.google.com/~r/DabrattsSqlServer2008BlogEn/~3/7RCzbLkNtfg/ http://dabratt.com/sqlblog/en/?p=14#comments Mon, 27 Oct 2008 21:12:02 +0000 admin http://dabratt.com/sqlblog/en/?p=14 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.

]]> http://dabratt.com/sqlblog/en/?feed=rss2&p=14 http://dabratt.com/sqlblog/en/?p=14 PPS 2007: dealing with “could not load file or assembly” error http://feedproxy.google.com/~r/DabrattsSqlServer2008BlogEn/~3/mKrx4gaq0pM/ http://dabratt.com/sqlblog/en/?p=13#comments Fri, 17 Oct 2008 13:27:30 +0000 admin http://dabratt.com/sqlblog/en/?p=13 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

]]> http://dabratt.com/sqlblog/en/?feed=rss2&p=13 http://dabratt.com/sqlblog/en/?p=13 MCTS SQL Server 2008 http://feedproxy.google.com/~r/DabrattsSqlServer2008BlogEn/~3/RAsARenAajU/ http://dabratt.com/sqlblog/en/?p=12#comments Fri, 10 Oct 2008 07:38:47 +0000 admin http://dabratt.com/sqlblog/en/?p=12 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!

]]> http://dabratt.com/sqlblog/en/?feed=rss2&p=12 http://dabratt.com/sqlblog/en/?p=12 SSIS 2008: new connectors for Oracle and Teradata http://feedproxy.google.com/~r/DabrattsSqlServer2008BlogEn/~3/3SL3UKhfxTs/ http://dabratt.com/sqlblog/en/?p=9#comments Fri, 03 Oct 2008 08:12:55 +0000 admin http://dabratt.com/sqlblog/en/?p=9 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

]]> http://dabratt.com/sqlblog/en/?feed=rss2&p=9 http://dabratt.com/sqlblog/en/?p=9 PPS 2007: Move PPSMonitoring database http://feedproxy.google.com/~r/DabrattsSqlServer2008BlogEn/~3/wDrChFhGH0M/ http://dabratt.com/sqlblog/en/?p=8#comments Fri, 06 Jun 2008 12:36:31 +0000 admin http://dabratt.com/sqlblog/en/?p=8 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
]]> http://dabratt.com/sqlblog/en/?feed=rss2&p=8 http://dabratt.com/sqlblog/en/?p=8 PerformancePoint Server 2007: SP1 is out! http://feedproxy.google.com/~r/DabrattsSqlServer2008BlogEn/~3/8mvyJT6WPf4/ http://dabratt.com/sqlblog/en/?p=7#comments Thu, 05 Jun 2008 06:11:25 +0000 admin http://dabratt.com/sqlblog/en/?p=7 PPS 2007 SP1 is available since yesterday:
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3444589&SiteID=17

]]> http://dabratt.com/sqlblog/en/?feed=rss2&p=7 http://dabratt.com/sqlblog/en/?p=7