Sunday, February 12, 2012

Cannot Generate SSPI Context

hi @.all,
when rebooting the sbs 2k3 server, first the service sqlagent$sbsmonitoring
failes to start and then the sqlserveragent. both events are record with the
event id 103:
sqlagent$sbsmonitoring:
SQLServerAgent could not be started (reason: Unable to connect to server
"(sbs\sbsmonitoring)"; SQLServerAgent
cannot start).
sqlserveragent:
SQLServerAgent could not be started (reason: Unable to connect to server
"(local)"; SQLServerAgent
cannot start).
after searching the web i found an articel describing to look for the
sqlagent.out file. i found two files in "microsoft sql server\mssql\log" and
"microsoft sql server\mssql$sbsmonitoring". both have the error "Cannot
Generate SSPI Context".
when i start the services manually it works fine, but NOT on startup... i
even searched the kb from ms, but didn´t find anything that helped me.
even if i set the services to start over if an error occure, it doesn´t
work. only if i start the services manually... :(
the services are set to start with the local system account.
i don´t have any knowledge from a sql server. can somebody please help me!
--
kind regards / liebe grüsse
dominiqueHi
This sounds like it can not authenticate the service account in the AD, have
you tried setting it to the system account or to a different domain one?
John
"dominique" wrote:
> hi @.all,
> when rebooting the sbs 2k3 server, first the service sqlagent$sbsmonitoring
> failes to start and then the sqlserveragent. both events are record with the
> event id 103:
> sqlagent$sbsmonitoring:
> SQLServerAgent could not be started (reason: Unable to connect to server
> "(sbs\sbsmonitoring)"; SQLServerAgent
> cannot start).
> sqlserveragent:
> SQLServerAgent could not be started (reason: Unable to connect to server
> "(local)"; SQLServerAgent
> cannot start).
> after searching the web i found an articel describing to look for the
> sqlagent.out file. i found two files in "microsoft sql server\mssql\log" and
> "microsoft sql server\mssql$sbsmonitoring". both have the error "Cannot
> Generate SSPI Context".
> when i start the services manually it works fine, but NOT on startup... i
> even searched the kb from ms, but didn´t find anything that helped me.
> even if i set the services to start over if an error occure, it doesn´t
> work. only if i start the services manually... :(
> the services are set to start with the local system account.
> i don´t have any knowledge from a sql server. can somebody please help me!
> --
> kind regards / liebe grüsse
> dominique|||hi john,
first of all, thank you for your answer.
i´m using the system account all the time.
i just tried your suggestion using a domain account for starting the two
services and rebooted the server. now the events 103 are gone, but i´m
getting two events 7000 service control manager:
(translation from german)
the "SQLAgent$SBSMONITORING" / "SQLSERVERAGENT" service failed to start due
to the following error:
the accountname is incorrect or not existent, or the password for the
accountname is incorrect.
the account is a domain-admin account.
when i tried to start the service manually it was successfull again... ://
i don´t understand it... :(
any ideas?
--
kind regards / liebe grüsse
dominique
"John Bell" wrote:
> Hi
> This sounds like it can not authenticate the service account in the AD, have
> you tried setting it to the system account or to a different domain one?
> John
> "dominique" wrote:
> > hi @.all,
> >
> > when rebooting the sbs 2k3 server, first the service sqlagent$sbsmonitoring
> > failes to start and then the sqlserveragent. both events are record with the
> > event id 103:
> > sqlagent$sbsmonitoring:
> > SQLServerAgent could not be started (reason: Unable to connect to server
> > "(sbs\sbsmonitoring)"; SQLServerAgent
> > cannot start).
> > sqlserveragent:
> > SQLServerAgent could not be started (reason: Unable to connect to server
> > "(local)"; SQLServerAgent
> > cannot start).
> >
> > after searching the web i found an articel describing to look for the
> > sqlagent.out file. i found two files in "microsoft sql server\mssql\log" and
> > "microsoft sql server\mssql$sbsmonitoring". both have the error "Cannot
> > Generate SSPI Context".
> >
> > when i start the services manually it works fine, but NOT on startup... i
> > even searched the kb from ms, but didn´t find anything that helped me.
> >
> > even if i set the services to start over if an error occure, it doesn´t
> > work. only if i start the services manually... :(
> > the services are set to start with the local system account.
> >
> > i don´t have any knowledge from a sql server. can somebody please help me!
> >
> > --
> > kind regards / liebe grüsse
> > dominique|||Hi
Is this only happening occuring when you reboot the server, or when you
stop/start SQL Server once the server is running?
John
"dominique" wrote:
> hi john,
> first of all, thank you for your answer.
> i´m using the system account all the time.
> i just tried your suggestion using a domain account for starting the two
> services and rebooted the server. now the events 103 are gone, but i´m
> getting two events 7000 service control manager:
> (translation from german)
> the "SQLAgent$SBSMONITORING" / "SQLSERVERAGENT" service failed to start due
> to the following error:
> the accountname is incorrect or not existent, or the password for the
> accountname is incorrect.
> the account is a domain-admin account.
> when i tried to start the service manually it was successfull again... ://
> i don´t understand it... :(
> any ideas?
> --
> kind regards / liebe grüsse
> dominique
>
> "John Bell" wrote:
> > Hi
> >
> > This sounds like it can not authenticate the service account in the AD, have
> > you tried setting it to the system account or to a different domain one?
> >
> > John
> >
> > "dominique" wrote:
> >
> > > hi @.all,
> > >
> > > when rebooting the sbs 2k3 server, first the service sqlagent$sbsmonitoring
> > > failes to start and then the sqlserveragent. both events are record with the
> > > event id 103:
> > > sqlagent$sbsmonitoring:
> > > SQLServerAgent could not be started (reason: Unable to connect to server
> > > "(sbs\sbsmonitoring)"; SQLServerAgent
> > > cannot start).
> > > sqlserveragent:
> > > SQLServerAgent could not be started (reason: Unable to connect to server
> > > "(local)"; SQLServerAgent
> > > cannot start).
> > >
> > > after searching the web i found an articel describing to look for the
> > > sqlagent.out file. i found two files in "microsoft sql server\mssql\log" and
> > > "microsoft sql server\mssql$sbsmonitoring". both have the error "Cannot
> > > Generate SSPI Context".
> > >
> > > when i start the services manually it works fine, but NOT on startup... i
> > > even searched the kb from ms, but didn´t find anything that helped me.
> > >
> > > even if i set the services to start over if an error occure, it doesn´t
> > > work. only if i start the services manually... :(
> > > the services are set to start with the local system account.
> > >
> > > i don´t have any knowledge from a sql server. can somebody please help me!
> > >
> > > --
> > > kind regards / liebe grüsse
> > > dominique|||hi,
no only on reboot, that´s why it´s so strange...
i just tested it again. when i stop the sql server the sqlserveragent is
stopping too. when i start the sql server i´m able to start the
sqlserveragent (right now with the domain account). but i´m able to start the
sqlserveragent with the system account too.
only on reboot / startup the services are not starting with the below events.
i´m desperate :(
--
kind regards / liebe grüsse
dominique
"John Bell" wrote:
> Hi
> Is this only happening occuring when you reboot the server, or when you
> stop/start SQL Server once the server is running?
> John
> "dominique" wrote:
> > hi john,
> >
> > first of all, thank you for your answer.
> > i´m using the system account all the time.
> > i just tried your suggestion using a domain account for starting the two
> > services and rebooted the server. now the events 103 are gone, but i´m
> > getting two events 7000 service control manager:
> > (translation from german)
> > the "SQLAgent$SBSMONITORING" / "SQLSERVERAGENT" service failed to start due
> > to the following error:
> > the accountname is incorrect or not existent, or the password for the
> > accountname is incorrect.
> >
> > the account is a domain-admin account.
> >
> > when i tried to start the service manually it was successfull again... ://
> >
> > i don´t understand it... :(
> >
> > any ideas?
> >
> > --
> > kind regards / liebe grüsse
> > dominique
> >
> >
> > "John Bell" wrote:
> >
> > > Hi
> > >
> > > This sounds like it can not authenticate the service account in the AD, have
> > > you tried setting it to the system account or to a different domain one?
> > >
> > > John
> > >
> > > "dominique" wrote:
> > >
> > > > hi @.all,
> > > >
> > > > when rebooting the sbs 2k3 server, first the service sqlagent$sbsmonitoring
> > > > failes to start and then the sqlserveragent. both events are record with the
> > > > event id 103:
> > > > sqlagent$sbsmonitoring:
> > > > SQLServerAgent could not be started (reason: Unable to connect to server
> > > > "(sbs\sbsmonitoring)"; SQLServerAgent
> > > > cannot start).
> > > > sqlserveragent:
> > > > SQLServerAgent could not be started (reason: Unable to connect to server
> > > > "(local)"; SQLServerAgent
> > > > cannot start).
> > > >
> > > > after searching the web i found an articel describing to look for the
> > > > sqlagent.out file. i found two files in "microsoft sql server\mssql\log" and
> > > > "microsoft sql server\mssql$sbsmonitoring". both have the error "Cannot
> > > > Generate SSPI Context".
> > > >
> > > > when i start the services manually it works fine, but NOT on startup... i
> > > > even searched the kb from ms, but didn´t find anything that helped me.
> > > >
> > > > even if i set the services to start over if an error occure, it doesn´t
> > > > work. only if i start the services manually... :(
> > > > the services are set to start with the local system account.
> > > >
> > > > i don´t have any knowledge from a sql server. can somebody please help me!
> > > >
> > > > --
> > > > kind regards / liebe grüsse
> > > > dominique|||Hi dominique
If this is only on re-boot then it sounds like SQL Server service is
starting too early. You may want to check to see if the network services are
taking too long to start or possibly there may be a problem with the network
card. If you can make SQLServer dependent another service (say computer
browser) then it may delay things for long enough. If you have a software
firewall running, check to see how long this takes to start up.
John
"dominique" wrote:
> hi,
> no only on reboot, that´s why it´s so strange...
> i just tested it again. when i stop the sql server the sqlserveragent is
> stopping too. when i start the sql server i´m able to start the
> sqlserveragent (right now with the domain account). but i´m able to start the
> sqlserveragent with the system account too.
> only on reboot / startup the services are not starting with the below events.
> i´m desperate :(
> --
> kind regards / liebe grüsse
> dominique
>
> "John Bell" wrote:
> > Hi
> >
> > Is this only happening occuring when you reboot the server, or when you
> > stop/start SQL Server once the server is running?
> >
> > John
> >
> > "dominique" wrote:
> >
> > > hi john,
> > >
> > > first of all, thank you for your answer.
> > > i´m using the system account all the time.
> > > i just tried your suggestion using a domain account for starting the two
> > > services and rebooted the server. now the events 103 are gone, but i´m
> > > getting two events 7000 service control manager:
> > > (translation from german)
> > > the "SQLAgent$SBSMONITORING" / "SQLSERVERAGENT" service failed to start due
> > > to the following error:
> > > the accountname is incorrect or not existent, or the password for the
> > > accountname is incorrect.
> > >
> > > the account is a domain-admin account.
> > >
> > > when i tried to start the service manually it was successfull again... ://
> > >
> > > i don´t understand it... :(
> > >
> > > any ideas?
> > >
> > > --
> > > kind regards / liebe grüsse
> > > dominique
> > >
> > >
> > > "John Bell" wrote:
> > >
> > > > Hi
> > > >
> > > > This sounds like it can not authenticate the service account in the AD, have
> > > > you tried setting it to the system account or to a different domain one?
> > > >
> > > > John
> > > >
> > > > "dominique" wrote:
> > > >
> > > > > hi @.all,
> > > > >
> > > > > when rebooting the sbs 2k3 server, first the service sqlagent$sbsmonitoring
> > > > > failes to start and then the sqlserveragent. both events are record with the
> > > > > event id 103:
> > > > > sqlagent$sbsmonitoring:
> > > > > SQLServerAgent could not be started (reason: Unable to connect to server
> > > > > "(sbs\sbsmonitoring)"; SQLServerAgent
> > > > > cannot start).
> > > > > sqlserveragent:
> > > > > SQLServerAgent could not be started (reason: Unable to connect to server
> > > > > "(local)"; SQLServerAgent
> > > > > cannot start).
> > > > >
> > > > > after searching the web i found an articel describing to look for the
> > > > > sqlagent.out file. i found two files in "microsoft sql server\mssql\log" and
> > > > > "microsoft sql server\mssql$sbsmonitoring". both have the error "Cannot
> > > > > Generate SSPI Context".
> > > > >
> > > > > when i start the services manually it works fine, but NOT on startup... i
> > > > > even searched the kb from ms, but didn´t find anything that helped me.
> > > > >
> > > > > even if i set the services to start over if an error occure, it doesn´t
> > > > > work. only if i start the services manually... :(
> > > > > the services are set to start with the local system account.
> > > > >
> > > > > i don´t have any knowledge from a sql server. can somebody please help me!
> > > > >
> > > > > --
> > > > > kind regards / liebe grüsse
> > > > > dominique|||hi john,
thanks for trying to resolve my problem, i really apreciate this :))
hm... is the sql server service starting too early or too late? remember the
event:
could not be started (reason: Unable to connect to server "(local)";
SQLServerAgent
how can i check to see if the network services are taking too long to start?
the network card is working fine, no problems or events here.
the server needs a pretty long time to boot, but it is a sbs, so he´s got a
lot of work to do, when booting :/ i thought this is "normal".
how can i make the SQLServer dependent on another service?
i don´t have any software firewall running... isa is running only as a proxy.
--
kind regards / liebe grüsse
dominique
"John Bell" wrote:
> Hi dominique
> If this is only on re-boot then it sounds like SQL Server service is
> starting too early. You may want to check to see if the network services are
> taking too long to start or possibly there may be a problem with the network
> card. If you can make SQLServer dependent another service (say computer
> browser) then it may delay things for long enough. If you have a software
> firewall running, check to see how long this takes to start up.
> John
> "dominique" wrote:
> > hi,
> >
> > no only on reboot, that´s why it´s so strange...
> >
> > i just tested it again. when i stop the sql server the sqlserveragent is
> > stopping too. when i start the sql server i´m able to start the
> > sqlserveragent (right now with the domain account). but i´m able to start the
> > sqlserveragent with the system account too.
> >
> > only on reboot / startup the services are not starting with the below events.
> >
> > i´m desperate :(
> >
> > --
> > kind regards / liebe grüsse
> > dominique
> >
> >
> > "John Bell" wrote:
> >
> > > Hi
> > >
> > > Is this only happening occuring when you reboot the server, or when you
> > > stop/start SQL Server once the server is running?
> > >
> > > John
> > >
> > > "dominique" wrote:
> > >
> > > > hi john,
> > > >
> > > > first of all, thank you for your answer.
> > > > i´m using the system account all the time.
> > > > i just tried your suggestion using a domain account for starting the two
> > > > services and rebooted the server. now the events 103 are gone, but i´m
> > > > getting two events 7000 service control manager:
> > > > (translation from german)
> > > > the "SQLAgent$SBSMONITORING" / "SQLSERVERAGENT" service failed to start due
> > > > to the following error:
> > > > the accountname is incorrect or not existent, or the password for the
> > > > accountname is incorrect.
> > > >
> > > > the account is a domain-admin account.
> > > >
> > > > when i tried to start the service manually it was successfull again... ://
> > > >
> > > > i don´t understand it... :(
> > > >
> > > > any ideas?
> > > >
> > > > --
> > > > kind regards / liebe grüsse
> > > > dominique
> > > >
> > > >
> > > > "John Bell" wrote:
> > > >
> > > > > Hi
> > > > >
> > > > > This sounds like it can not authenticate the service account in the AD, have
> > > > > you tried setting it to the system account or to a different domain one?
> > > > >
> > > > > John
> > > > >
> > > > > "dominique" wrote:
> > > > >
> > > > > > hi @.all,
> > > > > >
> > > > > > when rebooting the sbs 2k3 server, first the service sqlagent$sbsmonitoring
> > > > > > failes to start and then the sqlserveragent. both events are record with the
> > > > > > event id 103:
> > > > > > sqlagent$sbsmonitoring:
> > > > > > SQLServerAgent could not be started (reason: Unable to connect to server
> > > > > > "(sbs\sbsmonitoring)"; SQLServerAgent
> > > > > > cannot start).
> > > > > > sqlserveragent:
> > > > > > SQLServerAgent could not be started (reason: Unable to connect to server
> > > > > > "(local)"; SQLServerAgent
> > > > > > cannot start).
> > > > > >
> > > > > > after searching the web i found an articel describing to look for the
> > > > > > sqlagent.out file. i found two files in "microsoft sql server\mssql\log" and
> > > > > > "microsoft sql server\mssql$sbsmonitoring". both have the error "Cannot
> > > > > > Generate SSPI Context".
> > > > > >
> > > > > > when i start the services manually it works fine, but NOT on startup... i
> > > > > > even searched the kb from ms, but didn´t find anything that helped me.
> > > > > >
> > > > > > even if i set the services to start over if an error occure, it doesn´t
> > > > > > work. only if i start the services manually... :(
> > > > > > the services are set to start with the local system account.
> > > > > >
> > > > > > i don´t have any knowledge from a sql server. can somebody please help me!
> > > > > >
> > > > > > --
> > > > > > kind regards / liebe grüsse
> > > > > > dominique|||Hi
Make sure that the SQLServerAgent service is dependent on the SQL
Server service in the Services Applet.
Also you may want to check out http://support.microsoft.com/kb/811889/
"Cannot Generate SSPI Context" is an issue authenticating the service
account with AD not SQL Server, but as this seems to work once you are
allowed to log in, it would indicate that either something has started
at the time the service wishes to authenticate or something is stopping
the authentication happening, which is resolved by the time you can log
in.
John
dominique wrote:
> hi john,
> thanks for trying to resolve my problem, i really apreciate this :))
> hm... is the sql server service starting too early or too late? remember =the
> event:
> could not be started (reason: Unable to connect to server "(local)";
> SQLServerAgent
> how can i check to see if the network services are taking too long to sta=rt?
> the network card is working fine, no problems or events here.
> the server needs a pretty long time to boot, but it is a sbs, so he=B4s g=ot a
> lot of work to do, when booting :/ i thought this is "normal".
> how can i make the SQLServer dependent on another service?
> i don=B4t have any software firewall running... isa is running only as a =proxy.
> --
> kind regards / liebe gr=FCsse
> dominique
>
> "John Bell" wrote:
> > Hi dominique
> >
> > If this is only on re-boot then it sounds like SQL Server service is
> > starting too early. You may want to check to see if the network service=s are
> > taking too long to start or possibly there may be a problem with the ne=twork
> > card. If you can make SQLServer dependent another service (say computer
> > browser) then it may delay things for long enough. If you have a softwa=re
> > firewall running, check to see how long this takes to start up.
> >
> > John
> >
> > "dominique" wrote:
> >
> > > hi,
> > >
> > > no only on reboot, that=B4s why it=B4s so strange...
> > >
> > > i just tested it again. when i stop the sql server the sqlserveragent= is
> > > stopping too. when i start the sql server i=B4m able to start the
> > > sqlserveragent (right now with the domain account). but i=B4m able to= start the
> > > sqlserveragent with the system account too.
> > >
> > > only on reboot / startup the services are not starting with the below= events.
> > >
> > > i=B4m desperate :(
> > >
> > > --
> > > kind regards / liebe gr=FCsse
> > > dominique
> > >
> > >
> > > "John Bell" wrote:
> > >
> > > > Hi
> > > >
> > > > Is this only happening occuring when you reboot the server, or when= you
> > > > stop/start SQL Server once the server is running?
> > > >
> > > > John
> > > >
> > > > "dominique" wrote:
> > > >
> > > > > hi john,
> > > > >
> > > > > first of all, thank you for your answer.
> > > > > i=B4m using the system account all the time.
> > > > > i just tried your suggestion using a domain account for starting =the two
> > > > > services and rebooted the server. now the events 103 are gone, bu=t i=B4m
> > > > > getting two events 7000 service control manager:
> > > > > (translation from german)
> > > > > the "SQLAgent$SBSMONITORING" / "SQLSERVERAGENT" service failed to= start due
> > > > > to the following error:
> > > > > the accountname is incorrect or not existent, or the password for= the
> > > > > accountname is incorrect.
> > > > >
> > > > > the account is a domain-admin account.
> > > > >
> > > > > when i tried to start the service manually it was successfull aga=in... ://
> > > > >
> > > > > i don=B4t understand it... :(
> > > > >
> > > > > any ideas?
> > > > >
> > > > > --
> > > > > kind regards / liebe gr=FCsse
> > > > > dominique
> > > > >
> > > > >
> > > > > "John Bell" wrote:
> > > > >
> > > > > > Hi
> > > > > >
> > > > > > This sounds like it can not authenticate the service account in= the AD, have
> > > > > > you tried setting it to the system account or to a different do=main one?
> > > > > >
> > > > > > John
> > > > > >
> > > > > > "dominique" wrote:
> > > > > >
> > > > > > > hi @.all,
> > > > > > >
> > > > > > > when rebooting the sbs 2k3 server, first the service sqlagent=$sbsmonitoring
> > > > > > > failes to start and then the sqlserveragent. both events are =record with the
> > > > > > > event id 103:
> > > > > > > sqlagent$sbsmonitoring:
> > > > > > > SQLServerAgent could not be started (reason: Unable to connec=t to server
> > > > > > > "(sbs\sbsmonitoring)"; SQLServerAgent
> > > > > > > cannot start).
> > > > > > > sqlserveragent:
> > > > > > > SQLServerAgent could not be started (reason: Unable to connec=t to server
> > > > > > > "(local)"; SQLServerAgent
> > > > > > > cannot start).
> > > > > > >
> > > > > > > after searching the web i found an articel describing to look= for the
> > > > > > > sqlagent.out file. i found two files in "microsoft sql server=\mssql\log" and
> > > > > > > "microsoft sql server\mssql$sbsmonitoring". both have the err=or "Cannot
> > > > > > > Generate SSPI Context".
> > > > > > >
> > > > > > > when i start the services manually it works fine, but NOT on =startup... i
> > > > > > > even searched the kb from ms, but didn=B4t find anything that= helped me.
> > > > > > >
> > > > > > > even if i set the services to start over if an error occure, =it doesn=B4t
> > > > > > > work. only if i start the services manually... :(
> > > > > > > the services are set to start with the local system account.
> > > > > > >
> > > > > > > i don=B4t have any knowledge from a sql server. can somebody =please help me!
> > > > > > >
> > > > > > > --
> > > > > > > kind regards / liebe gr=FCsse
> > > > > > > dominique|||hi john,
i tried the following now:
after reading the kb i changed the authentification for the sqlserveragent
(local) to sql authentification and that worked! :)
now the sqlserveragent (local) is starting, but i´m still getting the event
103 on sqlagent$sbsmonitoring. i changed the authentification for the
sqlserveragent too, but that didn´t worked. i´m only able to start the
sqlserveragent when windows authentification is enabled... :( :( :(
any other suggestions? ://
--
kind regards / liebe grüsse
dominique
"John Bell" wrote:
> Hi
> Make sure that the SQLServerAgent service is dependent on the SQL
> Server service in the Services Applet.
> Also you may want to check out http://support.microsoft.com/kb/811889/
> "Cannot Generate SSPI Context" is an issue authenticating the service
> account with AD not SQL Server, but as this seems to work once you are
> allowed to log in, it would indicate that either something has started
> at the time the service wishes to authenticate or something is stopping
> the authentication happening, which is resolved by the time you can log
> in.
> John
> dominique wrote:
> > hi john,
> >
> > thanks for trying to resolve my problem, i really apreciate this :))
> >
> > hm... is the sql server service starting too early or too late? remember the
> > event:
> > could not be started (reason: Unable to connect to server "(local)";
> > SQLServerAgent
> >
> > how can i check to see if the network services are taking too long to start?
> > the network card is working fine, no problems or events here.
> >
> > the server needs a pretty long time to boot, but it is a sbs, so he´s got a
> > lot of work to do, when booting :/ i thought this is "normal".
> >
> > how can i make the SQLServer dependent on another service?
> >
> > i don´t have any software firewall running... isa is running only as a proxy.
> >
> > --
> > kind regards / liebe grüsse
> > dominique
> >
> >
> > "John Bell" wrote:
> >
> > > Hi dominique
> > >
> > > If this is only on re-boot then it sounds like SQL Server service is
> > > starting too early. You may want to check to see if the network services are
> > > taking too long to start or possibly there may be a problem with the network
> > > card. If you can make SQLServer dependent another service (say computer
> > > browser) then it may delay things for long enough. If you have a software
> > > firewall running, check to see how long this takes to start up.
> > >
> > > John
> > >
> > > "dominique" wrote:
> > >
> > > > hi,
> > > >
> > > > no only on reboot, that´s why it´s so strange...
> > > >
> > > > i just tested it again. when i stop the sql server the sqlserveragent is
> > > > stopping too. when i start the sql server i´m able to start the
> > > > sqlserveragent (right now with the domain account). but i´m able to start the
> > > > sqlserveragent with the system account too.
> > > >
> > > > only on reboot / startup the services are not starting with the below events.
> > > >
> > > > i´m desperate :(
> > > >
> > > > --
> > > > kind regards / liebe grüsse
> > > > dominique
> > > >
> > > >
> > > > "John Bell" wrote:
> > > >
> > > > > Hi
> > > > >
> > > > > Is this only happening occuring when you reboot the server, or when you
> > > > > stop/start SQL Server once the server is running?
> > > > >
> > > > > John
> > > > >
> > > > > "dominique" wrote:
> > > > >
> > > > > > hi john,
> > > > > >
> > > > > > first of all, thank you for your answer.
> > > > > > i´m using the system account all the time.
> > > > > > i just tried your suggestion using a domain account for starting the two
> > > > > > services and rebooted the server. now the events 103 are gone, but i´m
> > > > > > getting two events 7000 service control manager:
> > > > > > (translation from german)
> > > > > > the "SQLAgent$SBSMONITORING" / "SQLSERVERAGENT" service failed to start due
> > > > > > to the following error:
> > > > > > the accountname is incorrect or not existent, or the password for the
> > > > > > accountname is incorrect.
> > > > > >
> > > > > > the account is a domain-admin account.
> > > > > >
> > > > > > when i tried to start the service manually it was successfull again... ://
> > > > > >
> > > > > > i don´t understand it... :(
> > > > > >
> > > > > > any ideas?
> > > > > >
> > > > > > --
> > > > > > kind regards / liebe grüsse
> > > > > > dominique
> > > > > >
> > > > > >
> > > > > > "John Bell" wrote:
> > > > > >
> > > > > > > Hi
> > > > > > >
> > > > > > > This sounds like it can not authenticate the service account in the AD, have
> > > > > > > you tried setting it to the system account or to a different domain one?
> > > > > > >
> > > > > > > John
> > > > > > >
> > > > > > > "dominique" wrote:
> > > > > > >
> > > > > > > > hi @.all,
> > > > > > > >
> > > > > > > > when rebooting the sbs 2k3 server, first the service sqlagent$sbsmonitoring
> > > > > > > > failes to start and then the sqlserveragent. both events are record with the
> > > > > > > > event id 103:
> > > > > > > > sqlagent$sbsmonitoring:
> > > > > > > > SQLServerAgent could not be started (reason: Unable to connect to server
> > > > > > > > "(sbs\sbsmonitoring)"; SQLServerAgent
> > > > > > > > cannot start).
> > > > > > > > sqlserveragent:
> > > > > > > > SQLServerAgent could not be started (reason: Unable to connect to server
> > > > > > > > "(local)"; SQLServerAgent
> > > > > > > > cannot start).
> > > > > > > >
> > > > > > > > after searching the web i found an articel describing to look for the
> > > > > > > > sqlagent.out file. i found two files in "microsoft sql server\mssql\log" and
> > > > > > > > "microsoft sql server\mssql$sbsmonitoring". both have the error "Cannot
> > > > > > > > Generate SSPI Context".
> > > > > > > >
> > > > > > > > when i start the services manually it works fine, but NOT on startup... i
> > > > > > > > even searched the kb from ms, but didn´t find anything that helped me.
> > > > > > > >
> > > > > > > > even if i set the services to start over if an error occure, it doesn´t
> > > > > > > > work. only if i start the services manually... :(
> > > > > > > > the services are set to start with the local system account.
> > > > > > > >
> > > > > > > > i don´t have any knowledge from a sql server. can somebody please help me!
> > > > > > > >
> > > > > > > > --
> > > > > > > > kind regards / liebe grüsse
> > > > > > > > dominique
>|||Hi
Are you running two copies of SQL Server on this server? If this instance is
the default then it would be the same as (local).
John
"dominique" <dominique@.discussions.microsoft.com> wrote in message
news:E0C60EA7-62C6-4146-90A8-21E76083B9AD@.microsoft.com...
> hi john,
> i tried the following now:
> after reading the kb i changed the authentification for the sqlserveragent
> (local) to sql authentification and that worked! :)
> now the sqlserveragent (local) is starting, but i´m still getting the
> event
> 103 on sqlagent$sbsmonitoring. i changed the authentification for the
> sqlserveragent too, but that didn´t worked. i´m only able to start the
> sqlserveragent when windows authentification is enabled... :( :( :(
> any other suggestions? ://
> --
> kind regards / liebe grüsse
> dominique
>
> "John Bell" wrote:
>> Hi
>> Make sure that the SQLServerAgent service is dependent on the SQL
>> Server service in the Services Applet.
>> Also you may want to check out http://support.microsoft.com/kb/811889/
>> "Cannot Generate SSPI Context" is an issue authenticating the service
>> account with AD not SQL Server, but as this seems to work once you are
>> allowed to log in, it would indicate that either something has started
>> at the time the service wishes to authenticate or something is stopping
>> the authentication happening, which is resolved by the time you can log
>> in.
>> John
>> dominique wrote:
>> > hi john,
>> >
>> > thanks for trying to resolve my problem, i really apreciate this :))
>> >
>> > hm... is the sql server service starting too early or too late?
>> > remember the
>> > event:
>> > could not be started (reason: Unable to connect to server "(local)";
>> > SQLServerAgent
>> >
>> > how can i check to see if the network services are taking too long to
>> > start?
>> > the network card is working fine, no problems or events here.
>> >
>> > the server needs a pretty long time to boot, but it is a sbs, so he´s
>> > got a
>> > lot of work to do, when booting :/ i thought this is "normal".
>> >
>> > how can i make the SQLServer dependent on another service?
>> >
>> > i don´t have any software firewall running... isa is running only as a
>> > proxy.
>> >
>> > --
>> > kind regards / liebe grüsse
>> > dominique
>> >
>> >
>> > "John Bell" wrote:
>> >
>> > > Hi dominique
>> > >
>> > > If this is only on re-boot then it sounds like SQL Server service is
>> > > starting too early. You may want to check to see if the network
>> > > services are
>> > > taking too long to start or possibly there may be a problem with the
>> > > network
>> > > card. If you can make SQLServer dependent another service (say
>> > > computer
>> > > browser) then it may delay things for long enough. If you have a
>> > > software
>> > > firewall running, check to see how long this takes to start up.
>> > >
>> > > John
>> > >
>> > > "dominique" wrote:
>> > >
>> > > > hi,
>> > > >
>> > > > no only on reboot, that´s why it´s so strange...
>> > > >
>> > > > i just tested it again. when i stop the sql server the
>> > > > sqlserveragent is
>> > > > stopping too. when i start the sql server i´m able to start the
>> > > > sqlserveragent (right now with the domain account). but i´m able to
>> > > > start the
>> > > > sqlserveragent with the system account too.
>> > > >
>> > > > only on reboot / startup the services are not starting with the
>> > > > below events.
>> > > >
>> > > > i´m desperate :(
>> > > >
>> > > > --
>> > > > kind regards / liebe grüsse
>> > > > dominique
>> > > >
>> > > >
>> > > > "John Bell" wrote:
>> > > >
>> > > > > Hi
>> > > > >
>> > > > > Is this only happening occuring when you reboot the server, or
>> > > > > when you
>> > > > > stop/start SQL Server once the server is running?
>> > > > >
>> > > > > John
>> > > > >
>> > > > > "dominique" wrote:
>> > > > >
>> > > > > > hi john,
>> > > > > >
>> > > > > > first of all, thank you for your answer.
>> > > > > > i´m using the system account all the time.
>> > > > > > i just tried your suggestion using a domain account for
>> > > > > > starting the two
>> > > > > > services and rebooted the server. now the events 103 are gone,
>> > > > > > but i´m
>> > > > > > getting two events 7000 service control manager:
>> > > > > > (translation from german)
>> > > > > > the "SQLAgent$SBSMONITORING" / "SQLSERVERAGENT" service failed
>> > > > > > to start due
>> > > > > > to the following error:
>> > > > > > the accountname is incorrect or not existent, or the password
>> > > > > > for the
>> > > > > > accountname is incorrect.
>> > > > > >
>> > > > > > the account is a domain-admin account.
>> > > > > >
>> > > > > > when i tried to start the service manually it was successfull
>> > > > > > again... ://
>> > > > > >
>> > > > > > i don´t understand it... :(
>> > > > > >
>> > > > > > any ideas?
>> > > > > >
>> > > > > > --
>> > > > > > kind regards / liebe grüsse
>> > > > > > dominique
>> > > > > >
>> > > > > >
>> > > > > > "John Bell" wrote:
>> > > > > >
>> > > > > > > Hi
>> > > > > > >
>> > > > > > > This sounds like it can not authenticate the service account
>> > > > > > > in the AD, have
>> > > > > > > you tried setting it to the system account or to a different
>> > > > > > > domain one?
>> > > > > > >
>> > > > > > > John
>> > > > > > >
>> > > > > > > "dominique" wrote:
>> > > > > > >
>> > > > > > > > hi @.all,
>> > > > > > > >
>> > > > > > > > when rebooting the sbs 2k3 server, first the service
>> > > > > > > > sqlagent$sbsmonitoring
>> > > > > > > > failes to start and then the sqlserveragent. both events
>> > > > > > > > are record with the
>> > > > > > > > event id 103:
>> > > > > > > > sqlagent$sbsmonitoring:
>> > > > > > > > SQLServerAgent could not be started (reason: Unable to
>> > > > > > > > connect to server
>> > > > > > > > "(sbs\sbsmonitoring)"; SQLServerAgent
>> > > > > > > > cannot start).
>> > > > > > > > sqlserveragent:
>> > > > > > > > SQLServerAgent could not be started (reason: Unable to
>> > > > > > > > connect to server
>> > > > > > > > "(local)"; SQLServerAgent
>> > > > > > > > cannot start).
>> > > > > > > >
>> > > > > > > > after searching the web i found an articel describing to
>> > > > > > > > look for the
>> > > > > > > > sqlagent.out file. i found two files in "microsoft sql
>> > > > > > > > server\mssql\log" and
>> > > > > > > > "microsoft sql server\mssql$sbsmonitoring". both have the
>> > > > > > > > error "Cannot
>> > > > > > > > Generate SSPI Context".
>> > > > > > > >
>> > > > > > > > when i start the services manually it works fine, but NOT
>> > > > > > > > on startup... i
>> > > > > > > > even searched the kb from ms, but didn´t find anything that
>> > > > > > > > helped me.
>> > > > > > > >
>> > > > > > > > even if i set the services to start over if an error
>> > > > > > > > occure, it doesn´t
>> > > > > > > > work. only if i start the services manually... :(
>> > > > > > > > the services are set to start with the local system
>> > > > > > > > account.
>> > > > > > > >
>> > > > > > > > i don´t have any knowledge from a sql server. can somebody
>> > > > > > > > please help me!
>> > > > > > > >
>> > > > > > > > --
>> > > > > > > > kind regards / liebe grüsse
>> > > > > > > > dominique
>>|||hi john,
no, not that i know. i´m running only one sql server.
i´m sorry, but i don´t understand your question. what instance do you mean?
the sbsmonitoring?
--
kind regards / liebe grüsse
dominique
"John Bell" wrote:
> Hi
> Are you running two copies of SQL Server on this server? If this instance is
> the default then it would be the same as (local).
> John
> "dominique" <dominique@.discussions.microsoft.com> wrote in message
> news:E0C60EA7-62C6-4146-90A8-21E76083B9AD@.microsoft.com...
> > hi john,
> >
> > i tried the following now:
> >
> > after reading the kb i changed the authentification for the sqlserveragent
> > (local) to sql authentification and that worked! :)
> > now the sqlserveragent (local) is starting, but i´m still getting the
> > event
> > 103 on sqlagent$sbsmonitoring. i changed the authentification for the
> > sqlserveragent too, but that didn´t worked. i´m only able to start the
> > sqlserveragent when windows authentification is enabled... :( :( :(
> >
> > any other suggestions? ://
> >
> > --
> > kind regards / liebe grüsse
> > dominique
> >
> >
> > "John Bell" wrote:
> >
> >> Hi
> >>
> >> Make sure that the SQLServerAgent service is dependent on the SQL
> >> Server service in the Services Applet.
> >>
> >> Also you may want to check out http://support.microsoft.com/kb/811889/
> >>
> >> "Cannot Generate SSPI Context" is an issue authenticating the service
> >> account with AD not SQL Server, but as this seems to work once you are
> >> allowed to log in, it would indicate that either something has started
> >> at the time the service wishes to authenticate or something is stopping
> >> the authentication happening, which is resolved by the time you can log
> >> in.
> >>
> >> John
> >>
> >> dominique wrote:
> >> > hi john,
> >> >
> >> > thanks for trying to resolve my problem, i really apreciate this :))
> >> >
> >> > hm... is the sql server service starting too early or too late?
> >> > remember the
> >> > event:
> >> > could not be started (reason: Unable to connect to server "(local)";
> >> > SQLServerAgent
> >> >
> >> > how can i check to see if the network services are taking too long to
> >> > start?
> >> > the network card is working fine, no problems or events here.
> >> >
> >> > the server needs a pretty long time to boot, but it is a sbs, so he´s
> >> > got a
> >> > lot of work to do, when booting :/ i thought this is "normal".
> >> >
> >> > how can i make the SQLServer dependent on another service?
> >> >
> >> > i don´t have any software firewall running... isa is running only as a
> >> > proxy.
> >> >
> >> > --
> >> > kind regards / liebe grüsse
> >> > dominique
> >> >
> >> >
> >> > "John Bell" wrote:
> >> >
> >> > > Hi dominique
> >> > >
> >> > > If this is only on re-boot then it sounds like SQL Server service is
> >> > > starting too early. You may want to check to see if the network
> >> > > services are
> >> > > taking too long to start or possibly there may be a problem with the
> >> > > network
> >> > > card. If you can make SQLServer dependent another service (say
> >> > > computer
> >> > > browser) then it may delay things for long enough. If you have a
> >> > > software
> >> > > firewall running, check to see how long this takes to start up.
> >> > >
> >> > > John
> >> > >
> >> > > "dominique" wrote:
> >> > >
> >> > > > hi,
> >> > > >
> >> > > > no only on reboot, that´s why it´s so strange...
> >> > > >
> >> > > > i just tested it again. when i stop the sql server the
> >> > > > sqlserveragent is
> >> > > > stopping too. when i start the sql server i´m able to start the
> >> > > > sqlserveragent (right now with the domain account). but i´m able to
> >> > > > start the
> >> > > > sqlserveragent with the system account too.
> >> > > >
> >> > > > only on reboot / startup the services are not starting with the
> >> > > > below events.
> >> > > >
> >> > > > i´m desperate :(
> >> > > >
> >> > > > --
> >> > > > kind regards / liebe grüsse
> >> > > > dominique
> >> > > >
> >> > > >
> >> > > > "John Bell" wrote:
> >> > > >
> >> > > > > Hi
> >> > > > >
> >> > > > > Is this only happening occuring when you reboot the server, or
> >> > > > > when you
> >> > > > > stop/start SQL Server once the server is running?
> >> > > > >
> >> > > > > John
> >> > > > >
> >> > > > > "dominique" wrote:
> >> > > > >
> >> > > > > > hi john,
> >> > > > > >
> >> > > > > > first of all, thank you for your answer.
> >> > > > > > i´m using the system account all the time.
> >> > > > > > i just tried your suggestion using a domain account for
> >> > > > > > starting the two
> >> > > > > > services and rebooted the server. now the events 103 are gone,
> >> > > > > > but i´m
> >> > > > > > getting two events 7000 service control manager:
> >> > > > > > (translation from german)
> >> > > > > > the "SQLAgent$SBSMONITORING" / "SQLSERVERAGENT" service failed
> >> > > > > > to start due
> >> > > > > > to the following error:
> >> > > > > > the accountname is incorrect or not existent, or the password
> >> > > > > > for the
> >> > > > > > accountname is incorrect.
> >> > > > > >
> >> > > > > > the account is a domain-admin account.
> >> > > > > >
> >> > > > > > when i tried to start the service manually it was successfull
> >> > > > > > again... ://
> >> > > > > >
> >> > > > > > i don´t understand it... :(
> >> > > > > >
> >> > > > > > any ideas?
> >> > > > > >
> >> > > > > > --
> >> > > > > > kind regards / liebe grüsse
> >> > > > > > dominique
> >> > > > > >
> >> > > > > >
> >> > > > > > "John Bell" wrote:
> >> > > > > >
> >> > > > > > > Hi
> >> > > > > > >
> >> > > > > > > This sounds like it can not authenticate the service account
> >> > > > > > > in the AD, have
> >> > > > > > > you tried setting it to the system account or to a different
> >> > > > > > > domain one?
> >> > > > > > >
> >> > > > > > > John
> >> > > > > > >
> >> > > > > > > "dominique" wrote:
> >> > > > > > >
> >> > > > > > > > hi @.all,
> >> > > > > > > >
> >> > > > > > > > when rebooting the sbs 2k3 server, first the service
> >> > > > > > > > sqlagent$sbsmonitoring
> >> > > > > > > > failes to start and then the sqlserveragent. both events
> >> > > > > > > > are record with the
> >> > > > > > > > event id 103:
> >> > > > > > > > sqlagent$sbsmonitoring:
> >> > > > > > > > SQLServerAgent could not be started (reason: Unable to
> >> > > > > > > > connect to server
> >> > > > > > > > "(sbs\sbsmonitoring)"; SQLServerAgent
> >> > > > > > > > cannot start).
> >> > > > > > > > sqlserveragent:
> >> > > > > > > > SQLServerAgent could not be started (reason: Unable to
> >> > > > > > > > connect to server
> >> > > > > > > > "(local)"; SQLServerAgent
> >> > > > > > > > cannot start).
> >> > > > > > > >
> >> > > > > > > > after searching the web i found an articel describing to
> >> > > > > > > > look for the
> >> > > > > > > > sqlagent.out file. i found two files in "microsoft sql
> >> > > > > > > > server\mssql\log" and
> >> > > > > > > > "microsoft sql server\mssql$sbsmonitoring". both have the
> >> > > > > > > > error "Cannot
> >> > > > > > > > Generate SSPI Context".
> >> > > > > > > >
> >> > > > > > > > when i start the services manually it works fine, but NOT
> >> > > > > > > > on startup... i
> >> > > > > > > > even searched the kb from ms, but didn´t find anything that
> >> > > > > > > > helped me.
> >> > > > > > > >
> >> > > > > > > > even if i set the services to start over if an error
> >> > > > > > > > occure, it doesn´t
> >> > > > > > > > work. only if i start the services manually... :(
> >> > > > > > > > the services are set to start with the local system
> >> > > > > > > > account.
> >> > > > > > > >
> >> > > > > > > > i don´t have any knowledge from a sql server. can somebody
> >> > > > > > > > please help me!
> >> > > > > > > >
> >> > > > > > > > --
> >> > > > > > > > kind regards / liebe grüsse
> >> > > > > > > > dominique
> >>
> >>
>
>|||Hi
You can install multiple instances on a single server, if you run the
command NET START from a command prompt you may have multiple instances that
are either like MSSQLSERVER or MSQL$INSTANCE.
John
"dominique" wrote:
> hi john,
> no, not that i know. i´m running only one sql server.
> i´m sorry, but i don´t understand your question. what instance do you mean?
> the sbsmonitoring?
> --
> kind regards / liebe grüsse
> dominique
>
> "John Bell" wrote:
> > Hi
> >
> > Are you running two copies of SQL Server on this server? If this instance is
> > the default then it would be the same as (local).
> >
> > John
> >
> > "dominique" <dominique@.discussions.microsoft.com> wrote in message
> > news:E0C60EA7-62C6-4146-90A8-21E76083B9AD@.microsoft.com...
> > > hi john,
> > >
> > > i tried the following now:
> > >
> > > after reading the kb i changed the authentification for the sqlserveragent
> > > (local) to sql authentification and that worked! :)
> > > now the sqlserveragent (local) is starting, but i´m still getting the
> > > event
> > > 103 on sqlagent$sbsmonitoring. i changed the authentification for the
> > > sqlserveragent too, but that didn´t worked. i´m only able to start the
> > > sqlserveragent when windows authentification is enabled... :( :( :(
> > >
> > > any other suggestions? ://
> > >
> > > --
> > > kind regards / liebe grüsse
> > > dominique
> > >
> > >
> > > "John Bell" wrote:
> > >
> > >> Hi
> > >>
> > >> Make sure that the SQLServerAgent service is dependent on the SQL
> > >> Server service in the Services Applet.
> > >>
> > >> Also you may want to check out http://support.microsoft.com/kb/811889/
> > >>
> > >> "Cannot Generate SSPI Context" is an issue authenticating the service
> > >> account with AD not SQL Server, but as this seems to work once you are
> > >> allowed to log in, it would indicate that either something has started
> > >> at the time the service wishes to authenticate or something is stopping
> > >> the authentication happening, which is resolved by the time you can log
> > >> in.
> > >>
> > >> John
> > >>
> > >> dominique wrote:
> > >> > hi john,
> > >> >
> > >> > thanks for trying to resolve my problem, i really apreciate this :))
> > >> >
> > >> > hm... is the sql server service starting too early or too late?
> > >> > remember the
> > >> > event:
> > >> > could not be started (reason: Unable to connect to server "(local)";
> > >> > SQLServerAgent
> > >> >
> > >> > how can i check to see if the network services are taking too long to
> > >> > start?
> > >> > the network card is working fine, no problems or events here.
> > >> >
> > >> > the server needs a pretty long time to boot, but it is a sbs, so he´s
> > >> > got a
> > >> > lot of work to do, when booting :/ i thought this is "normal".
> > >> >
> > >> > how can i make the SQLServer dependent on another service?
> > >> >
> > >> > i don´t have any software firewall running... isa is running only as a
> > >> > proxy.
> > >> >
> > >> > --
> > >> > kind regards / liebe grüsse
> > >> > dominique
> > >> >
> > >> >
> > >> > "John Bell" wrote:
> > >> >
> > >> > > Hi dominique
> > >> > >
> > >> > > If this is only on re-boot then it sounds like SQL Server service is
> > >> > > starting too early. You may want to check to see if the network
> > >> > > services are
> > >> > > taking too long to start or possibly there may be a problem with the
> > >> > > network
> > >> > > card. If you can make SQLServer dependent another service (say
> > >> > > computer
> > >> > > browser) then it may delay things for long enough. If you have a
> > >> > > software
> > >> > > firewall running, check to see how long this takes to start up.
> > >> > >
> > >> > > John
> > >> > >
> > >> > > "dominique" wrote:
> > >> > >
> > >> > > > hi,
> > >> > > >
> > >> > > > no only on reboot, that´s why it´s so strange...
> > >> > > >
> > >> > > > i just tested it again. when i stop the sql server the
> > >> > > > sqlserveragent is
> > >> > > > stopping too. when i start the sql server i´m able to start the
> > >> > > > sqlserveragent (right now with the domain account). but i´m able to
> > >> > > > start the
> > >> > > > sqlserveragent with the system account too.
> > >> > > >
> > >> > > > only on reboot / startup the services are not starting with the
> > >> > > > below events.
> > >> > > >
> > >> > > > i´m desperate :(
> > >> > > >
> > >> > > > --
> > >> > > > kind regards / liebe grüsse
> > >> > > > dominique
> > >> > > >
> > >> > > >
> > >> > > > "John Bell" wrote:
> > >> > > >
> > >> > > > > Hi
> > >> > > > >
> > >> > > > > Is this only happening occuring when you reboot the server, or
> > >> > > > > when you
> > >> > > > > stop/start SQL Server once the server is running?
> > >> > > > >
> > >> > > > > John
> > >> > > > >
> > >> > > > > "dominique" wrote:
> > >> > > > >
> > >> > > > > > hi john,
> > >> > > > > >
> > >> > > > > > first of all, thank you for your answer.
> > >> > > > > > i´m using the system account all the time.
> > >> > > > > > i just tried your suggestion using a domain account for
> > >> > > > > > starting the two
> > >> > > > > > services and rebooted the server. now the events 103 are gone,
> > >> > > > > > but i´m
> > >> > > > > > getting two events 7000 service control manager:
> > >> > > > > > (translation from german)
> > >> > > > > > the "SQLAgent$SBSMONITORING" / "SQLSERVERAGENT" service failed
> > >> > > > > > to start due
> > >> > > > > > to the following error:
> > >> > > > > > the accountname is incorrect or not existent, or the password
> > >> > > > > > for the
> > >> > > > > > accountname is incorrect.
> > >> > > > > >
> > >> > > > > > the account is a domain-admin account.
> > >> > > > > >
> > >> > > > > > when i tried to start the service manually it was successfull
> > >> > > > > > again... ://
> > >> > > > > >
> > >> > > > > > i don´t understand it... :(
> > >> > > > > >
> > >> > > > > > any ideas?
> > >> > > > > >
> > >> > > > > > --
> > >> > > > > > kind regards / liebe grüsse
> > >> > > > > > dominique
> > >> > > > > >
> > >> > > > > >
> > >> > > > > > "John Bell" wrote:
> > >> > > > > >
> > >> > > > > > > Hi
> > >> > > > > > >
> > >> > > > > > > This sounds like it can not authenticate the service account
> > >> > > > > > > in the AD, have
> > >> > > > > > > you tried setting it to the system account or to a different
> > >> > > > > > > domain one?
> > >> > > > > > >
> > >> > > > > > > John
> > >> > > > > > >
> > >> > > > > > > "dominique" wrote:
> > >> > > > > > >
> > >> > > > > > > > hi @.all,
> > >> > > > > > > >
> > >> > > > > > > > when rebooting the sbs 2k3 server, first the service
> > >> > > > > > > > sqlagent$sbsmonitoring
> > >> > > > > > > > failes to start and then the sqlserveragent. both events
> > >> > > > > > > > are record with the
> > >> > > > > > > > event id 103:
> > >> > > > > > > > sqlagent$sbsmonitoring:
> > >> > > > > > > > SQLServerAgent could not be started (reason: Unable to
> > >> > > > > > > > connect to server
> > >> > > > > > > > "(sbs\sbsmonitoring)"; SQLServerAgent
> > >> > > > > > > > cannot start).
> > >> > > > > > > > sqlserveragent:
> > >> > > > > > > > SQLServerAgent could not be started (reason: Unable to
> > >> > > > > > > > connect to server
> > >> > > > > > > > "(local)"; SQLServerAgent
> > >> > > > > > > > cannot start).
> > >> > > > > > > >
> > >> > > > > > > > after searching the web i found an articel describing to
> > >> > > > > > > > look for the
> > >> > > > > > > > sqlagent.out file. i found two files in "microsoft sql
> > >> > > > > > > > server\mssql\log" and
> > >> > > > > > > > "microsoft sql server\mssql$sbsmonitoring". both have the
> > >> > > > > > > > error "Cannot
> > >> > > > > > > > Generate SSPI Context".
> > >> > > > > > > >
> > >> > > > > > > > when i start the services manually it works fine, but NOT
> > >> > > > > > > > on startup... i
> > >> > > > > > > > even searched the kb from ms, but didn´t find anything that
> > >> > > > > > > > helped me.
> > >> > > > > > > >
> > >> > > > > > > > even if i set the services to start over if an error
> > >> > > > > > > > occure, it doesn´t
> > >> > > > > > > > work. only if i start the services manually... :(
> > >> > > > > > > > the services are set to start with the local system
> > >> > > > > > > > account.
> > >> > > > > > > >
> > >> > > > > > > > i don´t have any knowledge from a sql server. can somebody
> > >> > > > > > > > please help me!
> > >> > > > > > > >
> > >> > > > > > > > --
> > >> > > > > > > > kind regards / liebe grüsse
> > >> > > > > > > > dominique
> > >>
> > >>
> >
> >
> >|||hi john,
there are multiple instances running.
backup exec, msfw (isa), sbsmonitoring and sharepoint. but the
sqlserveragent is only needed for sbsmonitoring and local.
Did that answer your question? :/
thanks again for your help :)
--
kind regards / liebe grüsse
dominique
"John Bell" wrote:
> Hi
> You can install multiple instances on a single server, if you run the
> command NET START from a command prompt you may have multiple instances that
> are either like MSSQLSERVER or MSQL$INSTANCE.
> John
> "dominique" wrote:
> > hi john,
> >
> > no, not that i know. i´m running only one sql server.
> >
> > i´m sorry, but i don´t understand your question. what instance do you mean?
> > the sbsmonitoring?
> > --
> > kind regards / liebe grüsse
> > dominique
> >
> >
> > "John Bell" wrote:
> >
> > > Hi
> > >
> > > Are you running two copies of SQL Server on this server? If this instance is
> > > the default then it would be the same as (local).
> > >
> > > John
> > >
> > > "dominique" <dominique@.discussions.microsoft.com> wrote in message
> > > news:E0C60EA7-62C6-4146-90A8-21E76083B9AD@.microsoft.com...
> > > > hi john,
> > > >
> > > > i tried the following now:
> > > >
> > > > after reading the kb i changed the authentification for the sqlserveragent
> > > > (local) to sql authentification and that worked! :)
> > > > now the sqlserveragent (local) is starting, but i´m still getting the
> > > > event
> > > > 103 on sqlagent$sbsmonitoring. i changed the authentification for the
> > > > sqlserveragent too, but that didn´t worked. i´m only able to start the
> > > > sqlserveragent when windows authentification is enabled... :( :( :(
> > > >
> > > > any other suggestions? ://
> > > >
> > > > --
> > > > kind regards / liebe grüsse
> > > > dominique
> > > >
> > > >
> > > > "John Bell" wrote:
> > > >
> > > >> Hi
> > > >>
> > > >> Make sure that the SQLServerAgent service is dependent on the SQL
> > > >> Server service in the Services Applet.
> > > >>
> > > >> Also you may want to check out http://support.microsoft.com/kb/811889/
> > > >>
> > > >> "Cannot Generate SSPI Context" is an issue authenticating the service
> > > >> account with AD not SQL Server, but as this seems to work once you are
> > > >> allowed to log in, it would indicate that either something has started
> > > >> at the time the service wishes to authenticate or something is stopping
> > > >> the authentication happening, which is resolved by the time you can log
> > > >> in.
> > > >>
> > > >> John
> > > >>
> > > >> dominique wrote:
> > > >> > hi john,
> > > >> >
> > > >> > thanks for trying to resolve my problem, i really apreciate this :))
> > > >> >
> > > >> > hm... is the sql server service starting too early or too late?
> > > >> > remember the
> > > >> > event:
> > > >> > could not be started (reason: Unable to connect to server "(local)";
> > > >> > SQLServerAgent
> > > >> >
> > > >> > how can i check to see if the network services are taking too long to
> > > >> > start?
> > > >> > the network card is working fine, no problems or events here.
> > > >> >
> > > >> > the server needs a pretty long time to boot, but it is a sbs, so he´s
> > > >> > got a
> > > >> > lot of work to do, when booting :/ i thought this is "normal".
> > > >> >
> > > >> > how can i make the SQLServer dependent on another service?
> > > >> >
> > > >> > i don´t have any software firewall running... isa is running only as a
> > > >> > proxy.
> > > >> >
> > > >> > --
> > > >> > kind regards / liebe grüsse
> > > >> > dominique
> > > >> >
> > > >> >
> > > >> > "John Bell" wrote:
> > > >> >
> > > >> > > Hi dominique
> > > >> > >
> > > >> > > If this is only on re-boot then it sounds like SQL Server service is
> > > >> > > starting too early. You may want to check to see if the network
> > > >> > > services are
> > > >> > > taking too long to start or possibly there may be a problem with the
> > > >> > > network
> > > >> > > card. If you can make SQLServer dependent another service (say
> > > >> > > computer
> > > >> > > browser) then it may delay things for long enough. If you have a
> > > >> > > software
> > > >> > > firewall running, check to see how long this takes to start up.
> > > >> > >
> > > >> > > John
> > > >> > >
> > > >> > > "dominique" wrote:
> > > >> > >
> > > >> > > > hi,
> > > >> > > >
> > > >> > > > no only on reboot, that´s why it´s so strange...
> > > >> > > >
> > > >> > > > i just tested it again. when i stop the sql server the
> > > >> > > > sqlserveragent is
> > > >> > > > stopping too. when i start the sql server i´m able to start the
> > > >> > > > sqlserveragent (right now with the domain account). but i´m able to
> > > >> > > > start the
> > > >> > > > sqlserveragent with the system account too.
> > > >> > > >
> > > >> > > > only on reboot / startup the services are not starting with the
> > > >> > > > below events.
> > > >> > > >
> > > >> > > > i´m desperate :(
> > > >> > > >
> > > >> > > > --
> > > >> > > > kind regards / liebe grüsse
> > > >> > > > dominique
> > > >> > > >
> > > >> > > >
> > > >> > > > "John Bell" wrote:
> > > >> > > >
> > > >> > > > > Hi
> > > >> > > > >
> > > >> > > > > Is this only happening occuring when you reboot the server, or
> > > >> > > > > when you
> > > >> > > > > stop/start SQL Server once the server is running?
> > > >> > > > >
> > > >> > > > > John
> > > >> > > > >
> > > >> > > > > "dominique" wrote:
> > > >> > > > >
> > > >> > > > > > hi john,
> > > >> > > > > >
> > > >> > > > > > first of all, thank you for your answer.
> > > >> > > > > > i´m using the system account all the time.
> > > >> > > > > > i just tried your suggestion using a domain account for
> > > >> > > > > > starting the two
> > > >> > > > > > services and rebooted the server. now the events 103 are gone,
> > > >> > > > > > but i´m
> > > >> > > > > > getting two events 7000 service control manager:
> > > >> > > > > > (translation from german)
> > > >> > > > > > the "SQLAgent$SBSMONITORING" / "SQLSERVERAGENT" service failed
> > > >> > > > > > to start due
> > > >> > > > > > to the following error:
> > > >> > > > > > the accountname is incorrect or not existent, or the password
> > > >> > > > > > for the
> > > >> > > > > > accountname is incorrect.
> > > >> > > > > >
> > > >> > > > > > the account is a domain-admin account.
> > > >> > > > > >
> > > >> > > > > > when i tried to start the service manually it was successfull
> > > >> > > > > > again... ://
> > > >> > > > > >
> > > >> > > > > > i don´t understand it... :(
> > > >> > > > > >
> > > >> > > > > > any ideas?
> > > >> > > > > >
> > > >> > > > > > --
> > > >> > > > > > kind regards / liebe grüsse
> > > >> > > > > > dominique
> > > >> > > > > >
> > > >> > > > > >
> > > >> > > > > > "John Bell" wrote:
> > > >> > > > > >
> > > >> > > > > > > Hi
> > > >> > > > > > >
> > > >> > > > > > > This sounds like it can not authenticate the service account
> > > >> > > > > > > in the AD, have
> > > >> > > > > > > you tried setting it to the system account or to a different
> > > >> > > > > > > domain one?
> > > >> > > > > > >
> > > >> > > > > > > John
> > > >> > > > > > >
> > > >> > > > > > > "dominique" wrote:
> > > >> > > > > > >
> > > >> > > > > > > > hi @.all,
> > > >> > > > > > > >
> > > >> > > > > > > > when rebooting the sbs 2k3 server, first the service
> > > >> > > > > > > > sqlagent$sbsmonitoring
> > > >> > > > > > > > failes to start and then the sqlserveragent. both events
> > > >> > > > > > > > are record with the
> > > >> > > > > > > > event id 103:
> > > >> > > > > > > > sqlagent$sbsmonitoring:
> > > >> > > > > > > > SQLServerAgent could not be started (reason: Unable to
> > > >> > > > > > > > connect to server
> > > >> > > > > > > > "(sbs\sbsmonitoring)"; SQLServerAgent
> > > >> > > > > > > > cannot start).
> > > >> > > > > > > > sqlserveragent:
> > > >> > > > > > > > SQLServerAgent could not be started (reason: Unable to
> > > >> > > > > > > > connect to server
> > > >> > > > > > > > "(local)"; SQLServerAgent
> > > >> > > > > > > > cannot start).
> > > >> > > > > > > >
> > > >> > > > > > > > after searching the web i found an articel describing to
> > > >> > > > > > > > look for the
> > > >> > > > > > > > sqlagent.out file. i found two files in "microsoft sql
> > > >> > > > > > > > server\mssql\log" and
> > > >> > > > > > > > "microsoft sql server\mssql$sbsmonitoring". both have the
> > > >> > > > > > > > error "Cannot
> > > >> > > > > > > > Generate SSPI Context".
> > > >> > > > > > > >
> > > >> > > > > > > > when i start the services manually it works fine, but NOT
> > > >> > > > > > > > on startup... i
> > > >> > > > > > > > even searched the kb from ms, but didn´t find anything that
> > > >> > > > > > > > helped me.
> > > >> > > > > > > >
> > > >> > > > > > > > even if i set the services to start over if an error
> > > >> > > > > > > > occure, it doesn´t
> > > >> > > > > > > > work. only if i start the services manually... :(
> > > >> > > > > > > > the services are set to start with the local system
> > > >> > > > > > > > account.
> > > >> > > > > > > >
> > > >> > > > > > > > i don´t have any knowledge from a sql server. can somebody
> > > >> > > > > > > > please help me!
> > > >> > > > > > > >
> > > >> > > > > > > > --
> > > >> > > > > > > > kind regards / liebe grüsse
> > > >> > > > > > > > dominique
> > > >>
> > > >>
> > >
> > >
> > >|||Hi
Have you stopped the SQL Server Agent service for the instances where you
don't want it to run? Try changing the start up type to manual.
John
"dominique" wrote:
> hi john,
> there are multiple instances running.
> backup exec, msfw (isa), sbsmonitoring and sharepoint. but the
> sqlserveragent is only needed for sbsmonitoring and local.
> Did that answer your question? :/
> thanks again for your help :)
> --
> kind regards / liebe grüsse
> dominique
>
> "John Bell" wrote:
> > Hi
> >
> > You can install multiple instances on a single server, if you run the
> > command NET START from a command prompt you may have multiple instances that
> > are either like MSSQLSERVER or MSQL$INSTANCE.
> >
> > John
> >
> > "dominique" wrote:
> >
> > > hi john,
> > >
> > > no, not that i know. i´m running only one sql server.
> > >
> > > i´m sorry, but i don´t understand your question. what instance do you mean?
> > > the sbsmonitoring?
> > > --
> > > kind regards / liebe grüsse
> > > dominique
> > >
> > >
> > > "John Bell" wrote:
> > >
> > > > Hi
> > > >
> > > > Are you running two copies of SQL Server on this server? If this instance is
> > > > the default then it would be the same as (local).
> > > >
> > > > John
> > > >
> > > > "dominique" <dominique@.discussions.microsoft.com> wrote in message
> > > > news:E0C60EA7-62C6-4146-90A8-21E76083B9AD@.microsoft.com...
> > > > > hi john,
> > > > >
> > > > > i tried the following now:
> > > > >
> > > > > after reading the kb i changed the authentification for the sqlserveragent
> > > > > (local) to sql authentification and that worked! :)
> > > > > now the sqlserveragent (local) is starting, but i´m still getting the
> > > > > event
> > > > > 103 on sqlagent$sbsmonitoring. i changed the authentification for the
> > > > > sqlserveragent too, but that didn´t worked. i´m only able to start the
> > > > > sqlserveragent when windows authentification is enabled... :( :( :(
> > > > >
> > > > > any other suggestions? ://
> > > > >
> > > > > --
> > > > > kind regards / liebe grüsse
> > > > > dominique
> > > > >
> > > > >
> > > > > "John Bell" wrote:
> > > > >
> > > > >> Hi
> > > > >>
> > > > >> Make sure that the SQLServerAgent service is dependent on the SQL
> > > > >> Server service in the Services Applet.
> > > > >>
> > > > >> Also you may want to check out http://support.microsoft.com/kb/811889/
> > > > >>
> > > > >> "Cannot Generate SSPI Context" is an issue authenticating the service
> > > > >> account with AD not SQL Server, but as this seems to work once you are
> > > > >> allowed to log in, it would indicate that either something has started
> > > > >> at the time the service wishes to authenticate or something is stopping
> > > > >> the authentication happening, which is resolved by the time you can log
> > > > >> in.
> > > > >>
> > > > >> John
> > > > >>
> > > > >> dominique wrote:
> > > > >> > hi john,
> > > > >> >
> > > > >> > thanks for trying to resolve my problem, i really apreciate this :))
> > > > >> >
> > > > >> > hm... is the sql server service starting too early or too late?
> > > > >> > remember the
> > > > >> > event:
> > > > >> > could not be started (reason: Unable to connect to server "(local)";
> > > > >> > SQLServerAgent
> > > > >> >
> > > > >> > how can i check to see if the network services are taking too long to
> > > > >> > start?
> > > > >> > the network card is working fine, no problems or events here.
> > > > >> >
> > > > >> > the server needs a pretty long time to boot, but it is a sbs, so he´s
> > > > >> > got a
> > > > >> > lot of work to do, when booting :/ i thought this is "normal".
> > > > >> >
> > > > >> > how can i make the SQLServer dependent on another service?
> > > > >> >
> > > > >> > i don´t have any software firewall running... isa is running only as a
> > > > >> > proxy.
> > > > >> >
> > > > >> > --
> > > > >> > kind regards / liebe grüsse
> > > > >> > dominique
> > > > >> >
> > > > >> >
> > > > >> > "John Bell" wrote:
> > > > >> >
> > > > >> > > Hi dominique
> > > > >> > >
> > > > >> > > If this is only on re-boot then it sounds like SQL Server service is
> > > > >> > > starting too early. You may want to check to see if the network
> > > > >> > > services are
> > > > >> > > taking too long to start or possibly there may be a problem with the
> > > > >> > > network
> > > > >> > > card. If you can make SQLServer dependent another service (say
> > > > >> > > computer
> > > > >> > > browser) then it may delay things for long enough. If you have a
> > > > >> > > software
> > > > >> > > firewall running, check to see how long this takes to start up.
> > > > >> > >
> > > > >> > > John
> > > > >> > >
> > > > >> > > "dominique" wrote:
> > > > >> > >
> > > > >> > > > hi,
> > > > >> > > >
> > > > >> > > > no only on reboot, that´s why it´s so strange...
> > > > >> > > >
> > > > >> > > > i just tested it again. when i stop the sql server the
> > > > >> > > > sqlserveragent is
> > > > >> > > > stopping too. when i start the sql server i´m able to start the
> > > > >> > > > sqlserveragent (right now with the domain account). but i´m able to
> > > > >> > > > start the
> > > > >> > > > sqlserveragent with the system account too.
> > > > >> > > >
> > > > >> > > > only on reboot / startup the services are not starting with the
> > > > >> > > > below events.
> > > > >> > > >
> > > > >> > > > i´m desperate :(
> > > > >> > > >
> > > > >> > > > --
> > > > >> > > > kind regards / liebe grüsse
> > > > >> > > > dominique
> > > > >> > > >
> > > > >> > > >
> > > > >> > > > "John Bell" wrote:
> > > > >> > > >
> > > > >> > > > > Hi
> > > > >> > > > >
> > > > >> > > > > Is this only happening occuring when you reboot the server, or
> > > > >> > > > > when you
> > > > >> > > > > stop/start SQL Server once the server is running?
> > > > >> > > > >
> > > > >> > > > > John
> > > > >> > > > >
> > > > >> > > > > "dominique" wrote:
> > > > >> > > > >
> > > > >> > > > > > hi john,
> > > > >> > > > > >
> > > > >> > > > > > first of all, thank you for your answer.
> > > > >> > > > > > i´m using the system account all the time.
> > > > >> > > > > > i just tried your suggestion using a domain account for
> > > > >> > > > > > starting the two
> > > > >> > > > > > services and rebooted the server. now the events 103 are gone,
> > > > >> > > > > > but i´m
> > > > >> > > > > > getting two events 7000 service control manager:
> > > > >> > > > > > (translation from german)
> > > > >> > > > > > the "SQLAgent$SBSMONITORING" / "SQLSERVERAGENT" service failed
> > > > >> > > > > > to start due
> > > > >> > > > > > to the following error:
> > > > >> > > > > > the accountname is incorrect or not existent, or the password
> > > > >> > > > > > for the
> > > > >> > > > > > accountname is incorrect.
> > > > >> > > > > >
> > > > >> > > > > > the account is a domain-admin account.
> > > > >> > > > > >
> > > > >> > > > > > when i tried to start the service manually it was successfull
> > > > >> > > > > > again... ://
> > > > >> > > > > >
> > > > >> > > > > > i don´t understand it... :(
> > > > >> > > > > >
> > > > >> > > > > > any ideas?
> > > > >> > > > > >
> > > > >> > > > > > --
> > > > >> > > > > > kind regards / liebe grüsse
> > > > >> > > > > > dominique
> > > > >> > > > > >
> > > > >> > > > > >
> > > > >> > > > > > "John Bell" wrote:
> > > > >> > > > > >
> > > > >> > > > > > > Hi
> > > > >> > > > > > >
> > > > >> > > > > > > This sounds like it can not authenticate the service account
> > > > >> > > > > > > in the AD, have
> > > > >> > > > > > > you tried setting it to the system account or to a different
> > > > >> > > > > > > domain one?
> > > > >> > > > > > >
> > > > >> > > > > > > John
> > > > >> > > > > > >
> > > > >> > > > > > > "dominique" wrote:
> > > > >> > > > > > >
> > > > >> > > > > > > > hi @.all,
> > > > >> > > > > > > >
> > > > >> > > > > > > > when rebooting the sbs 2k3 server, first the service
> > > > >> > > > > > > > sqlagent$sbsmonitoring
> > > > >> > > > > > > > failes to start and then the sqlserveragent. both events
> > > > >> > > > > > > > are record with the
> > > > >> > > > > > > > event id 103:
> > > > >> > > > > > > > sqlagent$sbsmonitoring:
> > > > >> > > > > > > > SQLServerAgent could not be started (reason: Unable to
> > > > >> > > > > > > > connect to server
> > > > >> > > > > > > > "(sbs\sbsmonitoring)"; SQLServerAgent
> > > > >> > > > > > > > cannot start).
> > > > >> > > > > > > > sqlserveragent:
> > > > >> > > > > > > > SQLServerAgent could not be started (reason: Unable to
> > > > >> > > > > > > > connect to server
> > > > >> > > > > > > > "(local)"; SQLServerAgent
> > > > >> > > > > > > > cannot start).
> > > > >> > > > > > > >
> > > > >> > > > > > > > after searching the web i found an articel describing to
> > > > >> > > > > > > > look for the
> > > > >> > > > > > > > sqlagent.out file. i found two files in "microsoft sql
> > > > >> > > > > > > > server\mssql\log" and
> > > > >> > > > > > > > "microsoft sql server\mssql$sbsmonitoring". both have the
> > > > >> > > > > > > > error "Cannot
> > > > >> > > > > > > > Generate SSPI Context".
> > > > >> > > > > > > >
> > > > >> > > > > > > > when i start the services manually it works fine, but NOT
> > > > >> > > > > > > > on startup... i
> > > > >> > > > > > > > even searched the kb from ms, but didn´t find anything that
> > > > >> > > > > > > > helped me.
> > > > >> > > > > > > >
> > > > >> > > > > > > > even if i set the services to start over if an error
> > > > >> > > > > > > > occure, it doesn´t
> > > > >> > > > > > > > work. only if i start the services manually... :(
> > > > >> > > > > > > > the services are set to start with the local system
> > > > >> > > > > > > > account.
> > > > >> > > > > > > >
> > > > >> > > > > > > > i don´t have any knowledge from a sql server. can somebody
> > > > >> > > > > > > > please help me!
> > > > >> > > > > > > >
> > > > >> > > > > > > > --
> > > > >> > > > > > > > kind regards / liebe grüsse
> > > > >> > > > > > > > dominique
> > > > >>
> > > > >>
> > > >
> > > >
> > > >|||hi john,
sorry my fault. the sql server agent service is running only on the two
instances (sbsmonitoring and local) and the start up type for the other
instances is allready manual.
--
kind regards / liebe grüsse
dominique
"John Bell" wrote:
> Hi
> Have you stopped the SQL Server Agent service for the instances where you
> don't want it to run? Try changing the start up type to manual.
> John
>
> "dominique" wrote:
> > hi john,
> >
> > there are multiple instances running.
> > backup exec, msfw (isa), sbsmonitoring and sharepoint. but the
> > sqlserveragent is only needed for sbsmonitoring and local.
> >
> > Did that answer your question? :/
> >
> > thanks again for your help :)
> >
> > --
> > kind regards / liebe grüsse
> > dominique
> >
> >
> > "John Bell" wrote:
> >
> > > Hi
> > >
> > > You can install multiple instances on a single server, if you run the
> > > command NET START from a command prompt you may have multiple instances that
> > > are either like MSSQLSERVER or MSQL$INSTANCE.
> > >
> > > John
> > >
> > > "dominique" wrote:
> > >
> > > > hi john,
> > > >
> > > > no, not that i know. i´m running only one sql server.
> > > >
> > > > i´m sorry, but i don´t understand your question. what instance do you mean?
> > > > the sbsmonitoring?
> > > > --
> > > > kind regards / liebe grüsse
> > > > dominique
> > > >
> > > >
> > > > "John Bell" wrote:
> > > >
> > > > > Hi
> > > > >
> > > > > Are you running two copies of SQL Server on this server? If this instance is
> > > > > the default then it would be the same as (local).
> > > > >
> > > > > John
> > > > >
> > > > > "dominique" <dominique@.discussions.microsoft.com> wrote in message
> > > > > news:E0C60EA7-62C6-4146-90A8-21E76083B9AD@.microsoft.com...
> > > > > > hi john,
> > > > > >
> > > > > > i tried the following now:
> > > > > >
> > > > > > after reading the kb i changed the authentification for the sqlserveragent
> > > > > > (local) to sql authentification and that worked! :)
> > > > > > now the sqlserveragent (local) is starting, but i´m still getting the
> > > > > > event
> > > > > > 103 on sqlagent$sbsmonitoring. i changed the authentification for the
> > > > > > sqlserveragent too, but that didn´t worked. i´m only able to start the
> > > > > > sqlserveragent when windows authentification is enabled... :( :( :(
> > > > > >
> > > > > > any other suggestions? ://
> > > > > >
> > > > > > --
> > > > > > kind regards / liebe grüsse
> > > > > > dominique
> > > > > >
> > > > > >
> > > > > > "John Bell" wrote:
> > > > > >
> > > > > >> Hi
> > > > > >>
> > > > > >> Make sure that the SQLServerAgent service is dependent on the SQL
> > > > > >> Server service in the Services Applet.
> > > > > >>
> > > > > >> Also you may want to check out http://support.microsoft.com/kb/811889/
> > > > > >>
> > > > > >> "Cannot Generate SSPI Context" is an issue authenticating the service
> > > > > >> account with AD not SQL Server, but as this seems to work once you are
> > > > > >> allowed to log in, it would indicate that either something has started
> > > > > >> at the time the service wishes to authenticate or something is stopping
> > > > > >> the authentication happening, which is resolved by the time you can log
> > > > > >> in.
> > > > > >>
> > > > > >> John
> > > > > >>
> > > > > >> dominique wrote:
> > > > > >> > hi john,
> > > > > >> >
> > > > > >> > thanks for trying to resolve my problem, i really apreciate this :))
> > > > > >> >
> > > > > >> > hm... is the sql server service starting too early or too late?
> > > > > >> > remember the
> > > > > >> > event:
> > > > > >> > could not be started (reason: Unable to connect to server "(local)";
> > > > > >> > SQLServerAgent
> > > > > >> >
> > > > > >> > how can i check to see if the network services are taking too long to
> > > > > >> > start?
> > > > > >> > the network card is working fine, no problems or events here.
> > > > > >> >
> > > > > >> > the server needs a pretty long time to boot, but it is a sbs, so he´s
> > > > > >> > got a
> > > > > >> > lot of work to do, when booting :/ i thought this is "normal".
> > > > > >> >
> > > > > >> > how can i make the SQLServer dependent on another service?
> > > > > >> >
> > > > > >> > i don´t have any software firewall running... isa is running only as a
> > > > > >> > proxy.
> > > > > >> >
> > > > > >> > --
> > > > > >> > kind regards / liebe grüsse
> > > > > >> > dominique
> > > > > >> >
> > > > > >> >
> > > > > >> > "John Bell" wrote:
> > > > > >> >
> > > > > >> > > Hi dominique
> > > > > >> > >
> > > > > >> > > If this is only on re-boot then it sounds like SQL Server service is
> > > > > >> > > starting too early. You may want to check to see if the network
> > > > > >> > > services are
> > > > > >> > > taking too long to start or possibly there may be a problem with the
> > > > > >> > > network
> > > > > >> > > card. If you can make SQLServer dependent another service (say
> > > > > >> > > computer
> > > > > >> > > browser) then it may delay things for long enough. If you have a
> > > > > >> > > software
> > > > > >> > > firewall running, check to see how long this takes to start up.
> > > > > >> > >
> > > > > >> > > John
> > > > > >> > >
> > > > > >> > > "dominique" wrote:
> > > > > >> > >
> > > > > >> > > > hi,
> > > > > >> > > >
> > > > > >> > > > no only on reboot, that´s why it´s so strange...
> > > > > >> > > >
> > > > > >> > > > i just tested it again. when i stop the sql server the
> > > > > >> > > > sqlserveragent is
> > > > > >> > > > stopping too. when i start the sql server i´m able to start the
> > > > > >> > > > sqlserveragent (right now with the domain account). but i´m able to
> > > > > >> > > > start the
> > > > > >> > > > sqlserveragent with the system account too.
> > > > > >> > > >
> > > > > >> > > > only on reboot / startup the services are not starting with the
> > > > > >> > > > below events.
> > > > > >> > > >
> > > > > >> > > > i´m desperate :(
> > > > > >> > > >
> > > > > >> > > > --
> > > > > >> > > > kind regards / liebe grüsse
> > > > > >> > > > dominique
> > > > > >> > > >
> > > > > >> > > >
> > > > > >> > > > "John Bell" wrote:
> > > > > >> > > >
> > > > > >> > > > > Hi
> > > > > >> > > > >
> > > > > >> > > > > Is this only happening occuring when you reboot the server, or
> > > > > >> > > > > when you
> > > > > >> > > > > stop/start SQL Server once the server is running?
> > > > > >> > > > >
> > > > > >> > > > > John
> > > > > >> > > > >
> > > > > >> > > > > "dominique" wrote:
> > > > > >> > > > >
> > > > > >> > > > > > hi john,
> > > > > >> > > > > >
> > > > > >> > > > > > first of all, thank you for your answer.
> > > > > >> > > > > > i´m using the system account all the time.
> > > > > >> > > > > > i just tried your suggestion using a domain account for
> > > > > >> > > > > > starting the two
> > > > > >> > > > > > services and rebooted the server. now the events 103 are gone,
> > > > > >> > > > > > but i´m
> > > > > >> > > > > > getting two events 7000 service control manager:
> > > > > >> > > > > > (translation from german)
> > > > > >> > > > > > the "SQLAgent$SBSMONITORING" / "SQLSERVERAGENT" service failed
> > > > > >> > > > > > to start due
> > > > > >> > > > > > to the following error:
> > > > > >> > > > > > the accountname is incorrect or not existent, or the password
> > > > > >> > > > > > for the
> > > > > >> > > > > > accountname is incorrect.
> > > > > >> > > > > >
> > > > > >> > > > > > the account is a domain-admin account.
> > > > > >> > > > > >
> > > > > >> > > > > > when i tried to start the service manually it was successfull
> > > > > >> > > > > > again... ://
> > > > > >> > > > > >
> > > > > >> > > > > > i don´t understand it... :(
> > > > > >> > > > > >
> > > > > >> > > > > > any ideas?
> > > > > >> > > > > >
> > > > > >> > > > > > --
> > > > > >> > > > > > kind regards / liebe grüsse
> > > > > >> > > > > > dominique
> > > > > >> > > > > >
> > > > > >> > > > > >
> > > > > >> > > > > > "John Bell" wrote:
> > > > > >> > > > > >
> > > > > >> > > > > > > Hi
> > > > > >> > > > > > >
> > > > > >> > > > > > > This sounds like it can not authenticate the service account
> > > > > >> > > > > > > in the AD, have
> > > > > >> > > > > > > you tried setting it to the system account or to a different
> > > > > >> > > > > > > domain one?
> > > > > >> > > > > > >
> > > > > >> > > > > > > John
> > > > > >> > > > > > >
> > > > > >> > > > > > > "dominique" wrote:
> > > > > >> > > > > > >
> > > > > >> > > > > > > > hi @.all,
> > > > > >> > > > > > > >
> > > > > >> > > > > > > > when rebooting the sbs 2k3 server, first the service
> > > > > >> > > > > > > > sqlagent$sbsmonitoring
> > > > > >> > > > > > > > failes to start and then the sqlserveragent. both events
> > > > > >> > > > > > > > are record with the
> > > > > >> > > > > > > > event id 103:
> > > > > >> > > > > > > > sqlagent$sbsmonitoring:
> > > > > >> > > > > > > > SQLServerAgent could not be started (reason: Unable to
> > > > > >> > > > > > > > connect to server
> > > > > >> > > > > > > > "(sbs\sbsmonitoring)"; SQLServerAgent
> > > > > >> > > > > > > > cannot start).
> > > > > >> > > > > > > > sqlserveragent:
> > > > > >> > > > > > > > SQLServerAgent could not be started (reason: Unable to
> > > > > >> > > > > > > > connect to server
> > > > > >> > > > > > > > "(local)"; SQLServerAgent
> > > > > >> > > > > > > > cannot start).
> > > > > >> > > > > > > >
> > > > > >> > > > > > > > after searching the web i found an articel describing to
> > > > > >> > > > > > > > look for the
> > > > > >> > > > > > > > sqlagent.out file. i found two files in "microsoft sql
> > > > > >> > > > > > > > server\mssql\log" and
> > > > > >> > > > > > > > "microsoft sql server\mssql$sbsmonitoring". both have the
> > > > > >> > > > > > > > error "Cannot
> > > > > >> > > > > > > > Generate SSPI Context".
> > > > > >> > > > > > > >
> > > > > >> > > > > > > > when i start the services manually it works fine, but NOT
> > > > > >> > > > > > > > on startup... i
> > > > > >> > > > > > > > even searched the kb from ms, but didn´t find anything that
> > > > > >> > > > > > > > helped me.
> > > > > >> > > > > > > >
> > > > > >> > > > > > > > even if i set the services to start over if an error
> > > > > >> > > > > > > > occure, it doesn´t
> > > > > >> > > > > > > > work. only if i start the services manually... :(
> > > > > >> > > > > > > > the services are set to start with the local system
> > > > > >> > > > > > > > account.
> > > > > >> > > > > > > >
> > > > > >> > > > > > > > i don´t have any knowledge from a sql server. can somebody
> > > > > >> > > > > > > > please help me!
> > > > > >> > > > > > > >
> > > > > >> > > > > > > > --
> > > > > >> > > > > > > > kind regards / liebe grüsse
> > > > > >> > > > > > > > dominique
> > > > > >>
> > > > > >>
> > > > >
> > > > >
> > > > >|||Hi
Are these two services running under the same user? If they are then try
changing them to a different one.
John
"dominique" wrote:
> hi john,
> sorry my fault. the sql server agent service is running only on the two
> instances (sbsmonitoring and local) and the start up type for the other
> instances is allready manual.
> --
> kind regards / liebe grüsse
> dominique
>
> "John Bell" wrote:
> > Hi
> >
> > Have you stopped the SQL Server Agent service for the instances where you
> > don't want it to run? Try changing the start up type to manual.
> >
> > John
> >
> >
> > "dominique" wrote:
> >
> > > hi john,
> > >
> > > there are multiple instances running.
> > > backup exec, msfw (isa), sbsmonitoring and sharepoint. but the
> > > sqlserveragent is only needed for sbsmonitoring and local.
> > >
> > > Did that answer your question? :/
> > >
> > > thanks again for your help :)
> > >
> > > --
> > > kind regards / liebe grüsse
> > > dominique
> > >
> > >
> > > "John Bell" wrote:
> > >
> > > > Hi
> > > >
> > > > You can install multiple instances on a single server, if you run the
> > > > command NET START from a command prompt you may have multiple instances that
> > > > are either like MSSQLSERVER or MSQL$INSTANCE.
> > > >
> > > > John
> > > >
> > > > "dominique" wrote:
> > > >
> > > > > hi john,
> > > > >
> > > > > no, not that i know. i´m running only one sql server.
> > > > >
> > > > > i´m sorry, but i don´t understand your question. what instance do you mean?
> > > > > the sbsmonitoring?
> > > > > --
> > > > > kind regards / liebe grüsse
> > > > > dominique
> > > > >
> > > > >
> > > > > "John Bell" wrote:
> > > > >
> > > > > > Hi
> > > > > >
> > > > > > Are you running two copies of SQL Server on this server? If this instance is
> > > > > > the default then it would be the same as (local).
> > > > > >
> > > > > > John
> > > > > >
> > > > > > "dominique" <dominique@.discussions.microsoft.com> wrote in message
> > > > > > news:E0C60EA7-62C6-4146-90A8-21E76083B9AD@.microsoft.com...
> > > > > > > hi john,
> > > > > > >
> > > > > > > i tried the following now:
> > > > > > >
> > > > > > > after reading the kb i changed the authentification for the sqlserveragent
> > > > > > > (local) to sql authentification and that worked! :)
> > > > > > > now the sqlserveragent (local) is starting, but i´m still getting the
> > > > > > > event
> > > > > > > 103 on sqlagent$sbsmonitoring. i changed the authentification for the
> > > > > > > sqlserveragent too, but that didn´t worked. i´m only able to start the
> > > > > > > sqlserveragent when windows authentification is enabled... :( :( :(
> > > > > > >
> > > > > > > any other suggestions? ://
> > > > > > >
> > > > > > > --
> > > > > > > kind regards / liebe grüsse
> > > > > > > dominique
> > > > > > >
> > > > > > >
> > > > > > > "John Bell" wrote:
> > > > > > >
> > > > > > >> Hi
> > > > > > >>
> > > > > > >> Make sure that the SQLServerAgent service is dependent on the SQL
> > > > > > >> Server service in the Services Applet.
> > > > > > >>
> > > > > > >> Also you may want to check out http://support.microsoft.com/kb/811889/
> > > > > > >>
> > > > > > >> "Cannot Generate SSPI Context" is an issue authenticating the service
> > > > > > >> account with AD not SQL Server, but as this seems to work once you are
> > > > > > >> allowed to log in, it would indicate that either something has started
> > > > > > >> at the time the service wishes to authenticate or something is stopping
> > > > > > >> the authentication happening, which is resolved by the time you can log
> > > > > > >> in.
> > > > > > >>
> > > > > > >> John
> > > > > > >>
> > > > > > >> dominique wrote:
> > > > > > >> > hi john,
> > > > > > >> >
> > > > > > >> > thanks for trying to resolve my problem, i really apreciate this :))
> > > > > > >> >
> > > > > > >> > hm... is the sql server service starting too early or too late?
> > > > > > >> > remember the
> > > > > > >> > event:
> > > > > > >> > could not be started (reason: Unable to connect to server "(local)";
> > > > > > >> > SQLServerAgent
> > > > > > >> >
> > > > > > >> > how can i check to see if the network services are taking too long to
> > > > > > >> > start?
> > > > > > >> > the network card is working fine, no problems or events here.
> > > > > > >> >
> > > > > > >> > the server needs a pretty long time to boot, but it is a sbs, so he´s
> > > > > > >> > got a
> > > > > > >> > lot of work to do, when booting :/ i thought this is "normal".
> > > > > > >> >
> > > > > > >> > how can i make the SQLServer dependent on another service?
> > > > > > >> >
> > > > > > >> > i don´t have any software firewall running... isa is running only as a
> > > > > > >> > proxy.
> > > > > > >> >
> > > > > > >> > --
> > > > > > >> > kind regards / liebe grüsse
> > > > > > >> > dominique
> > > > > > >> >
> > > > > > >> >
> > > > > > >> > "John Bell" wrote:
> > > > > > >> >
> > > > > > >> > > Hi dominique
> > > > > > >> > >
> > > > > > >> > > If this is only on re-boot then it sounds like SQL Server service is
> > > > > > >> > > starting too early. You may want to check to see if the network
> > > > > > >> > > services are
> > > > > > >> > > taking too long to start or possibly there may be a problem with the
> > > > > > >> > > network
> > > > > > >> > > card. If you can make SQLServer dependent another service (say
> > > > > > >> > > computer
> > > > > > >> > > browser) then it may delay things for long enough. If you have a
> > > > > > >> > > software
> > > > > > >> > > firewall running, check to see how long this takes to start up.
> > > > > > >> > >
> > > > > > >> > > John
> > > > > > >> > >
> > > > > > >> > > "dominique" wrote:
> > > > > > >> > >
> > > > > > >> > > > hi,
> > > > > > >> > > >
> > > > > > >> > > > no only on reboot, that´s why it´s so strange...
> > > > > > >> > > >
> > > > > > >> > > > i just tested it again. when i stop the sql server the
> > > > > > >> > > > sqlserveragent is
> > > > > > >> > > > stopping too. when i start the sql server i´m able to start the
> > > > > > >> > > > sqlserveragent (right now with the domain account). but i´m able to
> > > > > > >> > > > start the
> > > > > > >> > > > sqlserveragent with the system account too.
> > > > > > >> > > >
> > > > > > >> > > > only on reboot / startup the services are not starting with the
> > > > > > >> > > > below events.
> > > > > > >> > > >
> > > > > > >> > > > i´m desperate :(
> > > > > > >> > > >
> > > > > > >> > > > --
> > > > > > >> > > > kind regards / liebe grüsse
> > > > > > >> > > > dominique
> > > > > > >> > > >
> > > > > > >> > > >
> > > > > > >> > > > "John Bell" wrote:
> > > > > > >> > > >
> > > > > > >> > > > > Hi
> > > > > > >> > > > >
> > > > > > >> > > > > Is this only happening occuring when you reboot the server, or
> > > > > > >> > > > > when you
> > > > > > >> > > > > stop/start SQL Server once the server is running?
> > > > > > >> > > > >
> > > > > > >> > > > > John
> > > > > > >> > > > >
> > > > > > >> > > > > "dominique" wrote:
> > > > > > >> > > > >
> > > > > > >> > > > > > hi john,
> > > > > > >> > > > > >
> > > > > > >> > > > > > first of all, thank you for your answer.
> > > > > > >> > > > > > i´m using the system account all the time.
> > > > > > >> > > > > > i just tried your suggestion using a domain account for
> > > > > > >> > > > > > starting the two
> > > > > > >> > > > > > services and rebooted the server. now the events 103 are gone,
> > > > > > >> > > > > > but i´m
> > > > > > >> > > > > > getting two events 7000 service control manager:
> > > > > > >> > > > > > (translation from german)
> > > > > > >> > > > > > the "SQLAgent$SBSMONITORING" / "SQLSERVERAGENT" service failed
> > > > > > >> > > > > > to start due
> > > > > > >> > > > > > to the following error:
> > > > > > >> > > > > > the accountname is incorrect or not existent, or the password
> > > > > > >> > > > > > for the
> > > > > > >> > > > > > accountname is incorrect.
> > > > > > >> > > > > >
> > > > > > >> > > > > > the account is a domain-admin account.
> > > > > > >> > > > > >
> > > > > > >> > > > > > when i tried to start the service manually it was successfull
> > > > > > >> > > > > > again... ://
> > > > > > >> > > > > >
> > > > > > >> > > > > > i don´t understand it... :(
> > > > > > >> > > > > >
> > > > > > >> > > > > > any ideas?
> > > > > > >> > > > > >
> > > > > > >> > > > > > --
> > > > > > >> > > > > > kind regards / liebe grüsse
> > > > > > >> > > > > > dominique
> > > > > > >> > > > > >
> > > > > > >> > > > > >
> > > > > > >> > > > > > "John Bell" wrote:
> > > > > > >> > > > > >
> > > > > > >> > > > > > > Hi
> > > > > > >> > > > > > >
> > > > > > >> > > > > > > This sounds like it can not authenticate the service account
> > > > > > >> > > > > > > in the AD, have
> > > > > > >> > > > > > > you tried setting it to the system account or to a different
> > > > > > >> > > > > > > domain one?
> > > > > > >> > > > > > >
> > > > > > >> > > > > > > John
> > > > > > >> > > > > > >
> > > > > > >> > > > > > > "dominique" wrote:
> > > > > > >> > > > > > >
> > > > > > >> > > > > > > > hi @.all,
> > > > > > >> > > > > > > >
> > > > > > >> > > > > > > > when rebooting the sbs 2k3 server, first the service
> > > > > > >> > > > > > > > sqlagent$sbsmonitoring
> > > > > > >> > > > > > > > failes to start and then the sqlserveragent. both events
> > > > > > >> > > > > > > > are record with the
> > > > > > >> > > > > > > > event id 103:
> > > > > > >> > > > > > > > sqlagent$sbsmonitoring:
> > > > > > >> > > > > > > > SQLServerAgent could not be started (reason: Unable to
> > > > > > >> > > > > > > > connect to server
> > > > > > >> > > > > > > > "(sbs\sbsmonitoring)"; SQLServerAgent
> > > > > > >> > > > > > > > cannot start).
> > > > > > >> > > > > > > > sqlserveragent:
> > > > > > >> > > > > > > > SQLServerAgent could not be started (reason: Unable to
> > > > > > >> > > > > > > > connect to server
> > > > > > >> > > > > > > > "(local)"; SQLServerAgent
> > > > > > >> > > > > > > > cannot start).
> > > > > > >> > > > > > > >
> > > > > > >> > > > > > > > after searching the web i found an articel describing to
> > > > > > >> > > > > > > > look for the
> > > > > > >> > > > > > > > sqlagent.out file. i found two files in "microsoft sql
> > > > > > >> > > > > > > > server\mssql\log" and
> > > > > > >> > > > > > > > "microsoft sql server\mssql$sbsmonitoring". both have the
> > > > > > >> > > > > > > > error "Cannot
> > > > > > >> > > > > > > > Generate SSPI Context".
> > > > > > >> > > > > > > >
> > > > > > >> > > > > > > > when i start the services manually it works fine, but NOT
> > > > > > >> > > > > > > > on startup... i
> > > > > > >> > > > > > > > even searched the kb from ms, but didn´t find anything that
> > > > > > >> > > > > > > > helped me.
> > > > > > >> > > > > > > >
> > > > > > >> > > > > > > > even if i set the services to start over if an error
> > > > > > >> > > > > > > > occure, it doesn´t
> > > > > > >> > > > > > > > work. only if i start the services manually... :(
> > > > > > >> > > > > > > > the services are set to start with the local system
> > > > > > >> > > > > > > > account.
> > > > > > >> > > > > > > >
> > > > > > >> > > > > > > > i don´t have any knowledge from a sql server. can somebody
> > > > > > >> > > > > > > > please help me!
> > > > > > >> > > > > > > >
> > > > > > >> > > > > > > > --
> > > > > > >> > > > > > > > kind regards / liebe grüsse
> > > > > > >> > > > > > > > dominique
> > > > > > >>
> > > > > > >>
> > > > > >
> > > > > >
> > > > > >|||hi john,
well they are running both under the local system. i think i tried changing
it to an (admin)user and the result was the same. service is not able to
start. but i´m gonna test it next week and tell you.
thank you for your help so far :) thank you, thank you, thank you :)
--
kind regards / liebe grüsse
dominique
"John Bell" wrote:
> Hi
> Are these two services running under the same user? If they are then try
> changing them to a different one.
> John
> "dominique" wrote:
> > hi john,
> >
> > sorry my fault. the sql server agent service is running only on the two
> > instances (sbsmonitoring and local) and the start up type for the other
> > instances is allready manual.
> >
> > --
> > kind regards / liebe grüsse
> > dominique
> >
> >
> > "John Bell" wrote:
> >
> > > Hi
> > >
> > > Have you stopped the SQL Server Agent service for the instances where you
> > > don't want it to run? Try changing the start up type to manual.
> > >
> > > John
> > >
> > >
> > > "dominique" wrote:
> > >
> > > > hi john,
> > > >
> > > > there are multiple instances running.
> > > > backup exec, msfw (isa), sbsmonitoring and sharepoint. but the
> > > > sqlserveragent is only needed for sbsmonitoring and local.
> > > >
> > > > Did that answer your question? :/
> > > >
> > > > thanks again for your help :)
> > > >
> > > > --
> > > > kind regards / liebe grüsse
> > > > dominique
> > > >
> > > >
> > > > "John Bell" wrote:
> > > >
> > > > > Hi
> > > > >
> > > > > You can install multiple instances on a single server, if you run the
> > > > > command NET START from a command prompt you may have multiple instances that
> > > > > are either like MSSQLSERVER or MSQL$INSTANCE.
> > > > >
> > > > > John
> > > > >
> > > > > "dominique" wrote:
> > > > >
> > > > > > hi john,
> > > > > >
> > > > > > no, not that i know. i´m running only one sql server.
> > > > > >
> > > > > > i´m sorry, but i don´t understand your question. what instance do you mean?
> > > > > > the sbsmonitoring?
> > > > > > --
> > > > > > kind regards / liebe grüsse
> > > > > > dominique
> > > > > >
> > > > > >
> > > > > > "John Bell" wrote:
> > > > > >
> > > > > > > Hi
> > > > > > >
> > > > > > > Are you running two copies of SQL Server on this server? If this instance is
> > > > > > > the default then it would be the same as (local).
> > > > > > >
> > > > > > > John
> > > > > > >
> > > > > > > "dominique" <dominique@.discussions.microsoft.com> wrote in message
> > > > > > > news:E0C60EA7-62C6-4146-90A8-21E76083B9AD@.microsoft.com...
> > > > > > > > hi john,
> > > > > > > >
> > > > > > > > i tried the following now:
> > > > > > > >
> > > > > > > > after reading the kb i changed the authentification for the sqlserveragent
> > > > > > > > (local) to sql authentification and that worked! :)
> > > > > > > > now the sqlserveragent (local) is starting, but i´m still getting the
> > > > > > > > event
> > > > > > > > 103 on sqlagent$sbsmonitoring. i changed the authentification for the
> > > > > > > > sqlserveragent too, but that didn´t worked. i´m only able to start the
> > > > > > > > sqlserveragent when windows authentification is enabled... :( :( :(
> > > > > > > >
> > > > > > > > any other suggestions? ://
> > > > > > > >
> > > > > > > > --
> > > > > > > > kind regards / liebe grüsse
> > > > > > > > dominique
> > > > > > > >
> > > > > > > >
> > > > > > > > "John Bell" wrote:
> > > > > > > >
> > > > > > > >> Hi
> > > > > > > >>
> > > > > > > >> Make sure that the SQLServerAgent service is dependent on the SQL
> > > > > > > >> Server service in the Services Applet.
> > > > > > > >>
> > > > > > > >> Also you may want to check out http://support.microsoft.com/kb/811889/
> > > > > > > >>
> > > > > > > >> "Cannot Generate SSPI Context" is an issue authenticating the service
> > > > > > > >> account with AD not SQL Server, but as this seems to work once you are
> > > > > > > >> allowed to log in, it would indicate that either something has started
> > > > > > > >> at the time the service wishes to authenticate or something is stopping
> > > > > > > >> the authentication happening, which is resolved by the time you can log
> > > > > > > >> in.
> > > > > > > >>
> > > > > > > >> John
> > > > > > > >>
> > > > > > > >> dominique wrote:
> > > > > > > >> > hi john,
> > > > > > > >> >
> > > > > > > >> > thanks for trying to resolve my problem, i really apreciate this :))
> > > > > > > >> >
> > > > > > > >> > hm... is the sql server service starting too early or too late?
> > > > > > > >> > remember the
> > > > > > > >> > event:
> > > > > > > >> > could not be started (reason: Unable to connect to server "(local)";
> > > > > > > >> > SQLServerAgent
> > > > > > > >> >
> > > > > > > >> > how can i check to see if the network services are taking too long to
> > > > > > > >> > start?
> > > > > > > >> > the network card is working fine, no problems or events here.
> > > > > > > >> >
> > > > > > > >> > the server needs a pretty long time to boot, but it is a sbs, so he´s
> > > > > > > >> > got a
> > > > > > > >> > lot of work to do, when booting :/ i thought this is "normal".
> > > > > > > >> >
> > > > > > > >> > how can i make the SQLServer dependent on another service?
> > > > > > > >> >
> > > > > > > >> > i don´t have any software firewall running... isa is running only as a
> > > > > > > >> > proxy.
> > > > > > > >> >
> > > > > > > >> > --
> > > > > > > >> > kind regards / liebe grüsse
> > > > > > > >> > dominique
> > > > > > > >> >
> > > > > > > >> >
> > > > > > > >> > "John Bell" wrote:
> > > > > > > >> >
> > > > > > > >> > > Hi dominique
> > > > > > > >> > >
> > > > > > > >> > > If this is only on re-boot then it sounds like SQL Server service is
> > > > > > > >> > > starting too early. You may want to check to see if the network
> > > > > > > >> > > services are
> > > > > > > >> > > taking too long to start or possibly there may be a problem with the
> > > > > > > >> > > network
> > > > > > > >> > > card. If you can make SQLServer dependent another service (say
> > > > > > > >> > > computer
> > > > > > > >> > > browser) then it may delay things for long enough. If you have a
> > > > > > > >> > > software
> > > > > > > >> > > firewall running, check to see how long this takes to start up.
> > > > > > > >> > >
> > > > > > > >> > > John
> > > > > > > >> > >
> > > > > > > >> > > "dominique" wrote:
> > > > > > > >> > >
> > > > > > > >> > > > hi,
> > > > > > > >> > > >
> > > > > > > >> > > > no only on reboot, that´s why it´s so strange...
> > > > > > > >> > > >
> > > > > > > >> > > > i just tested it again. when i stop the sql server the
> > > > > > > >> > > > sqlserveragent is
> > > > > > > >> > > > stopping too. when i start the sql server i´m able to start the
> > > > > > > >> > > > sqlserveragent (right now with the domain account). but i´m able to
> > > > > > > >> > > > start the
> > > > > > > >> > > > sqlserveragent with the system account too.
> > > > > > > >> > > >
> > > > > > > >> > > > only on reboot / startup the services are not starting with the
> > > > > > > >> > > > below events.
> > > > > > > >> > > >
> > > > > > > >> > > > i´m desperate :(
> > > > > > > >> > > >
> > > > > > > >> > > > --
> > > > > > > >> > > > kind regards / liebe grüsse
> > > > > > > >> > > > dominique
> > > > > > > >> > > >
> > > > > > > >> > > >
> > > > > > > >> > > > "John Bell" wrote:
> > > > > > > >> > > >
> > > > > > > >> > > > > Hi
> > > > > > > >> > > > >
> > > > > > > >> > > > > Is this only happening occuring when you reboot the server, or
> > > > > > > >> > > > > when you
> > > > > > > >> > > > > stop/start SQL Server once the server is running?
> > > > > > > >> > > > >
> > > > > > > >> > > > > John
> > > > > > > >> > > > >
> > > > > > > >> > > > > "dominique" wrote:
> > > > > > > >> > > > >
> > > > > > > >> > > > > > hi john,
> > > > > > > >> > > > > >
> > > > > > > >> > > > > > first of all, thank you for your answer.
> > > > > > > >> > > > > > i´m using the system account all the time.
> > > > > > > >> > > > > > i just tried your suggestion using a domain account for
> > > > > > > >> > > > > > starting the two
> > > > > > > >> > > > > > services and rebooted the server. now the events 103 are gone,
> > > > > > > >> > > > > > but i´m
> > > > > > > >> > > > > > getting two events 7000 service control manager:
> > > > > > > >> > > > > > (translation from german)
> > > > > > > >> > > > > > the "SQLAgent$SBSMONITORING" / "SQLSERVERAGENT" service failed
> > > > > > > >> > > > > > to start due
> > > > > > > >> > > > > > to the following error:
> > > > > > > >> > > > > > the accountname is incorrect or not existent, or the password
> > > > > > > >> > > > > > for the
> > > > > > > >> > > > > > accountname is incorrect.
> > > > > > > >> > > > > >
> > > > > > > >> > > > > > the account is a domain-admin account.
> > > > > > > >> > > > > >
> > > > > > > >> > > > > > when i tried to start the service manually it was successfull
> > > > > > > >> > > > > > again... ://
> > > > > > > >> > > > > >
> > > > > > > >> > > > > > i don´t understand it... :(
> > > > > > > >> > > > > >
> > > > > > > >> > > > > > any ideas?
> > > > > > > >> > > > > >
> > > > > > > >> > > > > > --
> > > > > > > >> > > > > > kind regards / liebe grüsse
> > > > > > > >> > > > > > dominique
> > > > > > > >> > > > > >
> > > > > > > >> > > > > >
> > > > > > > >> > > > > > "John Bell" wrote:
> > > > > > > >> > > > > >
> > > > > > > >> > > > > > > Hi
> > > > > > > >> > > > > > >
> > > > > > > >> > > > > > > This sounds like it can not authenticate the service account
> > > > > > > >> > > > > > > in the AD, have
> > > > > > > >> > > > > > > you tried setting it to the system account or to a different
> > > > > > > >> > > > > > > domain one?
> > > > > > > >> > > > > > >
> > > > > > > >> > > > > > > John
> > > > > > > >> > > > > > >
> > > > > > > >> > > > > > > "dominique" wrote:
> > > > > > > >> > > > > > >
> > > > > > > >> > > > > > > > hi @.all,
> > > > > > > >> > > > > > > >
> > > > > > > >> > > > > > > > when rebooting the sbs 2k3 server, first the service
> > > > > > > >> > > > > > > > sqlagent$sbsmonitoring
> > > > > > > >> > > > > > > > failes to start and then the sqlserveragent. both events
> > > > > > > >> > > > > > > > are record with the
> > > > > > > >> > > > > > > > event id 103:
> > > > > > > >> > > > > > > > sqlagent$sbsmonitoring:
> > > > > > > >> > > > > > > > SQLServerAgent could not be started (reason: Unable to
> > > > > > > >> > > > > > > > connect to server
> > > > > > > >> > > > > > > > "(sbs\sbsmonitoring)"; SQLServerAgent
> > > > > > > >> > > > > > > > cannot start).
> > > > > > > >> > > > > > > > sqlserveragent:
> > > > > > > >> > > > > > > > SQLServerAgent could not be started (reason: Unable to
> > > > > > > >> > > > > > > > connect to server
> > > > > > > >> > > > > > > > "(local)"; SQLServerAgent
> > > > > > > >> > > > > > > > cannot start).
> > > > > > > >> > > > > > > >
> > > > > > > >> > > > > > > > after searching the web i found an articel describing to
> > > > > > > >> > > > > > > > look for the
> > > > > > > >> > > > > > > > sqlagent.out file. i found two files in "microsoft sql
> > > > > > > >> > > > > > > > server\mssql\log" and
> > > > > > > >> > > > > > > > "microsoft sql server\mssql$sbsmonitoring". both have the
> > > > > > > >> > > > > > > > error "Cannot
> > > > > > > >> > > > > > > > Generate SSPI Context".
> > > > > > > >> > > > > > > >
> > > > > > > >> > > > > > > > when i start the services manually it works fine, but NOT
> > > > > > > >> > > > > > > > on startup... i
> > > > > > > >> > > > > > > > even searched the kb from ms, but didn´t find anything that
> > > > > > > >> > > > > > > > helped me.
> > > > > > > >> > > > > > > >
> > > > > > > >> > > > > > > > even if i set the services to start over if an error
> > > > > > > >> > > > > > > > occure, it doesn´t
> > > > > > > >> > > > > > > > work. only if i start the services manually... :(
> > > > > > > >> > > > > > > > the services are set to start with the local system
> > > > > > > >> > > > > > > > account.
> > > > > > > >> > > > > > > >
> > > > > > > >> > > > > > > > i don´t have any knowledge from a sql server. can somebody
> > > > > > > >> > > > > > > > please help me!
> > > > > > > >> > > > > > > >
> > > > > > > >> > > > > > > > --
> > > > > > > >> > > > > > > > kind regards / liebe grüsse
> > > > > > > >> > > > > > > > dominique
> > > > > > > >>
> > > > > > > >>
> > > > > > >
> > > > > > >
> > > > > > >|||Hi
Looking back through the thread I realise I have already suggested to change
the account. I did find
http://tinyurl.com/g3jly and http://tinyurl.com/g8k4c
John
"dominique" wrote:
> hi john,
> well they are running both under the local system. i think i tried changing
> it to an (admin)user and the result was the same. service is not able to
> start. but i´m gonna test it next week and tell you.
> thank you for your help so far :) thank you, thank you, thank you :)
> --
> kind regards / liebe grüsse
> dominique
>
> "John Bell" wrote:
> > Hi
> >
> > Are these two services running under the same user? If they are then try
> > changing them to a different one.
> >
> > John
> >
> > "dominique" wrote:
> >
> > > hi john,
> > >
> > > sorry my fault. the sql server agent service is running only on the two
> > > instances (sbsmonitoring and local) and the start up type for the other
> > > instances is allready manual.
> > >
> > > --
> > > kind regards / liebe grüsse
> > > dominique
> > >
> > >
> > > "John Bell" wrote:
> > >
> > > > Hi
> > > >
> > > > Have you stopped the SQL Server Agent service for the instances where you
> > > > don't want it to run? Try changing the start up type to manual.
> > > >
> > > > John
> > > >
> > > >
> > > > "dominique" wrote:
> > > >
> > > > > hi john,
> > > > >
> > > > > there are multiple instances running.
> > > > > backup exec, msfw (isa), sbsmonitoring and sharepoint. but the
> > > > > sqlserveragent is only needed for sbsmonitoring and local.
> > > > >
> > > > > Did that answer your question? :/
> > > > >
> > > > > thanks again for your help :)
> > > > >
> > > > > --
> > > > > kind regards / liebe grüsse
> > > > > dominique
> > > > >
> > > > >
> > > > > "John Bell" wrote:
> > > > >
> > > > > > Hi
> > > > > >
> > > > > > You can install multiple instances on a single server, if you run the
> > > > > > command NET START from a command prompt you may have multiple instances that
> > > > > > are either like MSSQLSERVER or MSQL$INSTANCE.
> > > > > >
> > > > > > John
> > > > > >
> > > > > > "dominique" wrote:
> > > > > >
> > > > > > > hi john,
> > > > > > >
> > > > > > > no, not that i know. i´m running only one sql server.
> > > > > > >
> > > > > > > i´m sorry, but i don´t understand your question. what instance do you mean?
> > > > > > > the sbsmonitoring?
> > > > > > > --
> > > > > > > kind regards / liebe grüsse
> > > > > > > dominique
> > > > > > >
> > > > > > >
> > > > > > > "John Bell" wrote:
> > > > > > >
> > > > > > > > Hi
> > > > > > > >
> > > > > > > > Are you running two copies of SQL Server on this server? If this instance is
> > > > > > > > the default then it would be the same as (local).
> > > > > > > >
> > > > > > > > John
> > > > > > > >
> > > > > > > > "dominique" <dominique@.discussions.microsoft.com> wrote in message
> > > > > > > > news:E0C60EA7-62C6-4146-90A8-21E76083B9AD@.microsoft.com...
> > > > > > > > > hi john,
> > > > > > > > >
> > > > > > > > > i tried the following now:
> > > > > > > > >
> > > > > > > > > after reading the kb i changed the authentification for the sqlserveragent
> > > > > > > > > (local) to sql authentification and that worked! :)
> > > > > > > > > now the sqlserveragent (local) is starting, but i´m still getting the
> > > > > > > > > event
> > > > > > > > > 103 on sqlagent$sbsmonitoring. i changed the authentification for the
> > > > > > > > > sqlserveragent too, but that didn´t worked. i´m only able to start the
> > > > > > > > > sqlserveragent when windows authentification is enabled... :( :( :(
> > > > > > > > >
> > > > > > > > > any other suggestions? ://
> > > > > > > > >
> > > > > > > > > --
> > > > > > > > > kind regards / liebe grüsse
> > > > > > > > > dominique
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > "John Bell" wrote:
> > > > > > > > >
> > > > > > > > >> Hi
> > > > > > > > >>
> > > > > > > > >> Make sure that the SQLServerAgent service is dependent on the SQL
> > > > > > > > >> Server service in the Services Applet.
> > > > > > > > >>
> > > > > > > > >> Also you may want to check out http://support.microsoft.com/kb/811889/
> > > > > > > > >>
> > > > > > > > >> "Cannot Generate SSPI Context" is an issue authenticating the service
> > > > > > > > >> account with AD not SQL Server, but as this seems to work once you are
> > > > > > > > >> allowed to log in, it would indicate that either something has started
> > > > > > > > >> at the time the service wishes to authenticate or something is stopping
> > > > > > > > >> the authentication happening, which is resolved by the time you can log
> > > > > > > > >> in.
> > > > > > > > >>
> > > > > > > > >> John
> > > > > > > > >>
> > > > > > > > >> dominique wrote:
> > > > > > > > >> > hi john,
> > > > > > > > >> >
> > > > > > > > >> > thanks for trying to resolve my problem, i really apreciate this :))
> > > > > > > > >> >
> > > > > > > > >> > hm... is the sql server service starting too early or too late?
> > > > > > > > >> > remember the
> > > > > > > > >> > event:
> > > > > > > > >> > could not be started (reason: Unable to connect to server "(local)";
> > > > > > > > >> > SQLServerAgent
> > > > > > > > >> >
> > > > > > > > >> > how can i check to see if the network services are taking too long to
> > > > > > > > >> > start?
> > > > > > > > >> > the network card is working fine, no problems or events here.
> > > > > > > > >> >
> > > > > > > > >> > the server needs a pretty long time to boot, but it is a sbs, so he´s
> > > > > > > > >> > got a
> > > > > > > > >> > lot of work to do, when booting :/ i thought this is "normal".
> > > > > > > > >> >
> > > > > > > > >> > how can i make the SQLServer dependent on another service?
> > > > > > > > >> >
> > > > > > > > >> > i don´t have any software firewall running... isa is running only as a
> > > > > > > > >> > proxy.
> > > > > > > > >> >
> > > > > > > > >> > --
> > > > > > > > >> > kind regards / liebe grüsse
> > > > > > > > >> > dominique
> > > > > > > > >> >
> > > > > > > > >> >
> > > > > > > > >> > "John Bell" wrote:
> > > > > > > > >> >
> > > > > > > > >> > > Hi dominique
> > > > > > > > >> > >
> > > > > > > > >> > > If this is only on re-boot then it sounds like SQL Server service is
> > > > > > > > >> > > starting too early. You may want to check to see if the network
> > > > > > > > >> > > services are
> > > > > > > > >> > > taking too long to start or possibly there may be a problem with the
> > > > > > > > >> > > network
> > > > > > > > >> > > card. If you can make SQLServer dependent another service (say
> > > > > > > > >> > > computer
> > > > > > > > >> > > browser) then it may delay things for long enough. If you have a
> > > > > > > > >> > > software
> > > > > > > > >> > > firewall running, check to see how long this takes to start up.
> > > > > > > > >> > >
> > > > > > > > >> > > John
> > > > > > > > >> > >
> > > > > > > > >> > > "dominique" wrote:
> > > > > > > > >> > >
> > > > > > > > >> > > > hi,
> > > > > > > > >> > > >
> > > > > > > > >> > > > no only on reboot, that´s why it´s so strange...
> > > > > > > > >> > > >
> > > > > > > > >> > > > i just tested it again. when i stop the sql server the
> > > > > > > > >> > > > sqlserveragent is
> > > > > > > > >> > > > stopping too. when i start the sql server i´m able to start the
> > > > > > > > >> > > > sqlserveragent (right now with the domain account). but i´m able to
> > > > > > > > >> > > > start the
> > > > > > > > >> > > > sqlserveragent with the system account too.
> > > > > > > > >> > > >
> > > > > > > > >> > > > only on reboot / startup the services are not starting with the
> > > > > > > > >> > > > below events.
> > > > > > > > >> > > >
> > > > > > > > >> > > > i´m desperate :(
> > > > > > > > >> > > >
> > > > > > > > >> > > > --
> > > > > > > > >> > > > kind regards / liebe grüsse
> > > > > > > > >> > > > dominique
> > > > > > > > >> > > >
> > > > > > > > >> > > >
> > > > > > > > >> > > > "John Bell" wrote:
> > > > > > > > >> > > >
> > > > > > > > >> > > > > Hi
> > > > > > > > >> > > > >
> > > > > > > > >> > > > > Is this only happening occuring when you reboot the server, or
> > > > > > > > >> > > > > when you
> > > > > > > > >> > > > > stop/start SQL Server once the server is running?
> > > > > > > > >> > > > >
> > > > > > > > >> > > > > John
> > > > > > > > >> > > > >
> > > > > > > > >> > > > > "dominique" wrote:
> > > > > > > > >> > > > >
> > > > > > > > >> > > > > > hi john,
> > > > > > > > >> > > > > >
> > > > > > > > >> > > > > > first of all, thank you for your answer.
> > > > > > > > >> > > > > > i´m using the system account all the time.
> > > > > > > > >> > > > > > i just tried your suggestion using a domain account for
> > > > > > > > >> > > > > > starting the two
> > > > > > > > >> > > > > > services and rebooted the server. now the events 103 are gone,
> > > > > > > > >> > > > > > but i´m
> > > > > > > > >> > > > > > getting two events 7000 service control manager:
> > > > > > > > >> > > > > > (translation from german)
> > > > > > > > >> > > > > > the "SQLAgent$SBSMONITORING" / "SQLSERVERAGENT" service failed
> > > > > > > > >> > > > > > to start due
> > > > > > > > >> > > > > > to the following error:
> > > > > > > > >> > > > > > the accountname is incorrect or not existent, or the password
> > > > > > > > >> > > > > > for the
> > > > > > > > >> > > > > > accountname is incorrect.
> > > > > > > > >> > > > > >
> > > > > > > > >> > > > > > the account is a domain-admin account.
> > > > > > > > >> > > > > >
> > > > > > > > >> > > > > > when i tried to start the service manually it was successfull
> > > > > > > > >> > > > > > again... ://
> > > > > > > > >> > > > > >
> > > > > > > > >> > > > > > i don´t understand it... :(
> > > > > > > > >> > > > > >
> > > > > > > > >> > > > > > any ideas?
> > > > > > > > >> > > > > >
> > > > > > > > >> > > > > > --
> > > > > > > > >> > > > > > kind regards / liebe grüsse
> > > > > > > > >> > > > > > dominique
> > > > > > > > >> > > > > >
> > > > > > > > >> > > > > >
> > > > > > > > >> > > > > > "John Bell" wrote:
> > > > > > > > >> > > > > >
> > > > > > > > >> > > > > > > Hi
> > > > > > > > >> > > > > > >
> > > > > > > > >> > > > > > > This sounds like it can not authenticate the service account
> > > > > > > > >> > > > > > > in the AD, have
> > > > > > > > >> > > > > > > you tried setting it to the system account or to a different
> > > > > > > > >> > > > > > > domain one?
> > > > > > > > >> > > > > > >
> > > > > > > > >> > > > > > > John
> > > > > > > > >> > > > > > >
> > > > > > > > >> > > > > > > "dominique" wrote:
> > > > > > > > >> > > > > > >
> > > > > > > > >> > > > > > > > hi @.all,
> > > > > > > > >> > > > > > > >
> > > > > > > > >> > > > > > > > when rebooting the sbs 2k3 server, first the service
> > > > > > > > >> > > > > > > > sqlagent$sbsmonitoring
> > > > > > > > >> > > > > > > > failes to start and then the sqlserveragent. both events
> > > > > > > > >> > > > > > > > are record with the
> > > > > > > > >> > > > > > > > event id 103:
> > > > > > > > >> > > > > > > > sqlagent$sbsmonitoring:
> > > > > > > > >> > > > > > > > SQLServerAgent could not be started (reason: Unable to
> > > > > > > > >> > > > > > > > connect to server
> > > > > > > > >> > > > > > > > "(sbs\sbsmonitoring)"; SQLServerAgent
> > > > > > > > >> > > > > > > > cannot start).
> > > > > > > > >> > > > > > > > sqlserveragent:
> > > > > > > > >> > > > > > > > SQLServerAgent could not be started (reason: Unable to
> > > > > > > > >> > > > > > > > connect to server
> > > > > > > > >> > > > > > > > "(local)"; SQLServerAgent
> > > > > > > > >> > > > > > > > cannot start).
> > > > > > > > >> > > > > > > >
> > > > > > > > >> > > > > > > > after searching the web i found an articel describing to
> > > > > > > > >> > > > > > > > look for the
> > > > > > > > >> > > > > > > > sqlagent.out file. i found two files in "microsoft sql
> > > > > > > > >> > > > > > > > server\mssql\log" and
> > > > > > > > >> > > > > > > > "microsoft sql server\mssql$sbsmonitoring". both have the
> > > > > > > > >> > > > > > > > error "Cannot
> > > > > > > > >> > > > > > > > Generate SSPI Context".
> > > > > > > > >> > > > > > > >
> > > > > > > > >> > > > > > > > when i start the services manually it works fine, but NOT
> > > > > > > > >> > > > > > > > on startup... i
> > > > > > > > >> > > > > > > > even searched the kb from ms, but didn´t find anything that
> > > > > > > > >> > > > > > > > helped me.
> > > > > > > > >> > > > > > > >
> > > > > > > > >> > > > > > > > even if i set the services to start over if an error
> > > > > > > > >> > > > > > > > occure, it doesn´t
> > > > > > > > >> > > > > > > > work. only if i start the services manually... :(
> > > > > > > > >> > > > > > > > the services are set to start with the local system
> > > > > > > > >> > > > > > > > account.
> > > > > > > > >> > > > > > > >
> > > > > > > > >> > > > > > > > i don´t have any knowledge from a sql server. can somebody
> > > > > > > > >> > > > > > > > please help me!
> > > > > > > > >> > > > > > > >
> > > > > > > > >> > > > > > > > --
> > > > > > > > >> > > > > > > > kind regards / liebe grüsse
> > > > > > > > >> > > > > > > > dominique

No comments:

Post a Comment