August 2008

You are currently browsing the monthly archive for August 2008.

Having trouble getting KB948109 installed?  I did.  It was caused by some SQL Server services which I never use and had put to Disabled.  Put them to Manual or Automatic.  Then the update will install fine.

Here’s the full error description from the System Event Log:

Installatiefout: de volgende update kan niet worden geïnstalleerd, foutcode 0×80070643: Security Update for SQL Server 2005 Service Pack 2 (KB948109).

This was on my home PC, running XP Home Edition NL (which explains the Dutch in the error msg) and SQL Server 2005 Express SP2.

Share

Tags: ,

When you add your website to Google Analytics it tells you to add the tracking code right before the closing </body> tag.

Now, the website that I was adding was this WordPress blog so my first question was: where on earth (or server) is the PHP file that contains this closing tag?  And after a bit of PHP code reading I found it.

The file is called footer.php and this file is located in /wp-content/themes/[YOUR_THEME]/.  Being located in the themes folder this means you need to remember to re-add the code when you decide to change your theme.

Share

Tags: ,

Not so long ago I downloaded and installed RC0 for SQL Server 2008, its version number is 10.0.1442.32.  And now the RTM has been released, version 10.0.1600.22! (Yeah, I like version numbers :-) )

Following is an excerpt of Technet Flash newsletter Volume 10, Issue 16: August 6, 2008.  It contains plenty interesting links related to SQL Server 2008.  If you want to receive the newsletter yourself: register here.

Excerpt:

The wait is over. SQL Server 2008 has been released and is ready to deliver a rich set of integrated services that enable you to do more with your data, such as query, search, synchronize, report, and analyze. Many of you have been evaluating the SQL Server 2008 betas, and may be ready to try out the RTM version. TechNet Plus subscribers can find RTM versions now available for download. Speaking of TechNet Plus, read Keith Combs’ Blahg for his take on the UI improvements for the newly revamped TechNet Plus Subscriber Downloads page.

TechNet Magazine recently published an overview of the key changes and what you can expect from SQL Server 2008. You can also get a rundown of the various editions and components of SQL Server 2008 and take part in SQL Server 2008 tutorials.

For more overview resources, check out:

If you are looking for assistance with SQL Server 2008 planning and installation, here are some helpful links:

Once you’ve installed SQL Server 2008, these resources can help you optimize your database environment:

You can also find guidance for upgrading to SQL Server 2008 or migrating to SQL Server 2008. If you are upgrading, be sure to check out Using Upgrade Advisor to Prepare For Upgrades.
From our partners, you can find local partners offering SQL Server 2008 solutions or find training partners near you offering official Microsoft courses that will help you get certified on SQL Server 2008. In addition, you can search for local in-person events and online webcasts on SQL Server 2008.
And finally, from the August edition of TechNet Magazine, Paul Randal answers your SQL Server questions, showing you how to perform consistency checks, how to handle an accidental upgrade, and more in the SQL Q&A column.

Mitch Irsfeld
Editor, TechNet Flash

Share

Tags:

The other day I was looking for an alternative Reporting Services client, as an extra client besides the web-based Report Manager. As I couldn’t really find one I thought “how difficult could it be to write one myself?”.

And indeed, with the ReportViewer control in Visual Studio 2005 it’s really no big deal. All you need to do is drag the control onto a form, tell it that you want to load a remote report, configure the ReportServer so that it knows where to look for reports and the ReportPath so that it knows what report to load. Then call the RefreshReport() method to load the report.

When configuring the ReportPath, pay attention to the mandatory leading slash.

   1: reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
   2: reportViewer1.ServerReport.ReportServerUrl = new Uri("http://localhost/reportserver");
   3: reportViewer1.ServerReport.ReportPath = "/My Reports/ReportName";
   4: // load report
   5: reportViewer1.RefreshReport();

The C# code snippet above is loading a report called ReportName, located on the local report server in a folder called My Reports.

Update: how to browse the reports on the server

Microsoft has provided an interesting sample called RSExplorer as part of the SQL Server samples, located at CodePlex.  Once you’ve installed the samples you can find RSExplorer in C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Application Samples\RSExplorer Sample\, if you chose to install to the default folder.

The sample shows how to use the Reporting Services web service to populate a WinForms ListView with a list of folders and reports, and even how to do some basic management tasks like creating a folder or editing a report description.

When you double-click a report it will open in a popup window.  What I do find funny in this sample is that the popup window, called ReportViewer, does not use the ReportViewer control.  It uses a WebBrowser control  instead.

Share

Tags: , , , ,

© 2008-2017 BI: Beer Intelligence? All Rights Reserved