2008 SQL Reporting Services - The data source 'IVH_Records' cannot be found.

Today I moved my reporting services database(s) to another server. I was running 2005 Reporting services and I moved to 2008 Reporting Services.  I can view most reports with no problem. I have reports that are connected to one database that are a problem.

When I try to view the effected reports I get
>>>>>>>>
An error occurred during client rendering.
An error has occurred during report processing.
The data source 'IVH_Records' cannot be found.
>>>>>>>>
The real name for the database that cannot be found is 'IVH Records' (notice the space)
 
I am hoping someone can tell me how to find my database
What works with SQL Reporting Serves
Data Source=IVHxxx;Initial Catalog="IVH Records"
I tried..
Data Source=IVHxxx;Initial Catalog="IVH"&& nbsp ;&"Records"

Any ideas?

Regards,
Chris
ivh05Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Megan BrooksSQL Server ConsultantCommented:
Did you migrate from RS 2005 to RS 2008, moving to a new server in the process (http://msdn.microsoft.com/en-us/library/ms143724.aspx) or did you move an RS 2005 to a different server and then try to use the database from RS 2008? Did you follow the Microsoft migration or move procedure or some variation of it?
"Data Source" and "Database" are not necessarily equivalent. When you receive a "Data Source not found" message it means that the Data Source object on the Report Server was not found. It could be embedded in a report or it could be a shared data source (default location is "/Data Sources" but it could anywhere).
You might start with the report that is failing, looking on the Report Server. Using Report Manager, go to the report, select the Properties tab, and then click Data Sources. For shared data sources, make sure that there is indeed a data source by that name in the indicated location. For all data sources, check the database name and credential information.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ivh05Author Commented:
rscowden,
"Did you migrate from RS 2005 to RS 2008, moving to a new server in the process"

Yes... and all other reports are working fine except the ones that look at this database "IVH Records"...

(All other databases have no spaces in their names)
(most of the databases are on the same server as IVH Records)
(I have NOT verified that the space is the actual problem however)

- I'm done for the day but will look at the design of the report tomorrow - good suggestion
- Also I might make a new DB with a space in the name to see if the space is NOT the problem
- I will be looking at your comment with more detail tomorrow  

Thanks for trying to help me

Regards,

Chris

 
0
ivh05Author Commented:
rscowden,,
" did you move an RS 2005 to a different server and then try to use the database from RS 2008?"

I have the IVH Records DB on both servers and neither RS makes a good connection
0
Megan BrooksSQL Server ConsultantCommented:
One possible source of problems is if you are using shared data sources that point to database information that had to be updated during the migration (and was), but there is also a report somewhere that contains its own embedded data source that was not updated.
0
ivh05Author Commented:
"You might start with the report that is failing, looking on the Report Server. Using Report Manager, go to the report, select the Properties tab, and then click Data Sources. For shared data sources, make sure that there is indeed a data source by that name in the indicated location. For all data sources, check the database name and credential information."  

Awesome... going into the report design; through the data source settings and reloading to the new server fixes the broke reports... Thank-You!

Regards,

Chris  
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.