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 KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://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 KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://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