SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


ssrs 2012 rdl connect to data source


ssrs 2012 rdl connect to data source

Author
Message
wendy elizabeth
wendy elizabeth
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1261 Visits: 775
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?
Scott Murray-240410
Scott Murray-240410
SSC-Addicted
SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)

Group: General Forum Members
Points: 411 Visits: 3118
Do you have SystemAdmin privledges under Site Settings > Security?
MMartin1
MMartin1
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2857 Visits: 2031
Have you tried to connect to the reporting service through management studio? Are you able to to see the reports folder there?

----------------------------------------------------
How to post forum questions to get the best help
wendy elizabeth
wendy elizabeth
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1261 Visits: 775
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?
Scott Murray-240410
Scott Murray-240410
SSC-Addicted
SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)SSC-Addicted (411 reputation)

Group: General Forum Members
Points: 411 Visits: 3118
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?

MMartin1
MMartin1
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2857 Visits: 2031
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.

----------------------------------------------------
How to post forum questions to get the best help
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search