We have a SQL Agent job that runs an SSIS package, SQL Server 2008 (not R2). Clicking the Data Sources tab of the job step generates a password prompt as expected when I'm logged onto the database server. Same when I'm viewing the same instance from another machine on the same domain. When I'm trying this from my own machine which is in a different domain, clicking the Data Sources tab just results in a spinner for a few seconds then a blank box i.e. no connections displayed.
In all cases, its the same database server instance, connecting via Windows Authentication, same network logon which is a member of an AD group defined in the same domain as the server and which has sysadmin perms. I'm wondering whether it's a "double-hop" issue and if so then how to overcome (or do I just accept I'll have to remote on to the server each time I wish to change this kind of job).
Forum Etiquette: How to post data/code on a forum to get the best helpMake sure that you include code in the appropriate IFCode tags, e.g. <your code here>. You can find the IFCode tags under the INSERT options when you are writing a post.