Package configurations-specifying domain account
I know in a package configuration I can do the following: 1. Specify a SQL Server username and password for the SQL Server database I am connecting to. 2. Specify Integrated security so the package will use the security context at runtime, i.e. the SQL Server Agent account or a proxy if specified. Is it possible to specify another domain account specifically in the file? The issue is a customer has given me a development box to work from, and a domain account logon to that box. They have given me another domain account to logon to the SQL Server (no SQL username available). So in development in BIDS I can't use my current security context which doesn't have rights to the SQL Server. I suppose if I ran BIDS as a different user, and ran it as that domain user that has SQL Server access it would work, but that is a problem for other reasons which I won't go into. So can I specify another domain user's account info the the dtsconfig file? Thanks!
June 26th, 2012 11:14pm

you can use windows authentication security to underlying databases in SSIS packages and just create an Active Directory group of those who have access to SQL Server database, then add those users to this AD group, and create proxy account on this AD group as wellhttp://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
June 27th, 2012 12:30am

Don't think that helps. What I want to do is specify in the dtsconfig file a particular AD account that has access to the database already, that is not the one I am logged into the development machine with.
June 27th, 2012 1:05am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics