October 9, 2012 at 3:04 pm
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.
October 9, 2012 at 3:08 pm
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?
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[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 9, 2012 at 3:11 pm
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 🙂
October 9, 2012 at 4:04 pm
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. 🙂
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[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 9, 2012 at 4:34 pm
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
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);October 10, 2012 at 9:20 am
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?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply