PDA

View Full Version : Using Report Server, but access to SQL 2005 data a problem


financialme
10-28-2006, 08:23 AM
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

bruce
10-31-2006, 11:46 AM
that's strange!! can you create a support ticket?


Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

bruce
11-01-2006, 01:26 AM
lol.. well at least it is working.


Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

financialme
11-01-2006, 12:26 PM
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.