July 22, 2014 at 8:18 am
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?
July 23, 2014 at 5:20 am
Do you have SystemAdmin privledges under Site Settings > Security?
August 14, 2014 at 10:58 am
Have you tried to connect to the reporting service through management studio? Are you able to to see the reports folder there?
----------------------------------------------------
August 14, 2014 at 9:42 pm
In answer to your questions and with my additional questions:
1. SystemAdmin privledges under Site Settings > Security , can you tell me what I am looking for by having this access?
2. Can you tell how to connect to the reporting service through management studio? The report server is sql server 2008, however the data is either sql server 2008 or sql server 2012? Would this make some kind of a difference? If so, what would I check for?
3. I am the only one who has been using this particular report server and my application access the report server with vb.net 2010 web forms. I have 'stepped through the code' up until when the report server call is actually made. The report server connection is what I expect it to be.
4. Is there some kind of a setting on the test report server that can be wrong? If so, what should I look for?
August 15, 2014 at 5:32 am
wendy elizabeth (8/14/2014)
In answer to your questions and with my additional questions:1. SystemAdmin privledges under Site Settings > Security , can you tell me what I am looking for by having this access?... this would give you overall access to manage security and ssrs.
2. Can you tell how to connect to the reporting service through management studio? The report server is sql server 2008, however the data is either sql server 2008 or sql server 2012? Would this make some kind of a difference? If so, what would I check for?
You say initially it is SSRS 2012.. To connect, you just change the server type to reporting services.
3. I am the only one who has been using this particular report server and my application access the report server with vb.net 2010 web forms. I have 'stepped through the code' up until when the report server call is actually made. The report server connection is what I expect it to be.
4. Is there some kind of a setting on the test report server that can be wrong? If so, what should I look for?
August 15, 2014 at 5:40 pm
wendy elizabeth (8/14/2014)
In answer to your questions and with my additional questions:1. SystemAdmin privledges under Site Settings > Security , can you tell me what I am looking for by having this access?
2. Can you tell how to connect to the reporting service through management studio? The report server is sql server 2008, however the data is either sql server 2008 or sql server 2012? Would this make some kind of a difference? If so, what would I check for?
3. I am the only one who has been using this particular report server and my application access the report server with vb.net 2010 web forms. I have 'stepped through the code' up until when the report server call is actually made. The report server connection is what I expect it to be.
4. Is there some kind of a setting on the test report server that can be wrong? If so, what should I look for?
I can tell you that in Management Studio, use object explorer > "connect" drop down, choose Reporting Services and enter the name of the server it is hosted on. (You may have to enter a name like ReportServer$instanceA if you are using named instances). It would make no difference the versions. OLE DB connections can pull data from any OLE compliant source (that includes sql server of course).
What do you mean by stepped through the code?
Lets start here and see if we need to go to your configurations setting after, we'll do that.
----------------------------------------------------
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply