SQL Agent remote login problem

  • I have a local stored provcedure that gets data from remote SQL Servers. When I run the procedure through QA it runs fine, when I run the proocedure as a SQL job, it errors out with

    Msg 18456, Sev 14: Login failed for user '\'. [SQLSTATE 28000]

    when I try and create a remote job task I get a cnofiguration is not supported.

    thanks in advance 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.

  • quote:


    Msg 18456, Sev 14: Login failed for user '\'. [SQLSTATE 28000]


    Who is the job owner? Which authentication mode SQL Server runs?

    quote:


    when I try and create a remote job task I get a cnofiguration is not supported.


    Which version of SQL Server are you running? MSDE?

  • Maybe this helps?

    Q238477

    Mvg, MvG.


    Mvg, MvG.

  • Allen_Cui - the local instance is SQL 2000 on windows 2000 profesional, and the remote is SQL 7 on NT4.0, both machine are running in mixed authentication mode.

    martinvg - I tried the article and it didn;t work.

    What I am thinking is that the remote machine's QSLAgent is started under a different domain/logon, when I tried accomplishing this from a machine that has SQLAgent running under the same domain/lgon it worked, or could this be a problem between SQL 7 and SQL 2000?

    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 4 posts - 1 through 3 (of 3 total)

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