Using Report Server, but access to SQL 2005 data a problem

I'vemigrated data from SQL 2000 -> SQL 2005 (retaining SQL 2000 JIC). Ihave changed referencesandthe web-site is overall functional (under DNN)EXCEPT FOR Report Server/Report Managerrendering of reports.

I've changed Report Manager's connections, catalog, user credentials, etc. in keeping with the new requirements ofSQL 2005(of course, different from previous SQL 2000 settings)

Still nothing works.

I have to ask -- isReport Server is somehow restricted from accessingSQL 2005?

Report manager gives this as an indication as a possibility (even when I change to ask RM's data source to prompt for user credentials)?

TIA

 

Hi:


Thanks for responding.


Idid makea trouble ticket and a second (providinggreater clarity) after I performed other experiments to ensure/minimize the possibility that the problem was not at my end.


Tech support escalated the problem to the d.b. administrator. The problem was eventually resolvedand was identified as an < unspecified > network issue.