Job with steps problem

Hi all,
I have Windows 2003 r2 Server x64, sql 2005 sp1 x64 with sql 2000 latest sp
on one machine.
In SQL2005 I have created 2 maintenance plans - one for 2005 and second for
2000
Also created 3rd job (first 2 were generated by maintenance plans) with the
following steps:
1. cmd to move filese from A to B
2. SQL SISP package \Maintenance Plans\2005
3. SQL SISP package \Maintenance Plans\2000
When I execute that job it goes to step one and move those file, it's ok.
But step 2 and 3 are not executed correctly, I mean they are executed
(Successful) but that maintenance plan is not executing. After all I'm
getting the successful result but no backup are mage
Tried to execute those maintenance plans one by one. 2000 - successful but
nothing happens, the same is for 2005
When I execute the job associated - all is ok.
How could I add defined JOB to the Job Steps, to make it all run?
Thank you in advance
Alex
I don't think it is a good idea to call job from another job's step.
I mean you have to be certain that it is really business requirements
Take a look at sp_start_job system stored procedure in the BOL
"Guzun, Alex" <a> wrote in message
news:OT%23pG$gvHHA.536@.TK2MSFTNGP06.phx.gbl...
> Hi all,
> I have Windows 2003 r2 Server x64, sql 2005 sp1 x64 with sql 2000 latest
> sp on one machine.
> In SQL2005 I have created 2 maintenance plans - one for 2005 and second
> for 2000
> Also created 3rd job (first 2 were generated by maintenance plans) with
> the following steps:
> 1. cmd to move filese from A to B
> 2. SQL SISP package \Maintenance Plans\2005
> 3. SQL SISP package \Maintenance Plans\2000
> When I execute that job it goes to step one and move those file, it's ok.
> But step 2 and 3 are not executed correctly, I mean they are executed
> (Successful) but that maintenance plan is not executing. After all I'm
> getting the successful result but no backup are mage
> Tried to execute those maintenance plans one by one. 2000 - successful but
> nothing happens, the same is for 2005
> When I execute the job associated - all is ok.
> How could I add defined JOB to the Job Steps, to make it all run?
> Thank you in advance
|||Hm... don't know what is BOL, and how to use sp_start_job system stored
procedure
I'm just a guy that using GUI for SQL
I need to achieve those job to run as 1, 2, 3.
2nd will wait for 1, to end and so on
Please help me if you can
Thanks in advance
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:#jzRXGhvHHA.2288@.TK2MSFTNGP05.phx.gbl...
> Alex
> I don't think it is a good idea to call job from another job's step.
> I mean you have to be certain that it is really business requirements
> Take a look at sp_start_job system stored procedure in the BOL
>
> "Guzun, Alex" <a> wrote in message
> news:OT%23pG$gvHHA.536@.TK2MSFTNGP06.phx.gbl...
>
>
|||Alex
BOL -Books On Line that is a part of SQL Server Client Tools installation.
Can you create three jobs and and checking the status by using sp_help_job?
"Guzun, Alex" <a> wrote in message
news:%23tGvRWjvHHA.1168@.TK2MSFTNGP02.phx.gbl...[vbcol=seagreen]
> Hm... don't know what is BOL, and how to use sp_start_job system stored
> procedure
> I'm just a guy that using GUI for SQL
> I need to achieve those job to run as 1, 2, 3.
> 2nd will wait for 1, to end and so on
> Please help me if you can
> Thanks in advance
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:#jzRXGhvHHA.2288@.TK2MSFTNGP05.phx.gbl...
|||Sorry
I have 2 jobs for 2 maintenance plans
Got also 3 job with cmd script to move files from DAY folder to WEEK folder
And everyday I'll tape DAY folder
Now I want them to run one by one, don't want to calculate time intervals
for each one
Thanks
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:#DnGyajvHHA.1164@.TK2MSFTNGP02.phx.gbl...
> Alex
> BOL -Books On Line that is a part of SQL Server Client Tools installation.
> Can you create three jobs and and checking the status by using
> sp_help_job?
>
> "Guzun, Alex" <a> wrote in message
> news:%23tGvRWjvHHA.1168@.TK2MSFTNGP02.phx.gbl...
>

Job with steps problem

Hi all,
I have Windows 2003 r2 Server x64, sql 2005 sp1 x64 with sql 2000 latest sp
on one machine.
In SQL2005 I have created 2 maintenance plans - one for 2005 and second for
2000
Also created 3rd job (first 2 were generated by maintenance plans) with the
following steps:
1. cmd to move filese from A to B
2. SQL SISP package \Maintenance Plans\2005
3. SQL SISP package \Maintenance Plans\2000
When I execute that job it goes to step one and move those file, it's ok.
But step 2 and 3 are not executed correctly, I mean they are executed
(Successful) but that maintenance plan is not executing. After all I'm
getting the successful result but no backup are mage :(
Tried to execute those maintenance plans one by one. 2000 - successful but
nothing happens, the same is for 2005
When I execute the job associated - all is ok.
How could I add defined JOB to the Job Steps, to make it all run?
Thank you in advanceAlex
I don't think it is a good idea to call job from another job's step.
I mean you have to be certain that it is really business requirements
Take a look at sp_start_job system stored procedure in the BOL
"Guzun, Alex" <a> wrote in message
news:OT%23pG$gvHHA.536@.TK2MSFTNGP06.phx.gbl...
> Hi all,
> I have Windows 2003 r2 Server x64, sql 2005 sp1 x64 with sql 2000 latest
> sp on one machine.
> In SQL2005 I have created 2 maintenance plans - one for 2005 and second
> for 2000
> Also created 3rd job (first 2 were generated by maintenance plans) with
> the following steps:
> 1. cmd to move filese from A to B
> 2. SQL SISP package \Maintenance Plans\2005
> 3. SQL SISP package \Maintenance Plans\2000
> When I execute that job it goes to step one and move those file, it's ok.
> But step 2 and 3 are not executed correctly, I mean they are executed
> (Successful) but that maintenance plan is not executing. After all I'm
> getting the successful result but no backup are mage :(
> Tried to execute those maintenance plans one by one. 2000 - successful but
> nothing happens, the same is for 2005
> When I execute the job associated - all is ok.
> How could I add defined JOB to the Job Steps, to make it all run?
> Thank you in advance|||Hm... don't know what is BOL, and how to use sp_start_job system stored
procedure
I'm just a guy that using GUI for SQL
I need to achieve those job to run as 1, 2, 3.
2nd will wait for 1, to end and so on :(
Please help me if you can
Thanks in advance
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:#jzRXGhvHHA.2288@.TK2MSFTNGP05.phx.gbl...
> Alex
> I don't think it is a good idea to call job from another job's step.
> I mean you have to be certain that it is really business requirements
> Take a look at sp_start_job system stored procedure in the BOL
>
> "Guzun, Alex" <a> wrote in message
> news:OT%23pG$gvHHA.536@.TK2MSFTNGP06.phx.gbl...
>> Hi all,
>> I have Windows 2003 r2 Server x64, sql 2005 sp1 x64 with sql 2000 latest
>> sp on one machine.
>> In SQL2005 I have created 2 maintenance plans - one for 2005 and second
>> for 2000
>> Also created 3rd job (first 2 were generated by maintenance plans) with
>> the following steps:
>> 1. cmd to move filese from A to B
>> 2. SQL SISP package \Maintenance Plans\2005
>> 3. SQL SISP package \Maintenance Plans\2000
>> When I execute that job it goes to step one and move those file, it's ok.
>> But step 2 and 3 are not executed correctly, I mean they are executed
>> (Successful) but that maintenance plan is not executing. After all I'm
>> getting the successful result but no backup are mage :(
>> Tried to execute those maintenance plans one by one. 2000 - successful
>> but nothing happens, the same is for 2005
>> When I execute the job associated - all is ok.
>> How could I add defined JOB to the Job Steps, to make it all run?
>> Thank you in advance
>
>|||Alex
BOL -Books On Line that is a part of SQL Server Client Tools installation.
Can you create three jobs and and checking the status by using sp_help_job?
"Guzun, Alex" <a> wrote in message
news:%23tGvRWjvHHA.1168@.TK2MSFTNGP02.phx.gbl...
> Hm... don't know what is BOL, and how to use sp_start_job system stored
> procedure
> I'm just a guy that using GUI for SQL
> I need to achieve those job to run as 1, 2, 3.
> 2nd will wait for 1, to end and so on :(
> Please help me if you can
> Thanks in advance
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:#jzRXGhvHHA.2288@.TK2MSFTNGP05.phx.gbl...
>> Alex
>> I don't think it is a good idea to call job from another job's step.
>> I mean you have to be certain that it is really business requirements
>> Take a look at sp_start_job system stored procedure in the BOL
>>
>> "Guzun, Alex" <a> wrote in message
>> news:OT%23pG$gvHHA.536@.TK2MSFTNGP06.phx.gbl...
>> Hi all,
>> I have Windows 2003 r2 Server x64, sql 2005 sp1 x64 with sql 2000 latest
>> sp on one machine.
>> In SQL2005 I have created 2 maintenance plans - one for 2005 and second
>> for 2000
>> Also created 3rd job (first 2 were generated by maintenance plans) with
>> the following steps:
>> 1. cmd to move filese from A to B
>> 2. SQL SISP package \Maintenance Plans\2005
>> 3. SQL SISP package \Maintenance Plans\2000
>> When I execute that job it goes to step one and move those file, it's
>> ok. But step 2 and 3 are not executed correctly, I mean they are
>> executed (Successful) but that maintenance plan is not executing. After
>> all I'm getting the successful result but no backup are mage :(
>> Tried to execute those maintenance plans one by one. 2000 - successful
>> but nothing happens, the same is for 2005
>> When I execute the job associated - all is ok.
>> How could I add defined JOB to the Job Steps, to make it all run?
>> Thank you in advance
>>|||Sorry :)
I have 2 jobs for 2 maintenance plans
Got also 3 job with cmd script to move files from DAY folder to WEEK folder
And everyday I'll tape DAY folder
Now I want them to run one by one, don't want to calculate time intervals
for each one
Thanks
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:#DnGyajvHHA.1164@.TK2MSFTNGP02.phx.gbl...
> Alex
> BOL -Books On Line that is a part of SQL Server Client Tools installation.
> Can you create three jobs and and checking the status by using
> sp_help_job?
>
> "Guzun, Alex" <a> wrote in message
> news:%23tGvRWjvHHA.1168@.TK2MSFTNGP02.phx.gbl...
>> Hm... don't know what is BOL, and how to use sp_start_job system stored
>> procedure
>> I'm just a guy that using GUI for SQL
>> I need to achieve those job to run as 1, 2, 3.
>> 2nd will wait for 1, to end and so on :(
>> Please help me if you can
>> Thanks in advance
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:#jzRXGhvHHA.2288@.TK2MSFTNGP05.phx.gbl...
>> Alex
>> I don't think it is a good idea to call job from another job's step.
>> I mean you have to be certain that it is really business requirements
>> Take a look at sp_start_job system stored procedure in the BOL
>>
>> "Guzun, Alex" <a> wrote in message
>> news:OT%23pG$gvHHA.536@.TK2MSFTNGP06.phx.gbl...
>> Hi all,
>> I have Windows 2003 r2 Server x64, sql 2005 sp1 x64 with sql 2000
>> latest sp on one machine.
>> In SQL2005 I have created 2 maintenance plans - one for 2005 and second
>> for 2000
>> Also created 3rd job (first 2 were generated by maintenance plans) with
>> the following steps:
>> 1. cmd to move filese from A to B
>> 2. SQL SISP package \Maintenance Plans\2005
>> 3. SQL SISP package \Maintenance Plans\2000
>> When I execute that job it goes to step one and move those file, it's
>> ok. But step 2 and 3 are not executed correctly, I mean they are
>> executed (Successful) but that maintenance plan is not executing. After
>> all I'm getting the successful result but no backup are mage :(
>> Tried to execute those maintenance plans one by one. 2000 - successful
>> but nothing happens, the same is for 2005
>> When I execute the job associated - all is ok.
>> How could I add defined JOB to the Job Steps, to make it all run?
>> Thank you in advance
>>
>

Job with steps problem

Hi all,
I have Windows 2003 r2 Server x64, sql 2005 sp1 x64 with sql 2000 latest sp
on one machine.
In SQL2005 I have created 2 maintenance plans - one for 2005 and second for
2000
Also created 3rd job (first 2 were generated by maintenance plans) with the
following steps:
1. cmd to move filese from A to B
2. SQL SISP package \Maintenance Plans\2005
3. SQL SISP package \Maintenance Plans\2000
When I execute that job it goes to step one and move those file, it's ok.
But step 2 and 3 are not executed correctly, I mean they are executed
(Successful) but that maintenance plan is not executing. After all I'm
getting the successful result but no backup are mage
Tried to execute those maintenance plans one by one. 2000 - successful but
nothing happens, the same is for 2005
When I execute the job associated - all is ok.
How could I add defined JOB to the Job Steps, to make it all run?
Thank you in advanceAlex
I don't think it is a good idea to call job from another job's step.
I mean you have to be certain that it is really business requirements
Take a look at sp_start_job system stored procedure in the BOL
"Guzun, Alex" <a> wrote in message
news:OT%23pG$gvHHA.536@.TK2MSFTNGP06.phx.gbl...
> Hi all,
> I have Windows 2003 r2 Server x64, sql 2005 sp1 x64 with sql 2000 latest
> sp on one machine.
> In SQL2005 I have created 2 maintenance plans - one for 2005 and second
> for 2000
> Also created 3rd job (first 2 were generated by maintenance plans) with
> the following steps:
> 1. cmd to move filese from A to B
> 2. SQL SISP package \Maintenance Plans\2005
> 3. SQL SISP package \Maintenance Plans\2000
> When I execute that job it goes to step one and move those file, it's ok.
> But step 2 and 3 are not executed correctly, I mean they are executed
> (Successful) but that maintenance plan is not executing. After all I'm
> getting the successful result but no backup are mage
> Tried to execute those maintenance plans one by one. 2000 - successful but
> nothing happens, the same is for 2005
> When I execute the job associated - all is ok.
> How could I add defined JOB to the Job Steps, to make it all run?
> Thank you in advance|||Hm... don't know what is BOL, and how to use sp_start_job system stored
procedure
I'm just a guy that using GUI for SQL
I need to achieve those job to run as 1, 2, 3.
2nd will wait for 1, to end and so on
Please help me if you can
Thanks in advance
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:#jzRXGhvHHA.2288@.TK2MSFTNGP05.phx.gbl...
> Alex
> I don't think it is a good idea to call job from another job's step.
> I mean you have to be certain that it is really business requirements
> Take a look at sp_start_job system stored procedure in the BOL
>
> "Guzun, Alex" <a> wrote in message
> news:OT%23pG$gvHHA.536@.TK2MSFTNGP06.phx.gbl...
>
>|||Alex
BOL -Books On Line that is a part of SQL Server Client Tools installation.
Can you create three jobs and and checking the status by using sp_help_job?
"Guzun, Alex" <a> wrote in message
news:%23tGvRWjvHHA.1168@.TK2MSFTNGP02.phx.gbl...[vbcol=seagreen]
> Hm... don't know what is BOL, and how to use sp_start_job system stored
> procedure
> I'm just a guy that using GUI for SQL
> I need to achieve those job to run as 1, 2, 3.
> 2nd will wait for 1, to end and so on
> Please help me if you can
> Thanks in advance
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:#jzRXGhvHHA.2288@.TK2MSFTNGP05.phx.gbl...|||Sorry
I have 2 jobs for 2 maintenance plans
Got also 3 job with cmd script to move files from DAY folder to WEEK folder
And everyday I'll tape DAY folder
Now I want them to run one by one, don't want to calculate time intervals
for each one
Thanks
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:#DnGyajvHHA.1164@.TK2MSFTNGP02.phx.gbl...
> Alex
> BOL -Books On Line that is a part of SQL Server Client Tools installation.
> Can you create three jobs and and checking the status by using
> sp_help_job?
>
> "Guzun, Alex" <a> wrote in message
> news:%23tGvRWjvHHA.1168@.TK2MSFTNGP02.phx.gbl...
>

Job Failure emails not being sent in SQL 2005

Hi I am trying to configure notification emails on my sql2005 server for SQL
agent job failures. I have configured a mail profile in database mail and I
can send test emails which are received correctly.
I have configured the notification to email me when the job completes but
this is not working and I do not receive any notifications. When I look at
the job history
it gives me the message below after the normal job completion information.
NOTE: Failed to notify 'Email User' via email.
Any ideas as to want i can do to fix this problem.
Cheers
James
On Jan 28, 5:23 am, "Mark Yudkin" <DoNotContac...@.boingboing.org>
wrote:
> The most likely cause is that the userid running thejobis not permitted to
> sendemail. Check out the authorizations on your mailserverand add the
> necessary permissions.
> "James Matthews" <JamesMatth...@.discussions.microsoft.com> wrote in message
> news:30E73785-3D3D-4829-AB4A-3DB82F5E7E4F@.microsoft.com...
>
>
>
> - Show quoted text -
I encountered the same problem and fixed it by restarting the SQL
SERVER AGENT in Management Studio.

Job Failure emails not being sent in SQL 2005

Hi I am trying to configure notification emails on my sql2005 server for SQL
agent job failures. I have configured a mail profile in database mail and I
can send test emails which are received correctly.
I have configured the notification to email me when the job completes but
this is not working and I do not receive any notifications. When I look at
the job history
it gives me the message below after the normal job completion information.
NOTE: Failed to notify 'Email User' via email.
Any ideas as to want i can do to fix this problem.
Cheers
JamesThe most likely cause is that the userid running the job is not permitted to
send email. Check out the authorizations on your mail server and add the
necessary permissions.
"James Matthews" <JamesMatthews@.discussions.microsoft.com> wrote in message
news:30E73785-3D3D-4829-AB4A-3DB82F5E7E4F@.microsoft.com...
> Hi I am trying to configure notification emails on my sql2005 server for
> SQL
> agent job failures. I have configured a mail profile in database mail and
> I
> can send test emails which are received correctly.
> I have configured the notification to email me when the job completes but
> this is not working and I do not receive any notifications. When I look at
> the job history
> it gives me the message below after the normal job completion information.
> NOTE: Failed to notify 'Email User' via email.
> Any ideas as to want i can do to fix this problem.
> Cheers
> James
>|||On Jan 28, 5:23 am, "Mark Yudkin" <DoNotContac...@.boingboing.org>
wrote:
> The most likely cause is that the userid running thejobis not permitted to
> sendemail. Check out the authorizations on your mailserverand add the
> necessary permissions.
> "James Matthews" <JamesMatth...@.discussions.microsoft.com> wrote in messag
e
> news:30E73785-3D3D-4829-AB4A-3DB82F5E7E4F@.microsoft.com...
>
>
>
>
>
> - Show quoted text -
I encountered the same problem and fixed it by restarting the SQL
SERVER AGENT in Management Studio.

Job Failure emails not being sent in SQL 2005

Hi I am trying to configure notification emails on my sql2005 server for SQL
agent job failures. I have configured a mail profile in database mail and I
can send test emails which are received correctly.
I have configured the notification to email me when the job completes but
this is not working and I do not receive any notifications. When I look at
the job history
it gives me the message below after the normal job completion information.
NOTE: Failed to notify 'Email User' via email.
Any ideas as to want i can do to fix this problem.
Cheers
JamesThe most likely cause is that the userid running the job is not permitted to
send email. Check out the authorizations on your mail server and add the
necessary permissions.
"James Matthews" <JamesMatthews@.discussions.microsoft.com> wrote in message
news:30E73785-3D3D-4829-AB4A-3DB82F5E7E4F@.microsoft.com...
> Hi I am trying to configure notification emails on my sql2005 server for
> SQL
> agent job failures. I have configured a mail profile in database mail and
> I
> can send test emails which are received correctly.
> I have configured the notification to email me when the job completes but
> this is not working and I do not receive any notifications. When I look at
> the job history
> it gives me the message below after the normal job completion information.
> NOTE: Failed to notify 'Email User' via email.
> Any ideas as to want i can do to fix this problem.
> Cheers
> James
>|||On Jan 28, 5:23 am, "Mark Yudkin" <DoNotContac...@.boingboing.org>
wrote:
> The most likely cause is that the userid running thejobis not permitted to
> sendemail. Check out the authorizations on your mailserverand add the
> necessary permissions.
> "James Matthews" <JamesMatth...@.discussions.microsoft.com> wrote in message
> news:30E73785-3D3D-4829-AB4A-3DB82F5E7E4F@.microsoft.com...
>
> > Hi I am trying to configurenotificationemails on my sql2005serverfor
> >SQL
> > agentjobfailures. I have configured a mail profile in database mail and
> > I
> > can send test emails which are received correctly.
> > I have configured thenotificationtoemailme when thejobcompletes but
> > this is not working and I do not receive any notifications. When I look at
> > thejobhistory
> > it gives me the message below after the normaljobcompletion information.
> > NOTE: Failed to notify 'EmailUser' viaemail.
> > Any ideas as to want i can do to fix this problem.
> > Cheers
> > James- Hide quoted text -
> - Show quoted text -
I encountered the same problem and fixed it by restarting the SQL
SERVER AGENT in Management Studio.

Job Fails on Linked Server [solution]

I've got a job running on a SQL2005 box (server07) that modifies data on a SQL2000 box (server05). The databases on the 2005 were imported from an older box running SQL2000. The step that is failing is:

update server05.xtender.sysop.ae_rf4
set field3 = sname
from server05.xtender.sysop.ae_rf4 x inner join allscholarships..studentsindb_table s
on x.field1 = s.ssn
where x.field3 is null or len(field3) = 0

The history shows this for the failed step:

Message
Executed as user: Domain\Administrator. Access to the remote server is denied because the current security context is not trusted. [SQLSTATE 42000] (Error 15274)Unable to open Step output file. The step failed.

Domain\Administrator is a sysadmin on both boxes. This job had been running some time ago, but the SQL2000 box (under a different dba) has somehow changed. Now I need to get the thing running again.

Hi,

The error said its untrusted connection ... have you tried re mapping accounts using sp_addlinkedsrvlogin!!!?

refer this thread http://www.webservertalk.com/archive137-2006-4-1477449.html

Hemantgiri S. Goswami

|||That discussion is the only thing that pops up when I google "Error 15274", I've read the very original and he hasn't gotten an answer yet.

The best I can tell is that the SQL Agent is supplying the security credentials to the linked server and I'm not able to specify which security context for the job to use.

In the Job Step Properties pages, under each step's General page in the middle of the window is a dropdown - Run As. There is nothing in the dropdown list and no way to enter a value. On the Advanced page of each step is a Run As User with a select user button, I've entered every conceivable value on this Advanced page with no success.
|||Check services - which account is used for startup of the SQL agent. System account is no good - only local resources are available. Use "This account" with administrative rights on the Windows & SQL server.|||Make sure Domain\Administrator has got required privilges on SQL Server (incl. SQLAgent) in order to complete the job process.|||Also check the linked server setup - security. Check "Be made using the login's current security context".|||

a very weird issue. Was able to resolve it using a new NT Account with Admin rights. Just created it at both servers, then added to both SQL Servers with rights I needed. And also set this account to be used for SQL Agent service.

Oh, also have used the imporsonate setting for linked servers mapping (at both sides)

and just leave "run as user" blank for step settings

|||check the connectivity of your linked server using sp_testlinkedserver

Job Fails on Linked Server

I've got a job running on a SQL2005 box (server07) that modifies data on a SQL2000 box (server05). The databases on the 2005 were imported from an older box running SQL2000. The step that is failing is:

update server05.xtender.sysop.ae_rf4
set field3 = sname
from server05.xtender.sysop.ae_rf4 x inner join allscholarships..studentsindb_table s
on x.field1 = s.ssn
where x.field3 is null or len(field3) = 0

The history shows this for the failed step:

Message
Executed as user: Domain\Administrator. Access to the remote server is denied because the current security context is not trusted. [SQLSTATE 42000] (Error 15274)Unable to open Step output file. The step failed.

Domain\Administrator is a sysadmin on both boxes. This job had been running some time ago, but the SQL2000 box (under a different dba) has somehow changed. Now I need to get the thing running again.

Hi,

The error said its untrusted connection ... have you tried re mapping accounts using sp_addlinkedsrvlogin!!!?

refer this thread http://www.webservertalk.com/archive137-2006-4-1477449.html

Hemantgiri S. Goswami

|||That discussion is the only thing that pops up when I google "Error 15274", I've read the very original and he hasn't gotten an answer yet.

The best I can tell is that the SQL Agent is supplying the security credentials to the linked server and I'm not able to specify which security context for the job to use.

In the Job Step Properties pages, under each step's General page in the middle of the window is a dropdown - Run As. There is nothing in the dropdown list and no way to enter a value. On the Advanced page of each step is a Run As User with a select user button, I've entered every conceivable value on this Advanced page with no success.
|||Check services - which account is used for startup of the SQL agent. System account is no good - only local resources are available. Use "This account" with administrative rights on the Windows & SQL server.|||Make sure Domain\Administrator has got required privilges on SQL Server (incl. SQLAgent) in order to complete the job process.|||Also check the linked server setup - security. Check "Be made using the login's current security context".|||

a very weird issue. Was able to resolve it using a new NT Account with Admin rights. Just created it at both servers, then added to both SQL Servers with rights I needed. And also set this account to be used for SQL Agent service.

Oh, also have used the imporsonate setting for linked servers mapping (at both sides)

and just leave "run as user" blank for step settings

|||check the connectivity of your linked server using sp_testlinkedserver

Job Fails on Linked Server

I've got a job running on a SQL2005 box (server07) that modifies data on a SQL2000 box (server05). The databases on the 2005 were imported from an older box running SQL2000. The step that is failing is:

update server05.xtender.sysop.ae_rf4
set field3 = sname
from server05.xtender.sysop.ae_rf4 x inner join allscholarships..studentsindb_table s
on x.field1 = s.ssn
where x.field3 is null or len(field3) = 0

The history shows this for the failed step:

Message
Executed as user: Domain\Administrator. Access to the remote server is denied because the current security context is not trusted. [SQLSTATE 42000] (Error 15274)Unable to open Step output file. The step failed.

Domain\Administrator is a sysadmin on both boxes. This job had been running some time ago, but the SQL2000 box (under a different dba) has somehow changed. Now I need to get the thing running again.

Hi,

The error said its untrusted connection ... have you tried re mapping accounts using sp_addlinkedsrvlogin!!!?

refer this thread http://www.webservertalk.com/archive137-2006-4-1477449.html

Hemantgiri S. Goswami

|||That discussion is the only thing that pops up when I google "Error 15274", I've read the very original and he hasn't gotten an answer yet.

The best I can tell is that the SQL Agent is supplying the security credentials to the linked server and I'm not able to specify which security context for the job to use.

In the Job Step Properties pages, under each step's General page in the middle of the window is a dropdown - Run As. There is nothing in the dropdown list and no way to enter a value. On the Advanced page of each step is a Run As User with a select user button, I've entered every conceivable value on this Advanced page with no success.|||Check services - which account is used for startup of the SQL agent. System account is no good - only local resources are available. Use "This account" with administrative rights on the Windows & SQL server.|||Make sure Domain\Administrator has got required privilges on SQL Server (incl. SQLAgent) in order to complete the job process.|||Also check the linked server setup - security. Check "Be made using the login's current security context".|||

a very weird issue. Was able to resolve it using a new NT Account with Admin rights. Just created it at both servers, then added to both SQL Servers with rights I needed. And also set this account to be used for SQL Agent service.

Oh, also have used the imporsonate setting for linked servers mapping (at both sides)

and just leave "run as user" blank for step settings

|||check the connectivity of your linked server using sp_testlinkedserver