Getting the permissions right – SSRS in SharePoint Integrated mode

Recently, I was working on securing SSRS reports when running in SharePoint Integrated mode.  Two settings came back to bite me, so I thought I would blog about them.  You probably already know this, but it is one of those things that you scratch your head over until your memory kicks in.  Anyway, I hope…

3

SSRS reports fail after SharePoint host header change

I came across this issue on a project the other day.  Hopefully this will save someone some time.  While we were waiting for the customer’s DNS czar to add an entry for our SharePoint dev site, we had created a hosts file entry and set up the site using a host header (for sake of…

0

Adding a custom column to Site Settings

Many of you have probably encountered the need in SharePoint 2007 to add custom links to the “Site Settings” page.  Odds are, you probably dropped your links in the “Site Administration” column.  This works fine if you only have a link or two.  What happens when you need to add a number of links?  The…

0

Using the database view to simplify SSIS packages

On a couple of my recent projects, I was responsible for developing the SQL Server Integration Services (SSIS) packages to load data into a data warehouse.  SSIS is no different than any other development activity in that there are any number of ways to do the same thing.  One of the techniques that worked really…

0