(this is a repost, the original post was mistakenly posted to the odbc
group)
Hello all,
I have a nightly job which runs under the SQLServerAgent service on my
SQLServer2000 database. Someone mentioned that the jobs did not run
last night, so I logged in to the server to see why, and I noticed that
the SQLServerAgent service was not running, which seemed like something
that would prevent jobs under it from being executed.
However, when I try to right-click/Start the SQL Server Agent i get the
following error:
An error 1722 - (The RPC server is unavailable) occurred while
performing this service operation on the SQLServerAgent service.
But that's all it says. I've looked in the SQL Server Agent logs, as
well as the Windows Event View application logs, and no further
information is provided in either location.
Can anyone tell me what kinds of things might cause this error? I'm not
even sure where to begin looking.
Thanks
JasonMy guess (only a guess, though) is that you aren't sitting on the SQL Server
machine doing this. So
you are using EM remotely to start the service and something goes bad in the
remote communications
to start the service. First step I'd try is to login locally on the machine
(possibly using Remote
Desktop) and start the service using the Services Applet.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"jason" <iaesun@.yahoo.com> wrote in message
news:1132076344.251481.299800@.g14g2000cwa.googlegroups.com...
> (this is a repost, the original post was mistakenly posted to the odbc
> group)
> Hello all,
> I have a nightly job which runs under the SQLServerAgent service on my
> SQLServer2000 database. Someone mentioned that the jobs did not run
> last night, so I logged in to the server to see why, and I noticed that
> the SQLServerAgent service was not running, which seemed like something
> that would prevent jobs under it from being executed.
> However, when I try to right-click/Start the SQL Server Agent i get the
> following error:
> An error 1722 - (The RPC server is unavailable) occurred while
> performing this service operation on the SQLServerAgent service.
> But that's all it says. I've looked in the SQL Server Agent logs, as
> well as the Windows Event View application logs, and no further
> information is provided in either location.
> Can anyone tell me what kinds of things might cause this error? I'm not
> even sure where to begin looking.
> Thanks
> Jason
>|||that was indeed the problem. thanks a lot Tibor
jason
Showing posts with label sqlserveragent. Show all posts
Showing posts with label sqlserveragent. Show all posts
Monday, March 26, 2012
Thursday, March 22, 2012
Error 1604 when startign SQLAgent Service!
Hi,
I am beta testing MOM 2005 SQL MAnagement pack which requires the
SQLSERVERAGENT service to be started. But upon starting the same i get the
following error:
"Could not start the SQLSERVERAGENT on the computer.Eroor 1069 the service
did not start due to a logon failure".
Getting this error both on the 2003 and 2000 server.As I'm a newbie to SQL
can someone kindly let me know as to why this error is occuring?
Many Thanks!!!Verify that the domain / workgroup user account that is running the service
has the correct password.
Go to manage->services->SQLSERVERAGENT then Log On tab page and retype the
password (verify that the current user in the user field is correct). Now
see if the service will start.
=-Chris
"ipsec23" <ipsec23@.discussions.microsoft.com> wrote in message
news:4E0E46AA-5E78-4445-B1E0-666AF04BBB9C@.microsoft.com...
> Hi,
> I am beta testing MOM 2005 SQL MAnagement pack which requires the
> SQLSERVERAGENT service to be started. But upon starting the same i get the
> following error:
> "Could not start the SQLSERVERAGENT on the computer.Eroor 1069 the service
> did not start due to a logon failure".
> Getting this error both on the 2003 and 2000 server.As I'm a newbie to SQL
> can someone kindly let me know as to why this error is occuring?
> Many Thanks!!!
>
I am beta testing MOM 2005 SQL MAnagement pack which requires the
SQLSERVERAGENT service to be started. But upon starting the same i get the
following error:
"Could not start the SQLSERVERAGENT on the computer.Eroor 1069 the service
did not start due to a logon failure".
Getting this error both on the 2003 and 2000 server.As I'm a newbie to SQL
can someone kindly let me know as to why this error is occuring?
Many Thanks!!!Verify that the domain / workgroup user account that is running the service
has the correct password.
Go to manage->services->SQLSERVERAGENT then Log On tab page and retype the
password (verify that the current user in the user field is correct). Now
see if the service will start.
=-Chris
"ipsec23" <ipsec23@.discussions.microsoft.com> wrote in message
news:4E0E46AA-5E78-4445-B1E0-666AF04BBB9C@.microsoft.com...
> Hi,
> I am beta testing MOM 2005 SQL MAnagement pack which requires the
> SQLSERVERAGENT service to be started. But upon starting the same i get the
> following error:
> "Could not start the SQLSERVERAGENT on the computer.Eroor 1069 the service
> did not start due to a logon failure".
> Getting this error both on the 2003 and 2000 server.As I'm a newbie to SQL
> can someone kindly let me know as to why this error is occuring?
> Many Thanks!!!
>
Wednesday, March 21, 2012
Error 14258: Cannot perform this operation while SQLServerAgent is starting. Try again later.
I'm getting the following error on two of my SQL Servers -
Error 14258: Cannot perform this operation while SQLServerAgent is starting. Try again later.
The only solution that I have seen is the same solution that Microsoft has published in the following article - KB303287 [http://support.microsoft.com/?scid=http%3a%2f%2fwww.support.microsoft.com%2fkb%2f303287%2fen-us%2f]
The solution is to unflag the use of NT Fibers. However, our software application provider is advising us against doing this. Is there another fix anywhere that I could get my hands on - another solution?
Thanks in advance.
SQLAgent jobs fails because of the reason that it waits for event to signal recovery is complete.
Currently the only solution is to switch to thread mode.
http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsqldev/html/sqldev_02152005.asp
Above article recommends that you stay away from fiber mode and focus your tuning efforts on other things. If you run into a situation where you feel strongly you need fiber mode, it's probably worth a call into Microsoft Product Support Services to confirm your diagnosis.
Thanks,
Gops Dwarak
|||Thanks very much for the reply and for the extra information as well. My situation actually started when we attempted to create and use a local machine account to run the SQLSERVERAGENT service. I'm not sure if this brings more into play or not. I took the service back to using a different priviledged domain account to run the service and I'm not getting the errors currently.
I would, however, much rather run this service as a local user for security reasons. I have not yet taken a fresh look at Microsoft's best practices on this issue [the service account], but I will be taking a look at that as well.
thanks again.
|||We are having the same problem with our SQL Server Agent as well, and our started when we switched from the system account to a user account that was setup specifically for SQL.
Our server has 4 processors so I think that is why the server was originally flagged to run in fiber mode, however, I think we are going to have to switch back to thread mode because there are so many processes that this is killing by staying in fiber mode.
Anyway, if you have found out any further information on this subject I would greatly appreciate any advice you might have.
Thanks,
Lee
|||We are having the same problem with our SQL Server Agent as well,
The server is NOT flagged to run in fiber mode
Do you know how to fix it?
Thanks,
Oleg
|||As mentioned above in the posts, change the log on account from local system account to a specified account, even if its the same account that you are signed on to the server. Worked like a charm for me..
thanks guys...
|||Oleg
Have you referred to the article above and steps defined.
Also if you are using distributed transactions its might worth to enable the mSDTC to auto start.
|||Right on! How Fibre Mode got switched on will be vexing me now. At least server agent is running and I can see what is going on. When server agent hangs with a 14258, it seems to be running in enterprise manager but none of my jobs show a history from the point of failure.
I may have popped on the checkbox when i was looking at sql server properties. When the server was bounced last week to finish a patch the agent did not come back when Fibre Mode was enabled and hung all my agent jobs. That's the best I can do. Careful when you browse a production machine... I have DTS packages running on shedule so this turned out to be a big deal.
I will see tomorrow if everything runs ok. At least the error is clear when I try to edit the jobs. I would think a melitious attack to have caused real damage so I blame myself. Nothing in the security logs tells me any different. Thanks.
Error 14258: Cannot perform this operation while SQLServerAgent is starting. Try again later.
I'm getting the following error on two of my SQL Servers -
Error 14258: Cannot perform this operation while SQLServerAgent is starting. Try again later.
The only solution that I have seen is the same solution that Microsoft has published in the following article - KB303287 [http://support.microsoft.com/?scid=http%3a%2f%2fwww.support.microsoft.com%2fkb%2f303287%2fen-us%2f]
The solution is to unflag the use of NT Fibers. However, our software application provider is advising us against doing this. Is there another fix anywhere that I could get my hands on - another solution?
Thanks in advance.
SQLAgent jobs fails because of the reason that it waits for event to signal recovery is complete.
Currently the only solution is to switch to thread mode.
http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsqldev/html/sqldev_02152005.asp
Above article recommends that you stay away from fiber mode and focus your tuning efforts on other things. If you run into a situation where you feel strongly you need fiber mode, it's probably worth a call into Microsoft Product Support Services to confirm your diagnosis.
Thanks,
Gops Dwarak
|||Thanks very much for the reply and for the extra information as well. My situation actually started when we attempted to create and use a local machine account to run the SQLSERVERAGENT service. I'm not sure if this brings more into play or not. I took the service back to using a different priviledged domain account to run the service and I'm not getting the errors currently.
I would, however, much rather run this service as a local user for security reasons. I have not yet taken a fresh look at Microsoft's best practices on this issue [the service account], but I will be taking a look at that as well.
thanks again.
|||We are having the same problem with our SQL Server Agent as well, and our started when we switched from the system account to a user account that was setup specifically for SQL.
Our server has 4 processors so I think that is why the server was originally flagged to run in fiber mode, however, I think we are going to have to switch back to thread mode because there are so many processes that this is killing by staying in fiber mode.
Anyway, if you have found out any further information on this subject I would greatly appreciate any advice you might have.
Thanks,
Lee
|||We are having the same problem with our SQL Server Agent as well,
The server is NOT flagged to run in fiber mode
Do you know how to fix it?
Thanks,
Oleg
|||As mentioned above in the posts, change the log on account from local system account to a specified account, even if its the same account that you are signed on to the server. Worked like a charm for me..
thanks guys...
|||Oleg
Have you referred to the article above and steps defined.
Also if you are using distributed transactions its might worth to enable the mSDTC to auto start.
Error 14258: Cannot perform this operation while SQLServerAgent is starting. Try again later.
I'm getting the following error on two of my SQL Servers -
Error 14258: Cannot perform this operation while SQLServerAgent is starting. Try again later.
The only solution that I have seen is the same solution that Microsoft has published in the following article - KB303287 [http://support.microsoft.com/?scid=http%3a%2f%2fwww.support.microsoft.com%2fkb%2f303287%2fen-us%2f]
The solution is to unflag the use of NT Fibers. However, our software application provider is advising us against doing this. Is there another fix anywhere that I could get my hands on - another solution?
Thanks in advance.
SQLAgent jobs fails because of the reason that it waits for event to signal recovery is complete.
Currently the only solution is to switch to thread mode.
http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsqldev/html/sqldev_02152005.asp
Above article recommends that you stay away from fiber mode and focus your tuning efforts on other things. If you run into a situation where you feel strongly you need fiber mode, it's probably worth a call into Microsoft Product Support Services to confirm your diagnosis.
Thanks,
Gops Dwarak
|||Thanks very much for the reply and for the extra information as well. My situation actually started when we attempted to create and use a local machine account to run the SQLSERVERAGENT service. I'm not sure if this brings more into play or not. I took the service back to using a different priviledged domain account to run the service and I'm not getting the errors currently.
I would, however, much rather run this service as a local user for security reasons. I have not yet taken a fresh look at Microsoft's best practices on this issue [the service account], but I will be taking a look at that as well.
thanks again.
|||We are having the same problem with our SQL Server Agent as well, and our started when we switched from the system account to a user account that was setup specifically for SQL.
Our server has 4 processors so I think that is why the server was originally flagged to run in fiber mode, however, I think we are going to have to switch back to thread mode because there are so many processes that this is killing by staying in fiber mode.
Anyway, if you have found out any further information on this subject I would greatly appreciate any advice you might have.
Thanks,
Lee
|||We are having the same problem with our SQL Server Agent as well,
The server is NOT flagged to run in fiber mode
Do you know how to fix it?
Thanks,
Oleg
|||As mentioned above in the posts, change the log on account from local system account to a specified account, even if its the same account that you are signed on to the server. Worked like a charm for me..
thanks guys...
|||Oleg
Have you referred to the article above and steps defined.
Also if you are using distributed transactions its might worth to enable the mSDTC to auto start.
sqlError 14258 SqlServerAgent is Starting
I am running SQL Server 2000. I was trying to implement a Database Maintence Plan to do the reorgznize data and index pages on database 'MYDB' and received the following error:
Error 14258: CAnnot perform this operation while SQLServerAgent is starting. Try again later...
I checked the SQLAGENT.OUT file and it stated:
[393] Waiting for SQL Server to recover databases...
I also checked the ERRORLOG and all databases but didn't see any error message except:
.....
14304 transactions rolled forward in database 'MYDB' (7).
2004-06-29 14:40:12.17 spid11 0 transactions rolled back in database 'MYDB' (7).
2004-06-29 14:40:12.20 spid11 Recovery is checkpointing database 'MYDB' (7)
2004-06-29 14:42:17.98 spid52 Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'sp_MSgetversion'.
The 'MYDB' is one of the main databases and I did bounce the SQL Server prior because of some run aways processes.
How can I fix this problem? Please advise.Hi, Ling
Is your SQL Server running "lightweight pooling" mode and DTC service is started ?
If yes, it is the problem. see KB-Q303287
Johnny|||Thanks, Johnny. I finally reboot the machine and that fixed the problem. Thanks!|||Does anyone know of any way to successfully have DTC running AND have lightweight pooling on, or are the two mutually exclusive?
Also, would there really be that big of a performance difference between thread or fiber mode on a box with 3 processors?
Thanks for any help.
Kristy
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.|||You can have erratic problems when using DTC and fiber mode
which is why it's strongly recommended to use thread mode if
you need to have DTC running. See the following:
BUG: DTC Transactions May Fail When SQL Server Is Running in
Lightweight Pooling Mode
http://support.microsoft.com/?id=303287
In terms of the differences, fiber mode is rarely needed and
can cause a lot of problems. It's not necessarily a good
idea to just automatically switch to fiber and assume you
will get better performance. In the rare situations where
you would turn it on, it won't make that much of a
performance difference. See the following for more
information on the setting:
How to determine proper SQL Server configuration settings
http://support.microsoft.com/?id=319942
-Sue
On Mon, 22 Nov 2004 08:21:39 -0800, SqlJunkies User
<User@.-NOSPAM-SqlJunkies.com> wrote:
>Does anyone know of any way to successfully have DTC running AND have lightweight pooling on, or are the two mutually exclusive?
>Also, would there really be that big of a performance difference between thread or fiber mode on a box with 3 processors?
>Thanks for any help.
>Kristy
>--
>Posted using Wimdows.net NntpNews Component -
>Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Error 14258: CAnnot perform this operation while SQLServerAgent is starting. Try again later...
I checked the SQLAGENT.OUT file and it stated:
[393] Waiting for SQL Server to recover databases...
I also checked the ERRORLOG and all databases but didn't see any error message except:
.....
14304 transactions rolled forward in database 'MYDB' (7).
2004-06-29 14:40:12.17 spid11 0 transactions rolled back in database 'MYDB' (7).
2004-06-29 14:40:12.20 spid11 Recovery is checkpointing database 'MYDB' (7)
2004-06-29 14:42:17.98 spid52 Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'sp_MSgetversion'.
The 'MYDB' is one of the main databases and I did bounce the SQL Server prior because of some run aways processes.
How can I fix this problem? Please advise.Hi, Ling
Is your SQL Server running "lightweight pooling" mode and DTC service is started ?
If yes, it is the problem. see KB-Q303287
Johnny|||Thanks, Johnny. I finally reboot the machine and that fixed the problem. Thanks!|||Does anyone know of any way to successfully have DTC running AND have lightweight pooling on, or are the two mutually exclusive?
Also, would there really be that big of a performance difference between thread or fiber mode on a box with 3 processors?
Thanks for any help.
Kristy
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.|||You can have erratic problems when using DTC and fiber mode
which is why it's strongly recommended to use thread mode if
you need to have DTC running. See the following:
BUG: DTC Transactions May Fail When SQL Server Is Running in
Lightweight Pooling Mode
http://support.microsoft.com/?id=303287
In terms of the differences, fiber mode is rarely needed and
can cause a lot of problems. It's not necessarily a good
idea to just automatically switch to fiber and assume you
will get better performance. In the rare situations where
you would turn it on, it won't make that much of a
performance difference. See the following for more
information on the setting:
How to determine proper SQL Server configuration settings
http://support.microsoft.com/?id=319942
-Sue
On Mon, 22 Nov 2004 08:21:39 -0800, SqlJunkies User
<User@.-NOSPAM-SqlJunkies.com> wrote:
>Does anyone know of any way to successfully have DTC running AND have lightweight pooling on, or are the two mutually exclusive?
>Also, would there really be that big of a performance difference between thread or fiber mode on a box with 3 processors?
>Thanks for any help.
>Kristy
>--
>Posted using Wimdows.net NntpNews Component -
>Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Error 14258 SqlServerAgent is Starting
I am running SQL Server 2000. I was trying to implement a Database Maintenc
e Plan to do the reorgznize data and index pages on database 'MYDB' and rec
eived the following error:
Error 14258: CAnnot perform this operation while SQLServerAgent is starting.
Try again later...
I checked the SQLAGENT.OUT file and it stated:
[393] Waiting for SQL Server to recover databases...
I also checked the ERRORLOG and all databases but didn't see any error messa
ge except:
.....
14304 transactions rolled forward in database 'MYDB' (7).
2004-06-29 14:40:12.17 spid11 0 transactions rolled back in database 'MYD
B' (7).
2004-06-29 14:40:12.20 spid11 Recovery is checkpointing database 'MYDB' (
7)
2004-06-29 14:42:17.98 spid52 Using 'xpstar.dll' version '2000.80.760' to
execute extended stored procedure 'sp_MSgetversion'.
The 'MYDB' is one of the main databases and I did bounce the SQL Server prio
r because of some run aways processes.
How can I fix this problem? Please advise.Hi, Ling
Is your SQL Server running "lightweight pooling" mode and DTC service is st
arted ?
If yes, it is the problem. see KB-Q303287
Johnny|||Thanks, Johnny. I finally reboot the machine and that fixed the problem. T
hanks!|||Does anyone know of any way to successfully have DTC running AND have lightw
eight pooling on, or are the two mutually exclusive?
Also, would there really be that big of a performance difference between thr
ead or fiber mode on a box with 3 processors?
Thanks for any help.
Kristy
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.|||You can have erratic problems when using DTC and fiber mode
which is why it's strongly recommended to use thread mode if
you need to have DTC running. See the following:
BUG: DTC Transactions May Fail When SQL Server Is Running in
Lightweight Pooling Mode
http://support.microsoft.com/?id=303287
In terms of the differences, fiber mode is rarely needed and
can cause a lot of problems. It's not necessarily a good
idea to just automatically switch to fiber and assume you
will get better performance. In the rare situations where
you would turn it on, it won't make that much of a
performance difference. See the following for more
information on the setting:
How to determine proper SQL Server configuration settings
http://support.microsoft.com/?id=319942
-Sue
On Mon, 22 Nov 2004 08:21:39 -0800, SqlJunkies User
<User@.-NOSPAM-SqlJunkies.com> wrote:
>Does anyone know of any way to successfully have DTC running AND have light
weight pooling on, or are the two mutually exclusive?
>Also, would there really be that big of a performance difference between th
read or fiber mode on a box with 3 processors?
>Thanks for any help.
>Kristy
>--
>Posted using Wimdows.net NntpNews Component -
>Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports P
ost Alerts, Ratings, and Searching.sql
e Plan to do the reorgznize data and index pages on database 'MYDB' and rec
eived the following error:
Error 14258: CAnnot perform this operation while SQLServerAgent is starting.
Try again later...
I checked the SQLAGENT.OUT file and it stated:
[393] Waiting for SQL Server to recover databases...
I also checked the ERRORLOG and all databases but didn't see any error messa
ge except:
.....
14304 transactions rolled forward in database 'MYDB' (7).
2004-06-29 14:40:12.17 spid11 0 transactions rolled back in database 'MYD
B' (7).
2004-06-29 14:40:12.20 spid11 Recovery is checkpointing database 'MYDB' (
7)
2004-06-29 14:42:17.98 spid52 Using 'xpstar.dll' version '2000.80.760' to
execute extended stored procedure 'sp_MSgetversion'.
The 'MYDB' is one of the main databases and I did bounce the SQL Server prio
r because of some run aways processes.
How can I fix this problem? Please advise.Hi, Ling
Is your SQL Server running "lightweight pooling" mode and DTC service is st
arted ?
If yes, it is the problem. see KB-Q303287
Johnny|||Thanks, Johnny. I finally reboot the machine and that fixed the problem. T
hanks!|||Does anyone know of any way to successfully have DTC running AND have lightw
eight pooling on, or are the two mutually exclusive?
Also, would there really be that big of a performance difference between thr
ead or fiber mode on a box with 3 processors?
Thanks for any help.
Kristy
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.|||You can have erratic problems when using DTC and fiber mode
which is why it's strongly recommended to use thread mode if
you need to have DTC running. See the following:
BUG: DTC Transactions May Fail When SQL Server Is Running in
Lightweight Pooling Mode
http://support.microsoft.com/?id=303287
In terms of the differences, fiber mode is rarely needed and
can cause a lot of problems. It's not necessarily a good
idea to just automatically switch to fiber and assume you
will get better performance. In the rare situations where
you would turn it on, it won't make that much of a
performance difference. See the following for more
information on the setting:
How to determine proper SQL Server configuration settings
http://support.microsoft.com/?id=319942
-Sue
On Mon, 22 Nov 2004 08:21:39 -0800, SqlJunkies User
<User@.-NOSPAM-SqlJunkies.com> wrote:
>Does anyone know of any way to successfully have DTC running AND have light
weight pooling on, or are the two mutually exclusive?
>Also, would there really be that big of a performance difference between th
read or fiber mode on a box with 3 processors?
>Thanks for any help.
>Kristy
>--
>Posted using Wimdows.net NntpNews Component -
>Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports P
ost Alerts, Ratings, and Searching.sql
Error 14258 SqlServerAgent is Starting
I am running SQL Server 2000. I was trying to implement a Database Maintence Plan to do the reorgznize data and index pages on database 'MYDB' and received the following error:
Error 14258: CAnnot perform this operation while SQLServerAgent is starting. Try again later...
I checked the SQLAGENT.OUT file and it stated:
[393] Waiting for SQL Server to recover databases...
I also checked the ERRORLOG and all databases but didn't see any error message except:
......
14304 transactions rolled forward in database 'MYDB' (7).
2004-06-29 14:40:12.17 spid11 0 transactions rolled back in database 'MYDB' (7).
2004-06-29 14:40:12.20 spid11 Recovery is checkpointing database 'MYDB' (7)
2004-06-29 14:42:17.98 spid52 Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'sp_MSgetversion'.
The 'MYDB' is one of the main databases and I did bounce the SQL Server prior because of some run aways processes.
How can I fix this problem? Please advise.
Hi, Ling
Is your SQL Server running "lightweight pooling" mode and DTC service is started ?
If yes, it is the problem. see KB-Q303287
Johnny
Error 14258: CAnnot perform this operation while SQLServerAgent is starting. Try again later...
I checked the SQLAGENT.OUT file and it stated:
[393] Waiting for SQL Server to recover databases...
I also checked the ERRORLOG and all databases but didn't see any error message except:
......
14304 transactions rolled forward in database 'MYDB' (7).
2004-06-29 14:40:12.17 spid11 0 transactions rolled back in database 'MYDB' (7).
2004-06-29 14:40:12.20 spid11 Recovery is checkpointing database 'MYDB' (7)
2004-06-29 14:42:17.98 spid52 Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'sp_MSgetversion'.
The 'MYDB' is one of the main databases and I did bounce the SQL Server prior because of some run aways processes.
How can I fix this problem? Please advise.
Hi, Ling
Is your SQL Server running "lightweight pooling" mode and DTC service is started ?
If yes, it is the problem. see KB-Q303287
Johnny
Error 14258 SqlServerAgent is Starting
I am running SQL Server 2000. I was trying to implement a Database Maintence Plan to do the reorgznize data and index pages on database 'MYDB' and received the following error:
Error 14258: CAnnot perform this operation while SQLServerAgent is starting. Try again later...
I checked the SQLAGENT.OUT file and it stated:
[393] Waiting for SQL Server to recover databases...
I also checked the ERRORLOG and all databases but didn't see any error message except:
......
14304 transactions rolled forward in database 'MYDB' (7).
2004-06-29 14:40:12.17 spid11 0 transactions rolled back in database 'MYDB' (7).
2004-06-29 14:40:12.20 spid11 Recovery is checkpointing database 'MYDB' (7)
2004-06-29 14:42:17.98 spid52 Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'sp_MSgetversion'.
The 'MYDB' is one of the main databases and I did bounce the SQL Server prior because of some run aways processes.
How can I fix this problem? Please advise.
Hi, Ling
Is your SQL Server running "lightweight pooling" mode and DTC service is started ?
If yes, it is the problem. see KB-Q303287
Johnny
|||Thanks, Johnny. I finally reboot the machine and that fixed the problem. Thanks!
|||Does anyone know of any way to successfully have DTC running AND have lightweight pooling on, or are the two mutually exclusive?
Also, would there really be that big of a performance difference between thread or fiber mode on a box with 3 processors?
Thanks for any help.
Kristy
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
|||You can have erratic problems when using DTC and fiber mode
which is why it's strongly recommended to use thread mode if
you need to have DTC running. See the following:
BUG: DTC Transactions May Fail When SQL Server Is Running in
Lightweight Pooling Mode
http://support.microsoft.com/?id=303287
In terms of the differences, fiber mode is rarely needed and
can cause a lot of problems. It's not necessarily a good
idea to just automatically switch to fiber and assume you
will get better performance. In the rare situations where
you would turn it on, it won't make that much of a
performance difference. See the following for more
information on the setting:
How to determine proper SQL Server configuration settings
http://support.microsoft.com/?id=319942
-Sue
On Mon, 22 Nov 2004 08:21:39 -0800, SqlJunkies User
<User@.-NOSPAM-SqlJunkies.com> wrote:
>Does anyone know of any way to successfully have DTC running AND have lightweight pooling on, or are the two mutually exclusive?
>Also, would there really be that big of a performance difference between thread or fiber mode on a box with 3 processors?
>Thanks for any help.
>Kristy
>--
>Posted using Wimdows.net NntpNews Component -
>Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Error 14258: CAnnot perform this operation while SQLServerAgent is starting. Try again later...
I checked the SQLAGENT.OUT file and it stated:
[393] Waiting for SQL Server to recover databases...
I also checked the ERRORLOG and all databases but didn't see any error message except:
......
14304 transactions rolled forward in database 'MYDB' (7).
2004-06-29 14:40:12.17 spid11 0 transactions rolled back in database 'MYDB' (7).
2004-06-29 14:40:12.20 spid11 Recovery is checkpointing database 'MYDB' (7)
2004-06-29 14:42:17.98 spid52 Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'sp_MSgetversion'.
The 'MYDB' is one of the main databases and I did bounce the SQL Server prior because of some run aways processes.
How can I fix this problem? Please advise.
Hi, Ling
Is your SQL Server running "lightweight pooling" mode and DTC service is started ?
If yes, it is the problem. see KB-Q303287
Johnny
|||Thanks, Johnny. I finally reboot the machine and that fixed the problem. Thanks!
|||Does anyone know of any way to successfully have DTC running AND have lightweight pooling on, or are the two mutually exclusive?
Also, would there really be that big of a performance difference between thread or fiber mode on a box with 3 processors?
Thanks for any help.
Kristy
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
|||You can have erratic problems when using DTC and fiber mode
which is why it's strongly recommended to use thread mode if
you need to have DTC running. See the following:
BUG: DTC Transactions May Fail When SQL Server Is Running in
Lightweight Pooling Mode
http://support.microsoft.com/?id=303287
In terms of the differences, fiber mode is rarely needed and
can cause a lot of problems. It's not necessarily a good
idea to just automatically switch to fiber and assume you
will get better performance. In the rare situations where
you would turn it on, it won't make that much of a
performance difference. See the following for more
information on the setting:
How to determine proper SQL Server configuration settings
http://support.microsoft.com/?id=319942
-Sue
On Mon, 22 Nov 2004 08:21:39 -0800, SqlJunkies User
<User@.-NOSPAM-SqlJunkies.com> wrote:
>Does anyone know of any way to successfully have DTC running AND have lightweight pooling on, or are the two mutually exclusive?
>Also, would there really be that big of a performance difference between thread or fiber mode on a box with 3 processors?
>Thanks for any help.
>Kristy
>--
>Posted using Wimdows.net NntpNews Component -
>Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Error 14258
Hi,
The SQLServerAgent has NOT started properly after a
shutdown/reboot two days ago. If you look at the service
manager, the service appears to have started, but its
really not.
Here is what you have to do:
Stop the SQLServerAgent (Not SQL Server)
Restart the service (make no errors are recorded)
Here is something else you may have not noticed, since
this error has been occurring, your scheduled jobs have
not run. You might want to backup your databases and run
any other jobs you may have.
hth
DeeJay
>--Original Message--
>For the last two days I've been getting this error
whenever I click on a Job
>in Enterprise Manager:
>Error 14258: Cannot perform this operation while
SQLServerAgent is starting.
>Try again later.
>Any idea what is causing this? Agent appears to be
running - it is
>performing the assigned tasks on schedule.
>
>.
>
OK I've stopped and restarted the service several times. Event Viewer claims
the service started succesfully. Where else can I look for errors? The SQL
Server logs show no errors with the Agent. But you are correct - the jobs
are NOT running! Any other sugggestions on where to look for the problem?
"DeeJay Puar" <deejaypuar@.Yahoo.com> wrote in message
news:393601c48f89$d0181ff0$a501280a@.phx.gbl...[vbcol=seagreen]
> Hi,
> The SQLServerAgent has NOT started properly after a
> shutdown/reboot two days ago. If you look at the service
> manager, the service appears to have started, but its
> really not.
> Here is what you have to do:
> Stop the SQLServerAgent (Not SQL Server)
> Restart the service (make no errors are recorded)
> Here is something else you may have not noticed, since
> this error has been occurring, your scheduled jobs have
> not run. You might want to backup your databases and run
> any other jobs you may have.
> hth
> DeeJay
> whenever I click on a Job
> SQLServerAgent is starting.
> running - it is
The SQLServerAgent has NOT started properly after a
shutdown/reboot two days ago. If you look at the service
manager, the service appears to have started, but its
really not.
Here is what you have to do:
Stop the SQLServerAgent (Not SQL Server)
Restart the service (make no errors are recorded)
Here is something else you may have not noticed, since
this error has been occurring, your scheduled jobs have
not run. You might want to backup your databases and run
any other jobs you may have.
hth
DeeJay
>--Original Message--
>For the last two days I've been getting this error
whenever I click on a Job
>in Enterprise Manager:
>Error 14258: Cannot perform this operation while
SQLServerAgent is starting.
>Try again later.
>Any idea what is causing this? Agent appears to be
running - it is
>performing the assigned tasks on schedule.
>
>.
>
OK I've stopped and restarted the service several times. Event Viewer claims
the service started succesfully. Where else can I look for errors? The SQL
Server logs show no errors with the Agent. But you are correct - the jobs
are NOT running! Any other sugggestions on where to look for the problem?
"DeeJay Puar" <deejaypuar@.Yahoo.com> wrote in message
news:393601c48f89$d0181ff0$a501280a@.phx.gbl...[vbcol=seagreen]
> Hi,
> The SQLServerAgent has NOT started properly after a
> shutdown/reboot two days ago. If you look at the service
> manager, the service appears to have started, but its
> really not.
> Here is what you have to do:
> Stop the SQLServerAgent (Not SQL Server)
> Restart the service (make no errors are recorded)
> Here is something else you may have not noticed, since
> this error has been occurring, your scheduled jobs have
> not run. You might want to backup your databases and run
> any other jobs you may have.
> hth
> DeeJay
> whenever I click on a Job
> SQLServerAgent is starting.
> running - it is
Error 14258
Hi,
The SQLServerAgent has NOT started properly after a
shutdown/reboot two days ago. If you look at the service
manager, the service appears to have started, but its
really not.
Here is what you have to do:
Stop the SQLServerAgent (Not SQL Server)
Restart the service (make no errors are recorded)
Here is something else you may have not noticed, since
this error has been occurring, your scheduled jobs have
not run. You might want to backup your databases and run
any other jobs you may have.
hth
DeeJay
>--Original Message--
>For the last two days I've been getting this error
whenever I click on a Job
>in Enterprise Manager:
>Error 14258: Cannot perform this operation while
SQLServerAgent is starting.
>Try again later.
>Any idea what is causing this? Agent appears to be
running - it is
>performing the assigned tasks on schedule.
>
>.
>OK I've stopped and restarted the service several times. Event Viewer claims
the service started succesfully. Where else can I look for errors? The SQL
Server logs show no errors with the Agent. But you are correct - the jobs
are NOT running! Any other sugggestions on where to look for the problem?
"DeeJay Puar" <deejaypuar@.Yahoo.com> wrote in message
news:393601c48f89$d0181ff0$a501280a@.phx.gbl...[vbcol=seagreen]
> Hi,
> The SQLServerAgent has NOT started properly after a
> shutdown/reboot two days ago. If you look at the service
> manager, the service appears to have started, but its
> really not.
> Here is what you have to do:
> Stop the SQLServerAgent (Not SQL Server)
> Restart the service (make no errors are recorded)
> Here is something else you may have not noticed, since
> this error has been occurring, your scheduled jobs have
> not run. You might want to backup your databases and run
> any other jobs you may have.
> hth
> DeeJay
> whenever I click on a Job
> SQLServerAgent is starting.
> running - it is
The SQLServerAgent has NOT started properly after a
shutdown/reboot two days ago. If you look at the service
manager, the service appears to have started, but its
really not.
Here is what you have to do:
Stop the SQLServerAgent (Not SQL Server)
Restart the service (make no errors are recorded)
Here is something else you may have not noticed, since
this error has been occurring, your scheduled jobs have
not run. You might want to backup your databases and run
any other jobs you may have.
hth
DeeJay
>--Original Message--
>For the last two days I've been getting this error
whenever I click on a Job
>in Enterprise Manager:
>Error 14258: Cannot perform this operation while
SQLServerAgent is starting.
>Try again later.
>Any idea what is causing this? Agent appears to be
running - it is
>performing the assigned tasks on schedule.
>
>.
>OK I've stopped and restarted the service several times. Event Viewer claims
the service started succesfully. Where else can I look for errors? The SQL
Server logs show no errors with the Agent. But you are correct - the jobs
are NOT running! Any other sugggestions on where to look for the problem?
"DeeJay Puar" <deejaypuar@.Yahoo.com> wrote in message
news:393601c48f89$d0181ff0$a501280a@.phx.gbl...[vbcol=seagreen]
> Hi,
> The SQLServerAgent has NOT started properly after a
> shutdown/reboot two days ago. If you look at the service
> manager, the service appears to have started, but its
> really not.
> Here is what you have to do:
> Stop the SQLServerAgent (Not SQL Server)
> Restart the service (make no errors are recorded)
> Here is something else you may have not noticed, since
> this error has been occurring, your scheduled jobs have
> not run. You might want to backup your databases and run
> any other jobs you may have.
> hth
> DeeJay
> whenever I click on a Job
> SQLServerAgent is starting.
> running - it is
Sunday, March 11, 2012
Error 1068: Could not start the SQLServerAgent Service
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.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.|||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.
>
>.
>|||If that turns out to be the problem, perhaps the following articles will
help.
Changing SQL Server Services Accounts After Install
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_
afterinstall_4p0z.asp
and
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht
_install_4yi1.asp
Russell Fields
"Mattew" <anonymous@.discussions.microsoft.com> wrote in message
news:1a20c01c44e3d$d0f168b0$a301280a@.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.
> >
> >
> >.
> >
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.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.|||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.
>
>.
>|||If that turns out to be the problem, perhaps the following articles will
help.
Changing SQL Server Services Accounts After Install
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_
afterinstall_4p0z.asp
and
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht
_install_4yi1.asp
Russell Fields
"Mattew" <anonymous@.discussions.microsoft.com> wrote in message
news:1a20c01c44e3d$d0f168b0$a301280a@.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.
> >
> >
> >.
> >
Error 1068: Could not start the SQLServerAgent Service
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.Mattew,
Hmmm. Probably means that something changed. Here is one KB article. Does
it apply?
http://support.microsoft.com/defaul...kb;en-us;307288
A more general article (non-SQL Server) on the topic:
http://support.microsoft.com/defaul...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.|||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...
computer[vbcol=seagreen]
replication[vbcol=seagreen]
>
>.
>|||If that turns out to be the problem, perhaps the following articles will
help.
Changing SQL Server Services Accounts After Install
http://msdn.microsoft.com/library/d...-us/instsql/in_
afterinstall_4p0z.asp
and
http://msdn.microsoft.com/library/d...-us/howtosql/ht
_install_4yi1.asp
Russell Fields
"Mattew" <anonymous@.discussions.microsoft.com> wrote in message
news:1a20c01c44e3d$d0f168b0$a301280a@.phx
.gbl...[vbcol=seagreen]
> 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
>
> one KB article. Does
> us;307288
> us;827328
> message
> computer
> replication
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.Mattew,
Hmmm. Probably means that something changed. Here is one KB article. Does
it apply?
http://support.microsoft.com/defaul...kb;en-us;307288
A more general article (non-SQL Server) on the topic:
http://support.microsoft.com/defaul...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.|||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...
computer[vbcol=seagreen]
replication[vbcol=seagreen]
>
>.
>|||If that turns out to be the problem, perhaps the following articles will
help.
Changing SQL Server Services Accounts After Install
http://msdn.microsoft.com/library/d...-us/instsql/in_
afterinstall_4p0z.asp
and
http://msdn.microsoft.com/library/d...-us/howtosql/ht
_install_4yi1.asp
Russell Fields
"Mattew" <anonymous@.discussions.microsoft.com> wrote in message
news:1a20c01c44e3d$d0f168b0$a301280a@.phx
.gbl...[vbcol=seagreen]
> 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
>
> one KB article. Does
> us;307288
> us;827328
> message
> computer
> replication
Error 1068: Could not start the SQLServerAgent Service
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.
Mattew,
Hmmm. Probably means that something changed. Here is one KB article. Does
it apply?
http://support.microsoft.com/default...b;en-us;307288
A more general article (non-SQL Server) on the topic:
http://support.microsoft.com/default...b;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.
|||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[vbcol=seagreen]
>news:19d5001c44d8c$610cb740$a401280a@.phx.gbl...
computer[vbcol=seagreen]
replication
>
>.
>
|||If that turns out to be the problem, perhaps the following articles will
help.
Changing SQL Server Services Accounts After Install
http://msdn.microsoft.com/library/de...us/instsql/in_
afterinstall_4p0z.asp
and
http://msdn.microsoft.com/library/de...us/howtosql/ht
_install_4yi1.asp
Russell Fields
"Mattew" <anonymous@.discussions.microsoft.com> wrote in message
news:1a20c01c44e3d$d0f168b0$a301280a@.phx.gbl...[vbcol=seagreen]
> 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
> one KB article. Does
> us;307288
> us;827328
> message
> computer
> replication
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.
Mattew,
Hmmm. Probably means that something changed. Here is one KB article. Does
it apply?
http://support.microsoft.com/default...b;en-us;307288
A more general article (non-SQL Server) on the topic:
http://support.microsoft.com/default...b;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.
|||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[vbcol=seagreen]
>news:19d5001c44d8c$610cb740$a401280a@.phx.gbl...
computer[vbcol=seagreen]
replication
>
>.
>
|||If that turns out to be the problem, perhaps the following articles will
help.
Changing SQL Server Services Accounts After Install
http://msdn.microsoft.com/library/de...us/instsql/in_
afterinstall_4p0z.asp
and
http://msdn.microsoft.com/library/de...us/howtosql/ht
_install_4yi1.asp
Russell Fields
"Mattew" <anonymous@.discussions.microsoft.com> wrote in message
news:1a20c01c44e3d$d0f168b0$a301280a@.phx.gbl...[vbcol=seagreen]
> 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
> one KB article. Does
> us;307288
> us;827328
> message
> computer
> replication
Error 1068 Can't start SQLSERVERAGENT and MSSQLSERVER
I was rebuilding my index and my system admin rebooted the system without
shutting down the database first. After the reboot the SQLSERVERAGENT and
MSSQLSERVER services won't start and I received ERROR 1068:The dependency
service or group failed to start error while trying to start the two services.
In the Enterprise Manger screen I saw:
Connection failed, check SQL Server Registration Properties
I am not sure how to fix this problem. Can I rebuild my SQL Server
registery, and if so, how? Please advise. Thanks in advance.
Hi,
Could you please open the SQL server errorlog in program files\microsoft sql
server\log folder and investigate more on this error.
Thanks
Hari
MCDBA
"Ling" wrote:
> I was rebuilding my index and my system admin rebooted the system without
> shutting down the database first. After the reboot the SQLSERVERAGENT and
> MSSQLSERVER services won't start and I received ERROR 1068:The dependency
> service or group failed to start error while trying to start the two services.
> In the Enterprise Manger screen I saw:
> Connection failed, check SQL Server Registration Properties
> I am not sure how to fix this problem. Can I rebuild my SQL Server
> registery, and if so, how? Please advise. Thanks in advance.
|||There's only one line in the errorlog:
2004-09-22 11:28:07.03 server The system is older than SQL Server 7.0 RTM
version and is not supported by this server
"Hari Prasad" wrote:
[vbcol=seagreen]
> Hi,
> Could you please open the SQL server errorlog in program files\microsoft sql
> server\log folder and investigate more on this error.
> Thanks
> Hari
> MCDBA
>
> "Ling" wrote:
|||What exact messages do you get if you from a DOS prompt type below?
NET START MSSQLSERVER
(Adjust server name of it is a named instance.)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ling" <Ling@.discussions.microsoft.com> wrote in message
news:F823DF33-6210-4E2D-AA98-37E2FEFD1659@.microsoft.com...
> I was rebuilding my index and my system admin rebooted the system without
> shutting down the database first. After the reboot the SQLSERVERAGENT and
> MSSQLSERVER services won't start and I received ERROR 1068:The dependency
> service or group failed to start error while trying to start the two services.
> In the Enterprise Manger screen I saw:
> Connection failed, check SQL Server Registration Properties
> I am not sure how to fix this problem. Can I rebuild my SQL Server
> registery, and if so, how? Please advise. Thanks in advance.
shutting down the database first. After the reboot the SQLSERVERAGENT and
MSSQLSERVER services won't start and I received ERROR 1068:The dependency
service or group failed to start error while trying to start the two services.
In the Enterprise Manger screen I saw:
Connection failed, check SQL Server Registration Properties
I am not sure how to fix this problem. Can I rebuild my SQL Server
registery, and if so, how? Please advise. Thanks in advance.
Hi,
Could you please open the SQL server errorlog in program files\microsoft sql
server\log folder and investigate more on this error.
Thanks
Hari
MCDBA
"Ling" wrote:
> I was rebuilding my index and my system admin rebooted the system without
> shutting down the database first. After the reboot the SQLSERVERAGENT and
> MSSQLSERVER services won't start and I received ERROR 1068:The dependency
> service or group failed to start error while trying to start the two services.
> In the Enterprise Manger screen I saw:
> Connection failed, check SQL Server Registration Properties
> I am not sure how to fix this problem. Can I rebuild my SQL Server
> registery, and if so, how? Please advise. Thanks in advance.
|||There's only one line in the errorlog:
2004-09-22 11:28:07.03 server The system is older than SQL Server 7.0 RTM
version and is not supported by this server
"Hari Prasad" wrote:
[vbcol=seagreen]
> Hi,
> Could you please open the SQL server errorlog in program files\microsoft sql
> server\log folder and investigate more on this error.
> Thanks
> Hari
> MCDBA
>
> "Ling" wrote:
|||What exact messages do you get if you from a DOS prompt type below?
NET START MSSQLSERVER
(Adjust server name of it is a named instance.)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ling" <Ling@.discussions.microsoft.com> wrote in message
news:F823DF33-6210-4E2D-AA98-37E2FEFD1659@.microsoft.com...
> I was rebuilding my index and my system admin rebooted the system without
> shutting down the database first. After the reboot the SQLSERVERAGENT and
> MSSQLSERVER services won't start and I received ERROR 1068:The dependency
> service or group failed to start error while trying to start the two services.
> In the Enterprise Manger screen I saw:
> Connection failed, check SQL Server Registration Properties
> I am not sure how to fix this problem. Can I rebuild my SQL Server
> registery, and if so, how? Please advise. Thanks in advance.
Error 1068 Can't start SQLSERVERAGENT and MSSQLSERVER
On manually starting SQLSERVERAGENT service, it gives the following
error:
error 1068: The depending service for group failed to start.
Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
services.
Thanks,
misecprj
Start > Run > services.msc > SLSERVERAGENT > Properties > Dependencies
See which dependant services are not running.
"misecprj@.hotmail.com" wrote:
> On manually starting SQLSERVERAGENT service, it gives the following
> error:
> error 1068: The depending service for group failed to start.
> Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
> services.
> Thanks,
> misecprj
>
|||Hi
In the services applet in control panel you can view the dependencies of a
service and start the services as well. Make sure that you are logged into an
account that has permissions to start services.
John
"misecprj@.hotmail.com" wrote:
> On manually starting SQLSERVERAGENT service, it gives the following
> error:
> error 1068: The depending service for group failed to start.
> Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
> services.
> Thanks,
> misecprj
>
error:
error 1068: The depending service for group failed to start.
Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
services.
Thanks,
misecprj
Start > Run > services.msc > SLSERVERAGENT > Properties > Dependencies
See which dependant services are not running.
"misecprj@.hotmail.com" wrote:
> On manually starting SQLSERVERAGENT service, it gives the following
> error:
> error 1068: The depending service for group failed to start.
> Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
> services.
> Thanks,
> misecprj
>
|||Hi
In the services applet in control panel you can view the dependencies of a
service and start the services as well. Make sure that you are logged into an
account that has permissions to start services.
John
"misecprj@.hotmail.com" wrote:
> On manually starting SQLSERVERAGENT service, it gives the following
> error:
> error 1068: The depending service for group failed to start.
> Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
> services.
> Thanks,
> misecprj
>
Error 1068 Can't start SQLSERVERAGENT and MSSQLSERVER
On manually starting SQLSERVERAGENT service, it gives the following
error:
error 1068: The depending service for group failed to start.
Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
services.
Thanks,
misecprjStart > Run > services.msc > SLSERVERAGENT > Properties > Dependencies
See which dependant services are not running.
"misecprj@.hotmail.com" wrote:
> On manually starting SQLSERVERAGENT service, it gives the following
> error:
> error 1068: The depending service for group failed to start.
> Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
> services.
> Thanks,
> misecprj
>|||Hi
In the services applet in control panel you can view the dependencies of a
service and start the services as well. Make sure that you are logged into a
n
account that has permissions to start services.
John
"misecprj@.hotmail.com" wrote:
> On manually starting SQLSERVERAGENT service, it gives the following
> error:
> error 1068: The depending service for group failed to start.
> Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
> services.
> Thanks,
> misecprj
>
error:
error 1068: The depending service for group failed to start.
Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
services.
Thanks,
misecprjStart > Run > services.msc > SLSERVERAGENT > Properties > Dependencies
See which dependant services are not running.
"misecprj@.hotmail.com" wrote:
> On manually starting SQLSERVERAGENT service, it gives the following
> error:
> error 1068: The depending service for group failed to start.
> Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
> services.
> Thanks,
> misecprj
>|||Hi
In the services applet in control panel you can view the dependencies of a
service and start the services as well. Make sure that you are logged into a
n
account that has permissions to start services.
John
"misecprj@.hotmail.com" wrote:
> On manually starting SQLSERVERAGENT service, it gives the following
> error:
> error 1068: The depending service for group failed to start.
> Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
> services.
> Thanks,
> misecprj
>
Error 1068 Can't start SQLSERVERAGENT and MSSQLSERVER
On manually starting SQLSERVERAGENT service, it gives the following
error:
error 1068: The depending service for group failed to start.
Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
services.
Thanks,
misecprjStart > Run > services.msc > SLSERVERAGENT > Properties > Dependencies
See which dependant services are not running.
"misecprj@.hotmail.com" wrote:
> On manually starting SQLSERVERAGENT service, it gives the following
> error:
> error 1068: The depending service for group failed to start.
> Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
> services.
> Thanks,
> misecprj
>|||Hi
In the services applet in control panel you can view the dependencies of a
service and start the services as well. Make sure that you are logged into an
account that has permissions to start services.
John
"misecprj@.hotmail.com" wrote:
> On manually starting SQLSERVERAGENT service, it gives the following
> error:
> error 1068: The depending service for group failed to start.
> Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
> services.
> Thanks,
> misecprj
>
error:
error 1068: The depending service for group failed to start.
Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
services.
Thanks,
misecprjStart > Run > services.msc > SLSERVERAGENT > Properties > Dependencies
See which dependant services are not running.
"misecprj@.hotmail.com" wrote:
> On manually starting SQLSERVERAGENT service, it gives the following
> error:
> error 1068: The depending service for group failed to start.
> Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
> services.
> Thanks,
> misecprj
>|||Hi
In the services applet in control panel you can view the dependencies of a
service and start the services as well. Make sure that you are logged into an
account that has permissions to start services.
John
"misecprj@.hotmail.com" wrote:
> On manually starting SQLSERVERAGENT service, it gives the following
> error:
> error 1068: The depending service for group failed to start.
> Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
> services.
> Thanks,
> misecprj
>
Subscribe to:
Posts (Atom)