October 9, 2008 at 4:05 pm
I've been struggling with this all day, and here's where things sit now.
1) I've installed SSRS onto our new Windows Server 2003 (it wasn't initially installed).
2) I've re-applied service pack 2 for SQL Server 2005, so that it will update SSRS.
3) I was having a lot of problems with the initialization of SSRS,and after Googling the problem it looked as though I would have to remove the encryption keys which seemed to finally allow me to initialize SSRS.
4) Then I specified our "sa" account and password. (Actually steps 3 or 4 might be reversed.)
Now, when I attempt to run one of our SSRS reports I now have to enter a username and password (which makes sense) and then I get the following error message:
An error has occurred during report processing.
Cannot create a connection to data source 'DataSrcClientData'.
So, now I'm at a loss as to what's wrong or how to fix it. I'd appreciate some help, please.
Kindest Regards, Rod Connect with me on LinkedIn.
October 9, 2008 at 8:53 pm
When you reset the encryption key, you should have received a warning that encrypted data would be deleted. This means that you will have lost part of connection string (e.g passwords).
Open each data source and set the passwords and you should be OK
October 10, 2008 at 8:33 am
I also found that I have to change the OverwriteDataSources property in the SSRS project. Be default it is set to false, which meant that even though I changed the server, SQL Server account and password, it didn't get propogated to SSRS on the server until I changed the OverwriteDataSources property.
Kindest Regards, Rod Connect with me on LinkedIn.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply