July 21, 2003 at 2:32 pm
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.
July 21, 2003 at 2:44 pm
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?
July 22, 2003 at 1:35 am
Maybe this helps?
Q238477
Mvg, MvG.
Mvg, MvG.
July 22, 2003 at 11:29 am
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