Where is my ecryption key gone?

As I stressed out in one of my previous posts and my book, it is an absolute must that you back up the RS encryption key as one of the first steps after you install RS and lock it up in a safe place. You can back up the encryption key this by using the rskeymgmt utility as follows:

rskeymgmt -e -f <filename> -p <password>

Trust me on this–sooner or later you will need that key. One situation when you will definately need it is after resetting the ASP.NET account either by explicitly invoking aspnet_regiis.exe or when installing a new version of the .NET framework. For example, recently I installed .NET Framework Beta 2 which effectively reset the ASP.NET account. This caused RS to invalidate the encryption key. As a result, when navigating to the Report Manager, I got the dreaded error:

“The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service.”

Panic will not help resolve this issue, but a copy of the encryption key will definetely help. Here are the steps to reset the encryption key if the ASP.NET account is reset:

  1. Recall where you saved the RS key. If you haven’t saved it or you can’t recall, try to extract the key by issuing
    rskeymgmt -e -f <filename> -p <password>

  2. Open the RSReportServer.config file and copy the installation ID GUID from the InstallationID node. The InstallationID node looks like this:

  3. Delete the references to the old RS encyption key:
    rskeymgmt -r <installation id>

  4. Restart IIS and the Report Server windows service.

  5. Reapply the encryption key:
    rskeymgmt -a -f <filename from step 1> -p <password>

This should fix the error and you should be able to navigate to the Report Manager without any issues.

If you don’t have a backup copy of the key and you cannot extract it with rskeymgmt -e, than the only option is to delete the ecrypted content by issuing rskeymgmt -d

The net effect of this is that you will need to reenter the credentials of all data sources that use standard security because the credentials are stored in encrypted format.

You better watch out…SP2 is coming to town

While we still have to wait for a couple of more months to get the official release, Santa is giving us a Beta preview of the forthcoming RS 2000 SP2.

Key new features include:

  • Reporting Services SharePoint Web Parts enable you to explore and view reports located on a report server by using Microsoft Windows SharePoint Services or SharePoint Portal Server. A set of Reporting Services SharePoint Web Parts are installed with SP2. These Web Parts are called Report Explorer and Report Viewer. Using Report Explorer, you can browse available reports on a report server. Using Report Viewer, you view reports hosted on a report server. Included with Report Explorer is a subscription function that allows you to receive reports by e-mail. Both Web Parts are optimized to run within the SharePoint environment; however, they can be run as standalone components also.
  • Yes, the wait is over! SP2 comes with a brand new Microsoft ActiveX control  to support a rich client-side printing experience and allow users can print reports directly from Internet Explorer. To support this functionality, a downloadable ActiveX control is used. The control’s .cab file is hosted on the report server and is downloaded by the client on request. When you request a report, the HTML viewer returns the report along with a toolbar for navigation. The toolbar contains a print button that displays a print dialog box when clicked. Using the dialog box, you can make standard Windows printing selections including orientation, page size and page range. When the printer settings are selected, you can select Print to print the entire report or a range of pages within the report, or Preview to preview the report in a separate preview pane.

In addition, SP2 will include numerous bug fixes as outlined in Microsoft Knowledge Base article 889640 (http://support.microsoft.com/?kbid=889640).

For instructions how to subscribe to and get SP2 Beta, please read http://support.microsoft.com/kb/889641.

Merry Christmas!

A case for self-publishing

An interesting trend has been building momentum recently which has caught my attention. More and more authors are choosing self-publishing as a viable option to commercial publishing. Interestingly, I haven’t come across a technical author who is happy with commercial publishers and has good things to say about them. Although I am not excluding the probability that there may be a few enlighten commercial publishers, the common pattern for aspiring authors is as follows.

In the worst scenario, the author doesn’t find a publisher that is willing to carry the book. Even if the author does find a publisher, things are not much better since the odds are stacked against the author. Hardly believing the incredible luck that a well-established publisher would actually debase itself to express interest in the author’s idea, the author signs a contract without much negotiation fearing that any opposition may be a deal-breaker. And it very well may be despite that the author may have valid concerns about his or her rights. A case in point — Recently, I argued with a commercial magazine publisher that there is really no legitimate reason for them to own my article copyright and the publisher dropped me like a hot potato despite the fact that the article has almost made it to the press.

As a result of the author less advantageous position, the publisher is well-positioned to take a maximum advantage of the author. Thus, with a stroke of a pen, the book copyright goes usually to the publisher whose position is further fortified with non-compete clauses of all sorts which sole purpose is to lock in the author as much as possible. At the end, the readers are the ones suffering the most since in most cases they will never see a new edition of their favorite book.

Next, the author sweats and burns midnight oil for half a year or more to get the book out. This includes authoring the manuscript, graphics, including indexing the book, organizing tech reviews, even marketing the book. The publisher responsibility is orchestrating the copy-editing, book cover and typesetting activities. These activities in my opinion don’t constitute more than 20% of the overall book effort. Yes, to the publisher’s credit, the publisher also makes an investment to get the book printed and distributed which may account for say 15K.

What does the author gets in return for his heroic effort? If all is well, the author typically gets around 10% as a royalty payment from the net (not retail mind you) price of the book which may result in 10-15K spread over the course of the book lifecycle (say 2 years) if the author is lucky and the book sells well. You may think that well-established authors are in much advantageous position but my feedback from fellow peers show otherwise. Of course, a well-established author is in much better position to negotiate a more favorable contract since the author would usually has a broader choice of publisher to choose from.

So, you don’t have to have an MBA degree to realize that there is something wrong with this model from the author’s perspective. As though it is only the author who needs the publisher…not the other way around.

What the author can do? Enters self-publishing.

It turns out that if the author is willing to undertake the last 20% of the book journey and make an investment to print and distribute the book, the author could in fact break the vicious publishing cycle and take full advantage of the fruit of his or her hard labor. And, there are more and more technical authors that are taking this road. The rewards are substantial from entrepreneurial, legal, and financial standpoints.

For example, Brian Bishof (http://www.crystalreportsbook.com/) has been very successful in self-publishing his books. In fact, his latest book (http://www.amazon.com/exec/obidos/tg/detail/-/0974953652/qid=1102890581/sr=8-5/ref=pd_csp_5/103-3694991-3165408?v=glance&s=books&n=507846) is selling better than mine according to the Amazon rating system. This is strange considering the fact that he’s writing about a competing and inferior technology-to Reporting Services :-). See what Brian has to say about self-publishing (http://www.crystalreportsbook.com/selfpublishing.asp).

Another self-publishing author is Minh T. Nguyen who wrote the Visual Studio.NET Tips and Tricks book (http://msdn.microsoft.com/vstudio/using/Books/default.aspx). He was kind enough to share his experience with me and it turns out that he also has only good things to say about self-publishing.

Based on my research, I am convinced that when done well self-publishing is a viable alternative to commercial publishing without sacrificing the book quality or market penetration. There may be still a stigma about authors who are self-publishing their books but things are changing. In fact, I believe self-publishing will change the publishing landscape as we know it.. and for better!

Get a sneak preview on RS 2005 and more…

Brian Welcker, Group Program Manager for Reporting Services, will do a
webcast on RS 2005 tomorrow at 10 am pacific time. Don’t miss this opportunity to learn about the new features in RS 2005 from the ultimate authority on this subject.

You can subscribe to the event by following this link https://msevents.microsoft.com/cui/WebCastRegistrationConfirmation.aspx?culture=en-US&RegistrationID=5154053.

There are more webcasts scheduled for tomorrow later during the day including Integration Services (aka DTS) and Analysis Services 2000.

Get a sick day tomorrow or a day off and don’t miss tomorrow’s webcast rollercoaster ride :-(

The road ahead

Many folks have been asking me about the book authoring process. “Oh, you’ve authored a book” they will gasp. Once the awe evaporates, questions start. How did you do it, how long it took, what’s the royalty fee (the most popular but usually asked last question for courtesy reasons I suppose :-). For there reasons, I would like to start a new blog category devoted on writing.

In the spirit of the season, I am reflecting on the ending year and charting plans for the future. As you probably know, Microsoft is working hard on the next release of Microsoft Reporting Services which will coincide with SQL Server 2005 scheduled for an official release during the summer of 2005.

One of the things I am currently contemplating is whether to write a new book on Reporting Services 2005 or not. Based on my preliminary study and knowledge of the new RS feature set, I could add/replace about 50% of my old book content. Many of you have given me rave reviews about my book “Microsoft Reporting Services in Action”. Thank you for that! However, I know that the book is far from perfect and many things could have been improved.


Please help me decide if you thing that a new revison of my book could be useful and, if yes, how I can design my next book to better meet your needs.

  1. Do you think a new book on Reporting Services 2005 could be useful?

  2. Should the book be targetted as an updated version of my old book or should it focus more on the new product features.

  3. What areas of my old book need improvement?

I welcome your suggestions. If you prefer drop me an e-mail offline to teo.lachev@prologika.com.


Thank you advance!

And the MVP award goes to…

I would like to share my excitment with you that Microsoft has recognized my contribution and peer support around Microsoft SQL Server Reporting Services.

Today, I received the valuable Microsoft Most Valuable Professional (MVP) award for Windows Server System – SQL Server. This represents a major milestone in my professional career as a consultant and trainer.

Thank you for helping me to achieve this status!

Vote for my book

If you liked my book “Microsoft Reporting Services in Action” please take a moment to vote for it at the Second Annual .NETDJ Readers’ Choice Awards website.

Thank you in advance for your support!

Export to Excel and Word with SoftArtisians’ OfficeWriter

Version 1.0 of Reporting Services doesn’t support exporting reports to Microsoft Word format. It does support exporting to Excel but developers have limited control over the Excel renderer. For example, you may need provide placeholders (bookmarks in Word or markers in Excel) which will be populated during runtime with fields from your report query.

SoftArtisians will release soon an RS version of their flagship product OfficeWriter which will bring flexible exporting to Excel and Word formats in the form of two additional rendering extensions. Currently, you can try out this product by subscribing to the SoftArtisians beta program here.

You will most likely find the process of creating a Word or Excel report with OfficeWriter very straightforward. For example, to create a Word report you need to:

1. Create a new Word file.

2. Using the SoftArtisians Word toolbar set up a new query. Unfortunately, the query is not saved in the Word file so you have to recreate it every time you need to make a change.

3. Create bookmarks in your Word document by inserting fields from the query. OfficeWriter supports repetative regions which allows you to generate tabular reports.

4. Deploy your report to Report Server. During this step, OfficeWriter will generate the report RDL file which you will find in the same folder where the original Word file is located.

Without a doubt, many report authors will find OfficeWriter useful when report requirements call for flexible rendering in Excel and Word.


Extending Microsoft SQL Server 2000 Reporting Services with Custom Code

In this article, I will show you how to leverage the Reporting Services unique extensible architecture to supercharge your report capabilities. First, I will explain how embedded and custom code options work. Next, I will show you how you can leverage custom code to author an advanced report with sales forecasting features.

Read the full article here