Configuring a Service Principle Name (SPN) for an SSRS application pool

In my last post I talked about associating the SQL Server 2005 Reporting Services (SSRS) application pool with a domain service account rather than NETWORK SERVICE to enable access to a data source outside a firewall.  One thing I forget to talk about that warrants a bit more detail is the need to register a Service…

2

Connecting to Data Sources outside a Firewall with SQL Server 2005 Reporting Services

In my last post I discussed how to configure database security on two SQL Server 2005 instances outside a firewall to enable operational reporting.  In this post I’ll examine the security configuration of the SQL Server 2005 Reporting Services (SSRS) instance inside a firewall to be used for operational reporting.   To quickly review the…

0

Hot Standby Security Configuration for Operational Reporting

In my last post I talked about how I used SQL Server 2005 log shipping to create a hot standby of the Airframe production database to be used for both disaster recovery and as a data source for operational reporting.  In this post I’ll discuss how to configure security on the production and hot standby…

0

Log Shipping and Operational Reporting

In my last post I introduced the first phase of the Airframe RA project called Operational Reporting.  The gist of this phase is to augment an existing production system, in this case Airframe, with some quick and dirty reports to help everyday users of the system within Microsoft get their jobs done a bit easier….

2

Reporting and Analytics Dogfood – Intro

Well I have to apologize for my long absence.  I’m just not a very consistent blogger.  I’ll just have to do better.  Here’s the good news: you won’t see any smarmy posts from me about my personal life, I prefer to be a nameless / faceless Microsoft automaton ;-).  Now that SQL Server 2005 has…

0