Post reply

SQL query works in SSIS, SSMS/SQL server but fails in deployment?

  • January 16, 2014 at 2:23 pm

    #1680867

    Evil Kraig F (1/16/2014)

    blasto_max (1/16/2014)

    In job history, I see that it is invoked by User1. But, it was executed as user BigDomain\BigAdmin. Could this be the reason for the problems ? I use the login name User1 on the Target server. Maybe my job should be executed by User1 and not by BigDomain\BigAdmin ? Those users are present on Prod server security. Prod is different from Target server.

    Thanks.

    Invoking the job is just whoever started the job (can be called from proc, user initiation, scheduling...) It has nothing to do with what the job executes as, which is either the proxy in the step or the SQL Agent if no proxy is set.

    The problem is with the SQL Agent's login and security at the target. That is what you have to adjust for and around.

    So DBA/I have to go into target and allow BigDomain\BigAdmin access to its tables ?

  • January 16, 2014 at 2:30 pm

    #1680869

    blasto_max (1/16/2014)

    Evil Kraig F (1/16/2014)

    blasto_max (1/16/2014)

    In job history, I see that it is invoked by User1. But, it was executed as user BigDomain\BigAdmin. Could this be the reason for the problems ? I use the login name User1 on the Target server. Maybe my job should be executed by User1 and not by BigDomain\BigAdmin ? Those users are present on Prod server security. Prod is different from Target server.

    Thanks.

    Invoking the job is just whoever started the job (can be called from proc, user initiation, scheduling...) It has nothing to do with what the job executes as, which is either the proxy in the step or the SQL Agent if no proxy is set.

    The problem is with the SQL Agent's login and security at the target. That is what you have to adjust for and around.

    So DBA/I have to go into target and allow BigDomain\BigAdmin access to its tables ?

    Dead on Target.

    - 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[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply