We have SQL reporting services (2005) and have been using the reports there to help analyze cases and such from Discovery Accelerator. As part of a way to lighten the load per say on SQL servers and DA customer databases, I created a new SQL 2008 environment and have placed two new customer databases on that server.

Now, I would like the ability to create SQL reports based on information from those two new databases. The issue is that when I attempt to use the Report Builder, the only data models that I can see are the ones I already had. Does anyone know what I need to do to add new data models from the other database server?

Thanks.