Stacia's Business Intelligence Blog: Recent Comments

Comment on Configuring Reporting Services Security Correctly

Enders — Wed, 02 Jul 2008 09:58:53 GMT

Great document. However you miss one step. In step 5 you change the identity of the application pool to domain\user account. You must insert a step that that domain\user account is member of the local IIS_WPG. Too bad you stopped blogging

Comment on Configuring Reporting Services Security Correctly

Kaisa — Tue, 20 May 2008 06:23:55 GMT

Brilliant document! I've also had to deal with Kerberos issues over the past 2 years, and it's quite tricky to get it right. Your document is really helpfull, especially for finding the right words to tell the customer (or their hosting provider) what to do where.

Comment on Using a Single Package Configurations Table to Manage Package Execution on Multiple Servers

Stacia — Mon, 01 Oct 2007 09:59:56 GMT

Hi Matthijs - There are multiple ways to work with configurations. Environment variables are simply one way. Using a dtsconfig file is another way. Can you elaborate on how you are executing your SSIS package? For example, are you running from a command line or are you using a SQL Server Agent job?

Comment on Using a Single Package Configurations Table to Manage Package Execution on Multiple Servers

Matthijs — Mon, 01 Oct 2007 09:24:57 GMT

Hi,

I think it's a nice post, but I've got a question. Is it also possible not to use environment variables, but use .\filename.dtsconfig? Cause I switched to using this instead of an environment variable and it seems to work, only the strange thing is that after a while it's not working anymore. After a while SSIS was not able to find the config file :S... Hope you have an answer voor me. Thanks, Matthijs.