Problem Connecting to sql2000 via RS2005

Hello Everyone,
First, I have done a search for this problem already, but have not been able
to find exactly what I'm looking for.
I know that you can connect to a sql2000 db from RS2005. However, when I try
to run a report from the 2005 report manager I get this message;
"An error has occurred during report processing.
Cannot create a connection to data source 'CommerceCenter'.
For more information about this error navigate to the report server on the
local server machine, or enable remote errors"
CommerceCenter is the datastore for the report i created using VS2005. I
have the credentials to connect to the db.
What am I doing wrong?
Thanks.Hi Damon:
Did your upgrade from RS2000 to RS2005 cause this issue? If so, and you
didn't backup and restore your encryption key according to the instructions,
you may need to re-set all of your datasources.
You might need to re-input any stored passwords you have set up.
If you are not doing so, I highly suggest you use Shared DataSources. It
makes for one-stop shopping for all of your reporting data needs!
Hope this helps. Good luck.
Todd C
"Damon Johnson" wrote:
> Hello Everyone,
> First, I have done a search for this problem already, but have not been able
> to find exactly what I'm looking for.
> I know that you can connect to a sql2000 db from RS2005. However, when I try
> to run a report from the 2005 report manager I get this message;
> "An error has occurred during report processing.
> Cannot create a connection to data source 'CommerceCenter'.
> For more information about this error navigate to the report server on the
> local server machine, or enable remote errors"
> CommerceCenter is the datastore for the report i created using VS2005. I
> have the credentials to connect to the db.
> What am I doing wrong?
> Thanks.