Various sites/servers this is happening.
Start Server AGent
Schedule a DTS to run nightly.
Come back a few days later
SQL SA is stopped
the job never ran
When this first happened I checked the props of SQLSA
and found the "Auto - Restart SQL Server on failure" and "A-R SQL SA..." check boxes.
Checked them.
Come back a few days later. Same results
When I view the jobs in SQL SA- Jobs area those jobs failed for the inimitable
sqlstate 42000 error 8198 "... if the owner
(server\administrator) of job Nightly Update has server access (reason: Could
not obtain information about ... 'server\administrator'.
Yes, the adminitrator. Now I've changed the owner of the jobs to
sa. I'm afraid to presume that sa is powerful enough to stand up to SQL authentication if the admin can't (smirk)
Does anyone have any insights? would the 8198 cause SA to stop? Why would a subordinate job stop SA?
if the sub-job can stop it why doesn't it restart as told to in the properties?
thanks, Bryan
Hi Bryan,
An 8198 error is normally raised when process executed within SQL Server or
from the SQL Server Agent, such as the "xp_logininfo" stored procedure, a
scheduled job, or a replication agent, needs to verify the credentials of a
Windows-authenticated login. The attempt to retrieve those credentials on
the domain failed for an unspecified reason
Please take a look at article
http://support.microsoft.com/default...b;en-us;883551 that talks
about some of the reasons for the 8198 error that you are getting.
Hope that helps !!!
Fargham
No comments:
Post a Comment