Tough question...should've been a 4 pointer...anyone have any referencing links for this?

http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx

Ask how burdensome it is for users to have more than one password and userid? Ask him how burdensome it is to reset non AD passwords people forget. ...

Good question because it made us think....I missed it, but I learned something which is really the point....It's very tough to cover all your bases on these questions.... 😀

Let's go back to the overused analogy of building a house. If you tell a carpenter to build a house that can't be broken into or that is impervious...

I appreciate you sharing that process. I'm not familiar with it, but it sounds like something I'll research. I'm wondering if there's a windows patch or sql server...

Very good. Thanks for posting your answer....It's funny and it happens to me a lot, asking the question helps us find our own answers sometimes.....

Jurgen,

I've always stored credentials on the report server....any reasons other than the older ones aren't set up that way for not doing it?

Another thread today with almost the...

This may not be a best practice (I'd be interested on your feedback about that) but it works. I always choose 'custom data source' and 'credentials stored securely in...

I see two "from"s for one select statement...It looks like the "from" in the subselect is misplaced

I was under the impression that collation was a database wide setting. I have heard of instances where this caused some terrible overhead problems. Sounds like I have...

this maybe useful too:

http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/cc2bbf01-4eef-4a42-8c3e-aa41b78b6387/

We're new to SQL Reporting Services and have a new SQL 2005 server.

I'm having a problem activating scubscriptions.

- "New Subscription" is greyed out in Server...

Have you ran the "reporting services configuration" tool on the server?

"start, programs, sql server 2005, configuration tools"

Do you see a "New Subscription" button?

There's an option for deployment that overwrites the datasource which blows away the stored credentials, but I have not heard of it happening on a reboot....are any new deployments happening...