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

RS Scripter - Losing credentials when deploying Expand / Collapse
Author
Message
Posted Tuesday, October 9, 2012 3:04 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, October 9, 2012 3:08 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:10 PM
Points: 6,237, Visits: 7,392
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
Posted Tuesday, October 9, 2012 3:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, October 9, 2012 4:04 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:10 PM
Points: 6,237, Visits: 7,392
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
Posted Tuesday, October 9, 2012 4:34 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, August 25, 2014 3:51 PM
Points: 1,787, Visits: 5,694
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


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #1370615
    Posted Wednesday, October 10, 2012 9:20 AM
    Forum Newbie

    Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

    Add to briefcase

    Permissions Expand / Collapse