Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ssrs 2012 rdl connect to data source Expand / Collapse
Author
Message
Posted Tuesday, July 22, 2014 8:18 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 25, 2014 11:17 AM
Points: 377, Visits: 446
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?
Post #1595101
Posted Wednesday, July 23, 2014 5:20 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 7:14 PM
Points: 243, Visits: 2,736
Do you have SystemAdmin privledges under Site Settings > Security?
Post #1595420
Posted Thursday, August 14, 2014 10:58 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 6:40 PM
Points: 421, Visits: 1,000
Have you tried to connect to the reporting service through management studio? Are you able to to see the reports folder there?
Post #1603388
Posted Thursday, August 14, 2014 9:42 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 25, 2014 11:17 AM
Points: 377, Visits: 446
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?
Post #1603560
Posted Friday, August 15, 2014 5:32 AM This worked for the OP Answer marked as solution
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 7:14 PM
Points: 243, Visits: 2,736
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?
Post #1603643
Posted Friday, August 15, 2014 5:40 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 6:40 PM
Points: 421, Visits: 1,000
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.
Post #1603939
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse