PLS help: SqlserverAgent service could not be started

Anyone can help me:
I get windows events like this:
"Could not start serveragent on local computer. The
service did not return an error. This could be an internal
windows error. If problem persists, contact your system
administrator"
SqlserverAgent error log:
[000]SQLServerAgent could not be started (reason:
SQLServerAgent must be able to connect to SQLServer as
SysAdmin, but '(Unknown)' is not a member of the SysAdmin
role)
[298]SQLServer error: 3621，statement stopped。 [SQLSTATE
01000] (ConnIsLoginSysAdmin)
[298] SQLServer error: 535，2 datetime columns'
difference made runtime overflow。 [SQLSTATE 22003]
(ConnIsLoginSysAdmin)
SqlserverAgent service start account set to administrator
and in SqlserverAgent connection properties, i have
tried "sql server connection" use sql server and NT
authentication, but both failed to start the service.
thanks a lot.> SqlserverAgent service start account set to administrator
Is this start account a member of he local administrators group?
What security authentication is the SQL instance configured to use? Is it
Windows or Mixed? I'd set the service startup account for SQLServerAgent to
the local system account, and try to start the SQL Agent service.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"brooks" <anonymous@.discussions.microsoft.com> wrote in message
news:0b0701c3a8c3$ed09aff0$a101280a@.phx.gbl...
> Anyone can help me:
> I get windows events like this:
> "Could not start serveragent on local computer. The
> service did not return an error. This could be an internal
> windows error. If problem persists, contact your system
> administrator"
> SqlserverAgent error log:
> [000]SQLServerAgent could not be started (reason:
> SQLServerAgent must be able to connect to SQLServer as
> SysAdmin, but '(Unknown)' is not a member of the SysAdmin
> role)
> [298]SQLServer error: 3621，statement stopped。 [SQLSTATE
> 01000] (ConnIsLoginSysAdmin)
> [298] SQLServer error: 535，2 datetime columns'
> difference made runtime overflow。 [SQLSTATE 22003]
> (ConnIsLoginSysAdmin)
> SqlserverAgent service start account set to administrator
> and in SqlserverAgent connection properties, i have
> tried "sql server connection" use sql server and NT
> authentication, but both failed to start the service.
> thanks a lot.|||> > SqlserverAgent service start account set to administrator
> Is this start account a member of he local administrators group?
Also, is the BUILTIN\Administraors windows account's Login in SQL Server
member of the sysadmin server role?
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Linchi Shea" <linchi_shea@.NOSPAMml.com> wrote in message
news:eB44wpOqDHA.1496@.TK2MSFTNGP11.phx.gbl...
> > SqlserverAgent service start account set to administrator
> Is this start account a member of he local administrators group?
> What security authentication is the SQL instance configured to use? Is it
> Windows or Mixed? I'd set the service startup account for SQLServerAgent
to
> the local system account, and try to start the SQL Agent service.
> --
> Linchi Shea
> linchi_shea@.NOSPAMml.com
>
> "brooks" <anonymous@.discussions.microsoft.com> wrote in message
> news:0b0701c3a8c3$ed09aff0$a101280a@.phx.gbl...
> > Anyone can help me:
> >
> > I get windows events like this:
> > "Could not start serveragent on local computer. The
> > service did not return an error. This could be an internal
> > windows error. If problem persists, contact your system
> > administrator"
> >
> > SqlserverAgent error log:
> > [000]SQLServerAgent could not be started (reason:
> > SQLServerAgent must be able to connect to SQLServer as
> > SysAdmin, but '(Unknown)' is not a member of the SysAdmin
> > role)
> > [298]SQLServer error: 3621，statement stopped。 [SQLSTATE
> > 01000] (ConnIsLoginSysAdmin)
> > [298] SQLServer error: 535，2 datetime columns'
> > difference made runtime overflow。 [SQLSTATE 22003]
> > (ConnIsLoginSysAdmin)
> >
> > SqlserverAgent service start account set to administrator
> > and in SqlserverAgent connection properties, i have
> > tried "sql server connection" use sql server and NT
> > authentication, but both failed to start the service.
> >
> > thanks a lot.
>|||Thanks a lot for your warmhearted reply, i tried
administrator account, sa(in connection properties of
sqlserveragent service), and bulltin/administrators, the
started account both in the sysadmin group, but it can't
start the service.
sqlserver authentication set to mixed
>--Original Message--
>> SqlserverAgent service start account set to
administrator
>Is this start account a member of he local administrators
group?
>What security authentication is the SQL instance
configured to use? Is it
>Windows or Mixed? I'd set the service startup account for
SQLServerAgent to
>the local system account, and try to start the SQL Agent
service.
>--
>Linchi Shea
>linchi_shea@.NOSPAMml.com
>
>"brooks" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0b0701c3a8c3$ed09aff0$a101280a@.phx.gbl...
>> Anyone can help me:
>> I get windows events like this:
>> "Could not start serveragent on local computer. The
>> service did not return an error. This could be an
internal
>> windows error. If problem persists, contact your system
>> administrator"
>> SqlserverAgent error log:
>> [000]SQLServerAgent could not be started (reason:
>> SQLServerAgent must be able to connect to SQLServer as
>> SysAdmin, but '(Unknown)' is not a member of the
SysAdmin
>> role)
>> [298]SQLServer error: 3621，statement stopped。
[SQLSTATE
>> 01000] (ConnIsLoginSysAdmin)
>> [298] SQLServer error: 535，2 datetime columns'
>> difference made runtime overflow。 [SQLSTATE 22003]
>> (ConnIsLoginSysAdmin)
>> SqlserverAgent service start account set to
administrator
>> and in SqlserverAgent connection properties, i have
>> tried "sql server connection" use sql server and NT
>> authentication, but both failed to start the service.
>> thanks a lot.
>
>.
>|||As I mentioned in my other post, you need to verify that the startup
account's login in SQL Server is member of the sysadmin server role.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"brooks" <brooks_xiao@.hotmail.com> wrote in message
news:1f4801c3a8fa$22560920$a601280a@.phx.gbl...
> Thanks a lot for your warmhearted reply, i tried
> administrator account, sa(in connection properties of
> sqlserveragent service), and bulltin/administrators, the
> started account both in the sysadmin group, but it can't
> start the service.
> sqlserver authentication set to mixed
> >--Original Message--
> >> SqlserverAgent service start account set to
> administrator
> >
> >Is this start account a member of he local administrators
> group?
> >
> >What security authentication is the SQL instance
> configured to use? Is it
> >Windows or Mixed? I'd set the service startup account for
> SQLServerAgent to
> >the local system account, and try to start the SQL Agent
> service.
> >
> >--
> >Linchi Shea
> >linchi_shea@.NOSPAMml.com
> >
> >
> >"brooks" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:0b0701c3a8c3$ed09aff0$a101280a@.phx.gbl...
> >> Anyone can help me:
> >>
> >> I get windows events like this:
> >> "Could not start serveragent on local computer. The
> >> service did not return an error. This could be an
> internal
> >> windows error. If problem persists, contact your system
> >> administrator"
> >>
> >> SqlserverAgent error log:
> >> [000]SQLServerAgent could not be started (reason:
> >> SQLServerAgent must be able to connect to SQLServer as
> >> SysAdmin, but '(Unknown)' is not a member of the
> SysAdmin
> >> role)
> >> [298]SQLServer error: 3621，statement stopped。
> [SQLSTATE
> >> 01000] (ConnIsLoginSysAdmin)
> >> [298] SQLServer error: 535，2 datetime columns'
> >> difference made runtime overflow。 [SQLSTATE 22003]
> >> (ConnIsLoginSysAdmin)
> >>
> >> SqlserverAgent service start account set to
> administrator
> >> and in SqlserverAgent connection properties, i have
> >> tried "sql server connection" use sql server and NT
> >> authentication, but both failed to start the service.
> >>
> >> thanks a lot.
> >
> >
> >.
> >|||Hi, Tibor Karaszi,thank you very much
I searched your articles in the group.sql...., but it
does not do any help, my problems is, i add a test account
(in NT administrators group), then add this to sql server
sysadmin group, but it could not make the agent service
start.
i think the following error messages is difference from
the others refered:
>> >> [298]SQLServer error: 3621，statement stopped。
>> [SQLSTATE
>> >> 01000] (ConnIsLoginSysAdmin)
>> >> [298] SQLServer error: 535，2 datetime columns'
>> >> difference made runtime overflow。 [SQLSTATE 22003]
>> >> (ConnIsLoginSysAdmin)
>> >>
thanks a lot for your help.|||You need to find out which Service Account Agent is using (EM, Management,
Properties).
Then you need to go to the security tab in SQL Server, logins, and for that
account (or a group that the account is a member of), edit it and on the
server roles tab, make it member of syadmins.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"brooks" <brooks_xiao@.hotmail.com> wrote in message
news:0e6501c3a8fd$49b3ac90$a101280a@.phx.gbl...
>
> Hi, Tibor Karaszi,thank you very much
> I searched your articles in the group.sql...., but it
> does not do any help, my problems is, i add a test account
> (in NT administrators group), then add this to sql server
> sysadmin group, but it could not make the agent service
> start.
> i think the following error messages is difference from
> the others refered:
> >> >> [298]SQLServer error: 3621，statement stopped。
> >> [SQLSTATE
> >> >> 01000] (ConnIsLoginSysAdmin)
> >> >> [298] SQLServer error: 535，2 datetime columns'
> >> >> difference made runtime overflow。 [SQLSTATE 22003]
> >> >> (ConnIsLoginSysAdmin)
> >> >>
> thanks a lot for your help.