June 8, 2011 at 9:55 am
Hey everyone.
Hoping that I can get some help with this.
We are building out a SSRS reporting system. We are going to be replicating data to a report server for a number of databases. Our software will be passing parameters into SSRS for dynamic connection string so that each of the applications tied to the specific database can reach the correct database on the report server. We are using 2008 R2.
What I am having issues with are the credentials. We do not use Windows Authentication for our stuff, but rather SQL Logins. As such, I am trying to figure out how to pass the security permissions through when I connect to the server w/o requiring that the user get promted for a login/password. This really can't be done as it is an application and their entire application uses one login.
So currently my dynamic connection string looks like this:
="Data Source= " & Parameters!ServerName.Value & ";Initial Catalog=" & Parameters!DatabaseName.Value
I have tried doing something like this, but it doesn't work.
="Data Source= " & Parameters!ServerName.Value & ";Initial Catalog=" & Parameters!DatabaseName.Value & ";UserName=" & Parameters!UserName.Value & ";Password=" & Parameters!Password.Value
Thoughts/Input?
Thanks,
Fraggle
May 9, 2012 at 11:41 am
Dear,
Have you tried the unattended execution in SSRS Reporting Service Configuration Manager. Specify one and check. Also put the specified user id and pwd into the logon to local server security group.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply