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 |
|
icw
Constraint Violating Yak Guru
378 Posts |
 Posted - 2009-01-08 : 07:10:16
|
Hi I've created 2 reports today. Both with SQL credentials bound into the datasource.Both reports run fine in BIDS. So I know the connection string is good.When I deploy them and try to run them from the report manager i get the following error...An error has occurred during report processing.Cannot create a connection to data source 'SSDS'.An internal error occurred on the report server. See the error log for more details. I have looked in the evnt viewer and found nothing of note and have looked in C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles and found no logs dated 2009 at all. So I cannot see a detailed error message anywhere.All my other reports work. The only difference with the two created today is that they are both looking at data on a SQL 2000 database. All of the others are on SQL 2005. |
|
|
icw
Constraint Violating Yak Guru
378 Posts |
Posted - 2009-01-08 : 07:51:00
|
| I've just copied one of the problem reports and connected it to a SQL 2005 database and it runs no problem.So it appears to me that using SQL 2005 reporting services you can't connect to SQL 2000 databases.Am I right in that assumption?Or maybe there is some thing I can do to make this work with SQL 2000?TIA |
 |
|
|
|
|
|
Cannot create connection to data source