Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
swenri
Yak Posting Veteran
72 Posts |
 Posted - 2007-08-28 : 13:10:20
|
When ever I'm trying to deploy the reports on the report manager, I'm getting an error as mentioned below. I deployed few reports yesterday and last week. They are working fine but, when I deployed some new reports today I'm getting this error.
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'TSAW_SDS'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
How do I resolve it ?
Thank u all.... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-28 : 13:16:36
|
Have you verified that the data source works? Check Report Manager for the data source's parameters.
Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/ |
 |
|
|
swenri
Yak Posting Veteran
72 Posts |
Posted - 2007-08-28 : 13:25:58
|
I did check the data source. I'm using the radio button custom data source =Data Source=AMERDEVTEST1\REPORTING02;Initial Catalog =Portfolio.Report
and has checked the Credentials stored securely in the report server, yet I keep getting the same error.
Any inputs ??? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-28 : 13:37:09
|
Portfolio.Report doesn't sound right. Is that the name of your database?
Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/ |
|
|
|
swenri
Yak Posting Veteran
72 Posts |
Posted - 2007-08-28 : 14:01:55
|
| Yes, the name of the database is portfolio.Report |
|
|
|
|
|
|
Getting error while deploying reports