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 |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2014-08-16 : 12:07:11
|
| On a ssrs 2012 reporting server, I want to install load uploaded rdls to a test report server. The rdls load correctly, however the 'manage' dropdown list is not working. I need these rdls to connect the specific datasources. To solve my problem of needing to be able to connect the rdls to the appropirate datasopurces, I have the following questions:1. Can you tell me what I can do to get 'manage' dropdown list is work? If this option does not work, do you have other options on how I can get this 'manage' option to work?2. Is there another way I can connect the rdls to the correct datasources? If so, what are they? Should I just have the datasource setup correctly in the rdl so this change does not need to occur on the report server? 3. If there is a problem with connections on the test report server, what should I check on? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-08-18 : 12:23:34
|
| Your reports should be pointing to a data source name that will not change. Then when you move the rdl files between environments, you only need to update the data source and nothing else.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
accessing rdls on test report server