| Jasper Smith 2002-08-14, 7:23 am |
| My guess would be sp_sqlagent_has_server_access
or more specifically its call to xp_logininfo.
When we ran SQL7 SP2 we occasionally had problems
when the PDC would go down and even though the BDC
was online and all network access was fine for file
and print and SQL access, jobs owned by an NT account
would fail, changing these jobs to run under SQL account
allowed them to run. I believe xp_logininfo has always
been a bit buggy on NT4 anyway and it certainly didn't
like the PDC being down. Since SQL agent calls it during
the Inital Boot Probe part of its startup i'd guess it
might be hanging or otherwise throwing and error that
the service control manager is picking up. Just a guess
but that's were I'd put my money :-)
HTH
Jasper Smith
>-----Original Message-----
>Hi,
>
>Using SQL7SP3 on Win NT4 Server SP6a.
>
>We did a disaster recovery test last week and switched
off
>our main site. We failed over to the DR site where we had
>a BDC providing authentication. The PDC was unavailable.
>After much bottom-clenching and nail-biting, we found
that
>SQLServerAgent would not start on one of our SQL Servers.
>When clicking start in Control Panel-->Services, we got
>this error:
>
>"Error 2186: The service is not responding to the control
>function."
>
>I cleared the mail profile and stopped sql server and
>sqlagent and I got the same message. I rebooted the
server
>a couple of times to no avail. We then needed to open a
>pinhole in the firewall so that the PDC was visiable and
>SQLServerAgent started. I'm not sure if this is a
>coincidence or whether it's related. Has anyone else got
>an explanation? The SQLAgent service used the same domain
>account with local admin rights as the MSSQLServer
service
>and I could start and stop MSSQLServer with no problems.
>
>The PDC was since removed from the network and SQLAgent
>continued to run - however I did not stop and restart it
>to test whether the statup process was to blame. All our
>other SQL Servers did not experience this problem.
>
>Can anyone shed any light on this?
>
>Thanks,
>Mark.
>
>____________________________
>Mark Allison, SQL Server DBA
>Tel: +44 (0) 207 971 5894
>
>.
>
|