Hello dguillory,

Glad you like the solution. I cover SQL authentication for DMZ and such environments in the February issue of SQL Server Magazine. Essentially, it is just creating a new data source and storing the password for the SQL auth account. The trick is with running this under SQL Agent and having the appropriate package protection level set. I typically use store encrypted with user name and let the SQL Agent account service credentials decrypt the package and run successfully.

You will need to add seperate job steps tied to the data source, just dupicates, really, but they will run after the Windows authenticated portion doing the same steps.

Again...thanks for your feedback.

Rodney Landrum

Author "Pro SQL Server 2008 Reporting Services" (Apress)