August 15, 2008 at 9:18 am
We have reports using a shared data source on the report server. The reports were created with that data source referenced. However now we have to switch servers, the database names and structures are all the same but the server name is not.
Is there a way to re-sync the existing reports to a new shared data source without having to re-edit every report? The new data source could obviously have the same name as the old, however the connect string between the new and what is referenced in the reports would be different, as would be the login information.
I noticed that in the report XML files, there is a datasourceID. Is this a GUID that the engine checks?
And can it be reset to a new datasource?
Thanks in advance!
August 15, 2008 at 3:42 pm
Why can't you just update the data source with the new server name?
August 15, 2008 at 4:07 pm
It gives a "An error has occured during report processing
Query execution failed for data set '...' ". When I use the data source in report manager after changing the connection string but retaining the name.
August 15, 2008 at 4:33 pm
Is this a "new" datasource with an existing name?
You are correct in that Reporting Services keeps track on things by some sort of ID......perhaps a GUID. I haven't tried to hack this and make the RDL work.
Can you just redeploy the original datasource with the updated connection string?
August 18, 2008 at 9:48 am
It works now! What happened was that we were not using the SA password for the data source (as we didn't know it). We subsequently found the new SA password and changed the old data source to point to the new database with the SA password and now everything works.
The old data source was also using the SA password.
Security wise this is probably not the best practice. Is there a better way to set up rights for reporting services data sources?
August 19, 2008 at 9:23 am
Wow.........security is a very broad topic! You are right, it is definitely not a good practice to be using the SA login/password for this. Integrated Windows Security is (I believe) the default SSRS configuration and the suggested method of authentication. However, if you are storing you login information in the DS on the Report Server, I would recommend that you create an account with fewer priviledges and use it for report access.
July 14, 2010 at 4:34 pm
There is an application (SSRS Data Source Manager) that can fix missing data sources, and change current data sources for RDL reports and models. It can be used to change a single report / model or allow bulk changes for many reports and models.
There is also a health check feature, to detect and correct reports and models that have missing data sources. Multiple data sources for reports and models are also supported.
July 15, 2010 at 1:53 am
Hi,
i have created one new dimension in cube and this cube is utlizing in SSRS report. after successully adding in the cube as dimension and able to browse from cube browser but can't able to see this dimension in SSRS Cube dataset.
any idea that how i incorporate new dimension in SSRS existing cube dataset.
thanks in advance.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply