'Error 14274' - Cannot add, update, or delete a job (or its steps or schedules) that ori

http://support.microsoft.com/default.aspx?scid=kb;en-us;281642
I followed the tip above but it didn't work. anyone know of other workaround
?
I restore a copy of my Production DB on a TestDB, the scheduled jobs get
copied over as well. Cannot removed these job frm the Test DB because of
error 14274.
I logon the Test DB on workgroup, rename to original server name (on
workgroup because the Production still exist on the network), tried to
delete the jobs, SQL doesn't allow also. At the moment, I stopped the SQL
Agent Service to prevent the jobs frm running.
How to remove the jobs in the Test DB for good ?Don't bother with the rename stuff. Simply update the originating_server
column to reflect the new server name.
Have a look at http://sqldev.net/download/sqlagent/sp_sqlagent_rename.sql
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"pohkeat" <pohkeat@.hotmail.com> wrote in message
news:%23GEUVi%23bEHA.1764@.TK2MSFTNGP10.phx.gbl...
> http://support.microsoft.com/default.aspx?scid=kb;en-us;281642
>
> I followed the tip above but it didn't work. anyone know of other
workaround
> ?
> I restore a copy of my Production DB on a TestDB, the scheduled jobs get
> copied over as well. Cannot removed these job frm the Test DB because of
> error 14274.
> I logon the Test DB on workgroup, rename to original server name (on
> workgroup because the Production still exist on the network), tried to
> delete the jobs, SQL doesn't allow also. At the moment, I stopped the SQL
> Agent Service to prevent the jobs frm running.
> How to remove the jobs in the Test DB for good ?
>
>

error 14274

After I change a job and want to save, it gives me error as following:
error 14274: Cannot add, update or delete a job (or its steps or schedules)
that originates from an MSX server. The job was not save.
Can anyone please tell me how to fix this error? Thanks.
Hi!

> error 14274: Cannot add, update or delete a job (or its steps or
> schedules) that originates from an MSX server. The job was not save.
I guess this should help:
http://support.microsoft.com/default...;en-us;281642.
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message
|||Actually, I read this article. But I cannot down the SQL service and rename
the DB instance name as it said. What is other solution? Thanks.
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
message news:%23ZnjkyOQGHA.5400@.TK2MSFTNGP09.phx.gbl...
> Hi!
>
> I guess this should help:
> http://support.microsoft.com/default...;en-us;281642.
> --
> Dejan Sarka, SQL Server MVP
> Mentor, www.SolidQualityLearning.com
> Anything written in this message represents solely the point of view of
> the sender.
> This message does not imply endorsement from Solid Quality Learning, and
> it does not represent the point of view of Solid Quality Learning or any
> other person, company or institution mentioned in this message
>
|||Can anyone please help? This is urgent. Thanks.
"00KobeBrian" <a@.b.com> wrote in message
news:uGdduPPQGHA.312@.TK2MSFTNGP12.phx.gbl...
> Actually, I read this article. But I cannot down the SQL service and
> rename the DB instance name as it said. What is other solution? Thanks.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
> message news:%23ZnjkyOQGHA.5400@.TK2MSFTNGP09.phx.gbl...
>
|||Check the following article:
http://www.karaszi.com/sqlserver/inf...erver_name.asp
-Sue
On Tue, 7 Mar 2006 08:04:50 +0800, "00KobeBrian" <a@.b.com>
wrote:

>Can anyone please help? This is urgent. Thanks.
>"00KobeBrian" <a@.b.com> wrote in message
>news:uGdduPPQGHA.312@.TK2MSFTNGP12.phx.gbl...
>

error 14274

After I change a job and want to save, it gives me error as following:
error 14274: Cannot add, update or delete a job (or its steps or schedules)
that originates from an MSX server. The job was not save.
Can anyone please tell me how to fix this error? Thanks.Hi!

> error 14274: Cannot add, update or delete a job (or its steps or
> schedules) that originates from an MSX server. The job was not save.
I guess this should help:
http://support.microsoft.com/defaul...b;en-us;281642.
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message|||Actually, I read this article. But I cannot down the SQL service and rename
the DB instance name as it said. What is other solution? Thanks.
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:%23ZnjkyOQGHA.5400@.TK2MSFTNGP09.phx.gbl...
> Hi!
>
> I guess this should help:
> http://support.microsoft.com/defaul...b;en-us;281642.
> --
> Dejan Sarka, SQL Server MVP
> Mentor, www.SolidQualityLearning.com
> Anything written in this message represents solely the point of view of
> the sender.
> This message does not imply endorsement from Solid Quality Learning, and
> it does not represent the point of view of Solid Quality Learning or any
> other person, company or institution mentioned in this message
>|||Can anyone please help? This is urgent. Thanks.
"00KobeBrian" <a@.b.com> wrote in message
news:uGdduPPQGHA.312@.TK2MSFTNGP12.phx.gbl...
> Actually, I read this article. But I cannot down the SQL service and
> rename the DB instance name as it said. What is other solution? Thanks.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:%23ZnjkyOQGHA.5400@.TK2MSFTNGP09.phx.gbl...
>|||Check the following article:
http://www.karaszi.com/sqlserver/in...server_name.asp
-Sue
On Tue, 7 Mar 2006 08:04:50 +0800, "00KobeBrian" <a@.b.com>
wrote:

>Can anyone please help? This is urgent. Thanks.
>"00KobeBrian" <a@.b.com> wrote in message
>news:uGdduPPQGHA.312@.TK2MSFTNGP12.phx.gbl...
>sql

error 14274

After I change a job and want to save, it gives me error as following:
error 14274: Cannot add, update or delete a job (or its steps or schedules)
that originates from an MSX server. The job was not save.
Can anyone please tell me how to fix this error? Thanks.Hi!
> error 14274: Cannot add, update or delete a job (or its steps or
> schedules) that originates from an MSX server. The job was not save.
I guess this should help:
http://support.microsoft.com/default.aspx?scid=kb;en-us;281642.
--
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message|||Actually, I read this article. But I cannot down the SQL service and rename
the DB instance name as it said. What is other solution? Thanks.
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:%23ZnjkyOQGHA.5400@.TK2MSFTNGP09.phx.gbl...
> Hi!
>> error 14274: Cannot add, update or delete a job (or its steps or
>> schedules) that originates from an MSX server. The job was not save.
> I guess this should help:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;281642.
> --
> Dejan Sarka, SQL Server MVP
> Mentor, www.SolidQualityLearning.com
> Anything written in this message represents solely the point of view of
> the sender.
> This message does not imply endorsement from Solid Quality Learning, and
> it does not represent the point of view of Solid Quality Learning or any
> other person, company or institution mentioned in this message
>|||Can anyone please help? This is urgent. Thanks.
"00KobeBrian" <a@.b.com> wrote in message
news:uGdduPPQGHA.312@.TK2MSFTNGP12.phx.gbl...
> Actually, I read this article. But I cannot down the SQL service and
> rename the DB instance name as it said. What is other solution? Thanks.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:%23ZnjkyOQGHA.5400@.TK2MSFTNGP09.phx.gbl...
>> Hi!
>> error 14274: Cannot add, update or delete a job (or its steps or
>> schedules) that originates from an MSX server. The job was not save.
>> I guess this should help:
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;281642.
>> --
>> Dejan Sarka, SQL Server MVP
>> Mentor, www.SolidQualityLearning.com
>> Anything written in this message represents solely the point of view of
>> the sender.
>> This message does not imply endorsement from Solid Quality Learning, and
>> it does not represent the point of view of Solid Quality Learning or any
>> other person, company or institution mentioned in this message
>>
>|||Check the following article:
http://www.karaszi.com/sqlserver/info_change_server_name.asp
-Sue
On Tue, 7 Mar 2006 08:04:50 +0800, "00KobeBrian" <a@.b.com>
wrote:
>Can anyone please help? This is urgent. Thanks.
>"00KobeBrian" <a@.b.com> wrote in message
>news:uGdduPPQGHA.312@.TK2MSFTNGP12.phx.gbl...
>> Actually, I read this article. But I cannot down the SQL service and
>> rename the DB instance name as it said. What is other solution? Thanks.
>>
>> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
>> message news:%23ZnjkyOQGHA.5400@.TK2MSFTNGP09.phx.gbl...
>> Hi!
>> error 14274: Cannot add, update or delete a job (or its steps or
>> schedules) that originates from an MSX server. The job was not save.
>> I guess this should help:
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;281642.
>> --
>> Dejan Sarka, SQL Server MVP
>> Mentor, www.SolidQualityLearning.com
>> Anything written in this message represents solely the point of view of
>> the sender.
>> This message does not imply endorsement from Solid Quality Learning, and
>> it does not represent the point of view of Solid Quality Learning or any
>> other person, company or institution mentioned in this message
>>
>>
>

Error 1068

Dear friends hi,
I read the articles you mentioned, and as I understood,
the resolution is:
(To resolve the problem, use these steps:
Change the startup account of both the MSSQLSERVER and
SQLServerAgent to use the Local System account.
Restart the computer. )
As I told you before, the problem is that I can not start
the 'SqlServer' and 'SqlServer agent', so I cann't go and
change the startup account. I don't know, I may be
confused, but I just encountered this Error (Error 1068)
while starting up the SQLServer.
Thanks for any suggestion in advance,
Mattew
>--Original Message--
Mattew,
Hmmm. Probably means that something changed. Here is
one KB article. Does
it apply?
http://support.microsoft.com/default.aspx?scid=kb;en-
us;307288
A more general article (non-SQL Server) on the topic:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;827328
Russell Fields
"Mattew" <anonymous@.discussions.microsoft.com> wrote in
message
news:19d5001c44d8c$610cb740$a401280a@.phx.gbl...
Hi,
I'm getting the following error message:
(
Could not start the SQLServerAgent Serviceon local
computer
Error 1068 : The dependency service or group failed to
start
)
This server is a subscriber in a transactional
replication and it was working until yesterday.
Does anybody have a solution.
Thanks in advance.Hi,
Steps to change the service startup account:-
1. Go to control panel -- Administrative - tools
2. Double click in services icon
3. Select and double click the MSSQL Server Service
4. In the "Log on " tab, Check the this account
5. There you verify the OS user name
6. If the user name is correct , re- enter the password and confrim password
once again
7. CLick OK
8. Start the Service
Do the above steps for SQL Agent Service as well.
Note:
ON each password change you have to do the above steps. The best
recommendation to have a user name for MSSQL server Service startup which do
not chage password frequently or no password expiry is set.
Thanks
Hari
MCDBA
"Mattew" <anonymous@.discussions.microsoft.com> wrote in message
news:1a4a701c44e42$10919180$a401280a@.phx.gbl...
> Dear friends hi,
> I read the articles you mentioned, and as I understood,
> the resolution is:
> (To resolve the problem, use these steps:
> Change the startup account of both the MSSQLSERVER and
> SQLServerAgent to use the Local System account.
> Restart the computer. )
> As I told you before, the problem is that I can not start
> the 'SqlServer' and 'SqlServer agent', so I cann't go and
> change the startup account. I don't know, I may be
> confused, but I just encountered this Error (Error 1068)
> while starting up the SQLServer.
> Thanks for any suggestion in advance,
> Mattew
> >--Original Message--
> Mattew,
> Hmmm. Probably means that something changed. Here is
> one KB article. Does
> it apply?
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;307288
> A more general article (non-SQL Server) on the topic:
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;827328
> Russell Fields
> "Mattew" <anonymous@.discussions.microsoft.com> wrote in
> message
> news:19d5001c44d8c$610cb740$a401280a@.phx.gbl...
> Hi,
> I'm getting the following error message:
> (
> Could not start the SQLServerAgent Serviceon local
> computer
> Error 1068 : The dependency service or group failed to
> start
> )
> This server is a subscriber in a transactional
> replication and it was working until yesterday.
> Does anybody have a solution.
> Thanks in advance.|||OMG. What a horrible message to come in to work to!
I just read about changing the startup account in CPanel.
The only thing I would want to toss in is that if you
make login changes at the CPanel level, rather then
Enterprise Mgr, you will have a ton o' problems related
to reg entries and internal stuff.
To sidestep that, if you ARE able to get the server
started using a CPanel change, can you then go into EM
and change it in there under your server's
properties/security page? Kind of a "redundant change?"
ML
>--Original Message--
>Hi,
>Steps to change the service startup account:-
>1. Go to control panel -- Administrative - tools
>2. Double click in services icon
>3. Select and double click the MSSQL Server Service
>4. In the "Log on " tab, Check the this account
>5. There you verify the OS user name
>6. If the user name is correct , re- enter the password
and confrim password
>once again
>7. CLick OK
>8. Start the Service
>Do the above steps for SQL Agent Service as well.
>Note:
>ON each password change you have to do the above steps.
The best
>recommendation to have a user name for MSSQL server
Service startup which do
>not chage password frequently or no password expiry is
set.
>Thanks
>Hari
>MCDBA
>
>
>"Mattew" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1a4a701c44e42$10919180$a401280a@.phx.gbl...
>> Dear friends hi,
>> I read the articles you mentioned, and as I understood,
>> the resolution is:
>> (To resolve the problem, use these steps:
>> Change the startup account of both the MSSQLSERVER and
>> SQLServerAgent to use the Local System account.
>> Restart the computer. )
>> As I told you before, the problem is that I can not
start
>> the 'SqlServer' and 'SqlServer agent', so I cann't go
and
>> change the startup account. I don't know, I may be
>> confused, but I just encountered this Error (Error
1068)
>> while starting up the SQLServer.
>> Thanks for any suggestion in advance,
>> Mattew
>> >--Original Message--
>> Mattew,
>> Hmmm. Probably means that something changed. Here is
>> one KB article. Does
>> it apply?
>> http://support.microsoft.com/default.aspx?scid=kb;en-
>> us;307288
>> A more general article (non-SQL Server) on the topic:
>> http://support.microsoft.com/default.aspx?scid=kb;en-
>> us;827328
>> Russell Fields
>> "Mattew" <anonymous@.discussions.microsoft.com> wrote in
>> message
>> news:19d5001c44d8c$610cb740$a401280a@.phx.gbl...
>> Hi,
>> I'm getting the following error message:
>> (
>> Could not start the SQLServerAgent Serviceon local
>> computer
>> Error 1068 : The dependency service or group failed to
>> start
>> )
>> This server is a subscriber in a transactional
>> replication and it was working until yesterday.
>> Does anybody have a solution.
>> Thanks in advance.
>
>.
>