Gift Peddie (2/6/2009)
SQL Server Reporting Services dropping the DataSource permission is also a known issue you could open your RDL files in the designer and check the connection property it is usualy empty so you have to add the permissions back again.
I am assuming this is your problem if not you could run test runs before fixing your problems in production.
Yes, I have to go to every data source and pick the radio button named "Windows Integrated Security".
It's a workaround, but not a great one.
The big question is, why the SQL-2005 encryption key does not work with the SQL-2008 install.
I have not used any Enterprise-ed. features in the sql-2005 installation, so the encryption key should have been acceptable to the sql-2008 installation.
I wonder if this is a bug I should open with MS.
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]