October 23, 2014 at 10:12 am
We have a dedicated Active Directory account for SSRS in each environment (e.g. Domain\SSRS_QA, see attached). Once the report is set up in SSRS, everything works fine. What I can't figure out how to do is create Data Sources in BIDS that use an Active Directory account (Domain\SSRS_QA) other than the one I am currently logged in with (Domain\Alex). Is there a way to do this so that I can develop against the correct account? The only option I've found is to use a SQL Authenticated login, but we are specifically trying to move away from that.
Thanks,
Alex
October 24, 2014 at 4:26 am
Hi Alex, I'm not aware of a way you can set up Data Sources with specified Windows Credentials, however, you can run BIDS using "runas /netonly" to impersonate a user for network operations. It would look like the below:
c:\>runas /netonly /user:domain\SSRS_QA "C:\Program Files (x86)\Micro...\IDE\devenv.exe"
This will run all network operations through BIDS impersonating the specified user, including data-sources, while keeping local operations and settings as you.
One caveat is that if you use TFS (as I do) or similar it will use the impersonated credentials to connect to the TFS server and fail.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply