SQL Agent remote login problem

  • For a specific job that logs onto another server I get the error

    Executed as user: USTRESACC\cccsqladmin. Login failed for user 'USTRESACC\cccsqladmin'. [SQLSTATE 28000] (Error 18456). The step failed.

    which means I need to change who the SQL Agent is running under, but I can't, seems that this server is logging onto other SQL Servers and needs this login for that. Does anybody know a way to run the single job as a different user?

    jimmY

    Work like you don't need the money.

    Love like you've never been hurt.

    And Dance like no one is watching.


    Work like you don't need the money.
    Love like you've never been hurt.
    And Dance like no one is watching.

  • Why don't you create 'USTRESACC\cccsqladmin' as a login on the other server?

    Or, in linked servers, for that server, change from windows authentication to SQL authentication, and give the credentials of a valid SQL login.

    Or, if you feel that changing the login credential for a linked server may impact other areas, use Client Network Utility to create an alias for that server, then set up a new linked server, with SQL login, using that alias.

    Cheers,

    - Mark


    Cheers,
    - Mark

  • I tried it with SQL Authentication, but the scheduler overides it with what it it running as. Also, due to security audits I am not allowed to have the other login's password or have it log into my machines.

    Now, I just found out that I can't use that machine. So, seems like this one isn't as important anymore.

    Thanks for your help

    jimmY

    Work like you don't need the money.

    Love like you've never been hurt.

    And Dance like no one is watching.


    Work like you don't need the money.
    Love like you've never been hurt.
    And Dance like no one is watching.

Viewing 3 posts - 1 through 2 (of 2 total)

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