Davy's Blog

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

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

On September 24th, we kick off a new year of SQLUG events. To be sure we kick-off properly, we hired a top-speaker, namely Dirk Gubbels. Dirk is one of our best guest speakers and by far one of the best SQL Server professionals. Dirk Gubbels is a senior consultant at Microsoft, and has been working [...]

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

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

REDMOND, Wash. — Aug. 6, 2008 — Microsoft Corp. today announced the release to manufacturing of Microsoft SQL Server 2008, the new version of the company’s acclaimed data management and business intelligence platform. This version of SQL Server provides powerful new capabilities such as support for policy-based management, auditing, large-scale data warehousing, geospatial data, and [...]

Today I got this error while trying to browse a cube from the Business Intelligence Development Studio: The detailed error information told me that the connection failed, because the server actively refused it. Connecting from another pc worked perfectly, so it had to be a problem with my computer. To solve this problem I needed to [...]

Today I had some problems with a report solution created in Visual Studio 2005: After I got the latest version out of SourceSafe, I could not open it anymore. The error message was “Project item ’4294967294′ does not represent a file.” Searching for this error on the internet I came to this solution: – Open [...]

In one of my previous articles I explained how to use embedded code in SQL Server Reporting Services. The possibility to add embedded code to a report, is a very powerfull feature to add some custom functionality to your report. But sometimes it might be necessary to add some custom functionality that is too complicated [...]

Sometimes it might be necessary to use the same expression on different places throughout a report. You can of course just copy and paste the expression every time you need it, but if you’ll ever need to change this expression, you will have to change it for every field you’re using it for. Therefore it’s good [...]