Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Expand / Collapse
Author
Message
Posted Thursday, May 9, 2013 1:45 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 11:19 AM
Points: 245, Visits: 1,132

When I look into the SQL Server Job it is run as “SQL Server Integration Service Account” and it is NOT run as Proxy Account but when I look at the job history it says Executed as ‘UserOne’ (for example). I am trying to find out where this is tied because I need to access a fileShare where Agent account does not have access where as UserOne would- without actually using a proxy account. Thanks.
Post #1451311
Posted Thursday, May 9, 2013 2:25 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, December 15, 2014 2:26 PM
Points: 5,466, Visits: 7,647
What user is running the IS Service on that box?


- Craig Farrell

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 | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1451316
Posted Thursday, May 9, 2013 3:58 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 11:19 AM
Points: 245, Visits: 1,132
Evil Kraig F (5/9/2013)
What user is running the IS Service on that box?


Evil Kraig F, I have no clue. Its our production box and i doubt if i have access to find that out-how can i go about it if that is the approach?
Post #1451362
Posted Thursday, May 9, 2013 4:25 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, December 15, 2014 2:26 PM
Points: 5,466, Visits: 7,647
You have to RDC to the box, rt-click computer, manage, and check the services. Rt-click services and in properties for it you'll be able to see the login for it.

Usually jobs that run packages run under one of three contexts. The SQL Agent login, the SSIS service, or the proxy that's assigned to the job step. Your description sounds like it's the SSIS Service's login, so I was wondering if that matched what you were seeing.

If you don't have RDC rights and box admin, you won't be able to see the services and will need to inquire of those that do, probably the Senior DBAs on your staff.



- Craig Farrell

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 | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1451371
Posted Thursday, May 9, 2013 5:05 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 11:19 AM
Points: 245, Visits: 1,132
Evil Kraig F (5/9/2013)
You have to RDC to the box, rt-click computer, manage, and check the services. Rt-click services and in properties for it you'll be able to see the login for it.

Usually jobs that run packages run under one of three contexts. The SQL Agent login, the SSIS service, or the proxy that's assigned to the job step. Your description sounds like it's the SSIS Service's login, so I was wondering if that matched what you were seeing.

If you don't have RDC rights and box admin, you won't be able to see the services and will need to inquire of those that do, probably the Senior DBAs on your staff.


You were right- the SSIS is running Under SSIS SERVICE - 'UserOne' (In our context) when I RDC-ed the box. Is this where i would make the change?
Post #1451379
Posted Thursday, May 9, 2013 6:09 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, December 15, 2014 2:26 PM
Points: 5,466, Visits: 7,647
Yeah, either modify that to be one of the logins from the other systems that are working, or check that user's permissions against the target system. My guess is that the permissions aren't equivalent in the network or on the target system if it can inherit NT permissions.

SSIS Service though sounds more like a local account than an NT account, which may be half the issue.



- Craig Farrell

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 | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1451385
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse