This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
bbarton11
Level 5
‎Feb 18, 2013 11:32 PM

Configuring Data Source Settings in SSRS

Hi All,

I have a question regarding Data Source settings in for SSRS. Can they be configured in InstallShield Spring 2012? I basically just need to change the connection type. Right now I'm going into Data Sources, right-clicking the data source, clicking "Manage" then changing the radio button for "Connect Using" to "Windows integrated security". If I can do that in the packaging app, that would be great.

Thanks so much,
Brian
Labels (1)
Labels
0 Kudos
(3) Replies
rrinblue22
Level 9
‎Feb 19, 2013 01:59 PM

you may look into System Configuration >> ODBC resource in InstallShield MSI project.
this might help you.
0 Kudos
bbarton11
Level 5
‎Feb 21, 2013 10:45 AM

rrinblue22 wrote:
you may look into System Configuration >> ODBC resource in InstallShield MSI project.
this might help you.


Thanks for responding. Looks like your answer is for configuring ODBC datasources, I'm looking to modify/configure SSRS datasources.

Still looking for this information.

Thanks!
0 Kudos
Christopher_Pai
Level 16
‎Feb 21, 2013 06:43 PM

At least in SQL 2005/2008, SSRS exposes it's API as a web service. I've written custom tables to drive custom actions to call the web service and invoke the methods needed to define directories, datasources and reports. There is nothing built-in to MSI or InstallShield to handle this.
0 Kudos