Service Account Configuration for Reporting Service

  Found a good MSDN article about configuring service accounts for SQL 2005 Reporting Service, see below.  One thing want to highlight is that for production, it is recommended to use domain accounts. Although the passord expiration needs to be managed, it is best practice for many organizations.   Configuring Service Accounts   The report…

1

Reporting Service Updates in SQL 2005 Service Pack 2

  SQL Server 2005 Service Pack 2 is coming out soon. The very important piece of SP2 is support of SSRS and SharePoint 2007 Integration. There are many bug fixes and enhancements in the service pack but here I want to highlight the integration with SharePoint 2007. The key functionalities include: SSRS & SharePoint Integration…

0

Use Reporting Service Itself to Monitor Customers’ Reporting Activities

    The list of reports requested in Requirement or Functional Specification by customers is one thing, the actual list of reports used for day-to-day business after Production is another thing. While we know customers have the challenges of changing business needs, how do we understand and measure what are the reports that are actually being…

4

“ARRA” Challenges in Today’s Enterprise Reporting

  For a long time, Reporting to most of organizations is known as “second tier” priority compare to “first tier” online transaction systems. This is still somewhat true in today’s business environment. However, Enterprise reporting is becoming increasingly critical in terms of the roles it plays in enterprise decision marking. It is not unusual that…

2

Using OfficeWriter as Report Designer

      If you have developed a solution using Reporting Service, the Report Builder is obvious choice for end user designing ad-hoc reports. In some situations, business users want to design a report, execute it, export the results back to excel, and then using Excel to format it. If these happen a lot, you…

0

Install SQL Server Reporting Service SP2 with Longhorn

     I have been trying to run SQL Server 2005 Reporting Service on Windows Longhorn but haven’t got enough luck previously. Today I finally got it right and here are the details I’d like to share with you.   1. The Proper Environment You need to have SQL 2005 Service Pack 2 CTP1 and Windows…

8

Different Types of Enterprise Reporting Needs

Most of organizations might be using different type of data reporting for these business needs but there are a lot of similarities too. Here are the various types of Enterprise Reporting I have collected so far:  List Reporting – The most common usage of Enterprise Reporting is the formatted displays or presentations of organizational data…

3

SQL Server 2005 Reporting Services Training Resources

  I have collected many free training resources here for people to learn about SQL 2005 Reporting. This list includes various levels of materials including some introduction and advanced topics. Please let me know if links don’t work or you have new links for me to add on. I’ll update them in future posts.    …

3

A Typical Enterprise Reporting Architecture

  The most typical implementation of Enterprise Reporting architecture includes the following four tiers: Client Tier – Business front-end application and technologies. Web Browser is the most typically UI interface for today’s enterprise and it is supported richly with SQL 2005 Reporting Service. Other client tier technologies might include custom applications, Office (Excel/Assess), SharePoint web portal…

0

What’s Enterprise Reporting and Why do I care?

There are many definitions for Enterprise Reporting from the Internet. To focus on the topic in this blog, my definition is, Enterprise Reporting is the capability for a corporation to enable information workers provide data and analysis to decision makers quickly and cost effectively by leveraging information available throughout and outside the enterprise. Every organization is probably doing…

1