Davy's Blog

Recently someone asked me to check a Reporting Services report that always resulted in an Unexpected Error. The report server was configured for Sharepoint Integrated Mode.

I came to the conclusion that the server always returned this error after exactly 2 minutes, so it had to be a timeout exception.
The report was kind of big, so [...]

I recently struggled with the following challenge in Analysis Services:
In one of the fact tables there was a field duration which actually was a duration of a certain status in seconds. I needed to display this in a readable format, like “2 days 22:15:59″.

bing brought me to the following great article, where Mosha explains how [...]

After installing SQL Server Integration Services on an existing 64-bit SQL Server, I was unable to connect to SSIS using Management Studio.
The database engine and Analysis Services was already installed on this server. I added the SSIS service without Service Pack and applied SP3 afterwards. When trying to connect, Management Studio returned the following error [...]

Today I wanted to start playing around with the new Report Manager of SQL 2008 R2.
After installing and configuring R2, I opened Internet Explorer and entered the URL of the Report Manager. In my case: http://localhost/reports_r2
I got a very empty Report Manager :

Okay, something is wrong. I tried to connect to http://localhost/reportserver_r2 :

No [...]

After deploying an Excel file to Excel Services on a new MOSS Server I got the following error:
Data Refresh Failed: Unable to retrieve external data for the following connections:
<<connection>>
The data sources may be unreachable, may not be responding, or may have denied you access.
Verify that data refresh is enabled for the trusted file location [...]

Excel 2007 is great tool for browsing OLAP cubes. But 1 thing a lot of people don’t know about or at least don’t use enough, is Member Properties.
When they want to add a property of a specific attribute, they just check this item in the field list. By using it this way, you’re kind of [...]

Visual StudioTeam System 2008 Database Edition by Bart Wullems
The Azure Services Platform and SQL Services by Kurt Claeys

Enjoy the movies!!

Ever tried to change the URL of the Report Manager in IIS using host headers?
I did, but got the following error message when I tried to open the Report Manager:
“The request failed with HTTP status 400: Bad Request”

In SQL Server 2008 Management Studio, saving changes to the design of a table that requires the table to be dropped and recreated is not possible, but will show the following message instead:

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.
You have either [...]

Today, I tried to publish an Infopath Form to MOSS, but I received the following error message:
The following URL is not valid: http://servername/sites/sitename
Different solutions are available for this problem, but in my case the cause seemed to be that there was no root site (http://servername).
So the solution was to edit the site collection and [...]