<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Reporting Services
»
Reporting Services
»
RS Scripter - Losing credentials when...
RS Scripter - Losing credentials when deploying
Rate Topic
Display Mode
Topic Options
Author
Message
jeremyisaacs
jeremyisaacs
Posted Tuesday, October 09, 2012 3:04 PM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, October 10, 2012 9:13 AM
Points: 3,
Visits: 30
So I've started setting up RS Scripter to do my team's SSRS deployments from Dev -> QA -> Production. However, I've now noticed after deploying reports from one environment to another, all of the passwords have been lost on my embedded datasources. We have many reports and having to type in the credentials on every deployment is going to be painful. Is there any way around this?
A quick note. My connection strings are dynamic so I cannot use shared datasources. They must be embedded.
Thank you for any advice you can give.
Post #1370587
Evil Kraig F
Evil Kraig F
Posted Tuesday, October 09, 2012 3:08 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 8:32 PM
Points: 5,672,
Visits: 6,113
jeremyisaacs (10/9/2012)
A quick note. My connection strings are dynamic so I cannot use shared datasources. They must be embedded.
I don't have a workaround to the specific problem but perhaps there's other approaches. Why are you using dynamic connection strings here?
- Craig Farrell
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions
|
Forum Netiquette
For index/tuning help, follow these directions.
|
Tally Tables
Twitter: @AnyWayDBA
Post #1370588
jeremyisaacs
jeremyisaacs
Posted Tuesday, October 09, 2012 3:11 PM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, October 10, 2012 9:13 AM
Points: 3,
Visits: 30
The data for each of our clients may be stored on seperate SQL Server instances so we pass in the server name and database name per client. Some clients demand their own physical box for data storage and we try to accommodate them :)
Post #1370591
Evil Kraig F
Evil Kraig F
Posted Tuesday, October 09, 2012 4:04 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 8:32 PM
Points: 5,672,
Visits: 6,113
jeremyisaacs (10/9/2012)
The data for each of our clients may be stored on seperate SQL Server instances so we pass in the server name and database name per client. Some clients demand their own physical box for data storage and we try to accommodate them :)
Ah, and they're all coming in via the same interface I take it.
Ummm... errr... ummm... hmmm. Get back to you on that if I think of anything.
- Craig Farrell
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions
|
Forum Netiquette
For index/tuning help, follow these directions.
|
Tally Tables
Twitter: @AnyWayDBA
Post #1370604
mister.magoo
mister.magoo
Posted Tuesday, October 09, 2012 4:34 PM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 7:10 AM
Points: 1,289,
Visits: 3,858
I have a question - how are you supposed to deploy from DEV->QA->PROD with embedded credentials/data sources?
They will surely need to be different for each?
Also, wonder about the security of embedded connections - makes it rather easy for a bad person to get into the data if they get their hands on the report - which RS Scripter makes rather easy to do...
MM
Post #1370615
jeremyisaacs
jeremyisaacs
Posted Wednesday, October 10, 2012 9:20 AM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, October 10, 2012 9:13 AM
Points: 3,
Visits: 30
The server name and database are passed in as parameters to the report and used in the connection string. However, we are using the same sql account for authentication across servers. We could not use Windows auth due to an NTLM double-hop issue.
The thing I find interesting about this problem is if I deploy a report directly to the server via BIDS all of the credential information is maintained. So it is certainly possible to transfer a report with embedded datasources and maintain the credentials. So what is BIDS doing to keep the credentialling info that RS Scripter isn't?
Post #1371005
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
