SBS2003 Standard Edition SQLMonitoring Event ID 208 Error

Problem: Event Type: Warning Event…

Login

Blog History

Problem:
Event Type: Warning
Event Source: SQLAgent$SBSMONITORING
Event Category: Job Engine
Event ID: 208
Date: 13/04/2010
Time: 3:00:00 AM
User: N/A
Computer: APF-MA-DC01
Description:
SQL Server Scheduled Job 'SBS_Database_Cleanup' (0xCFE15C1485482B4AB05D5AA0CE0721D1) - Status: Failed - Invoked on: 2010-04-13 03:00:00 - Message: The job failed. Unable to determine if the owner (MYDOMAIN\oldaccount) of job SBS_Database_Cleanup has server access (reason: Could not obtain information about Windows NT group/user 'MYDOMAIN\oldaccount'. [SQLSTATE 42000] (Error 8198)).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp

.
Fix:

Login to the correct instance of SQL using osql.exe (try -U sa and a password or -E to authenticate as your currently logged in account)
osql -E -S SBSSERVER\SBSMonitoring

USE [msdb]
GO
EXEC msdb.dbo.sp_update_job @job_name=N'SBS_Database_Cleanup',
@owner_login_name=N'DOMAIN\ThenewOwner'
GO

Cause:
This was caused due to me renaming an admin account. When the SQL Agent ran the job it couldn't find the account in AD and so failed to run it.

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The reCAPTCHA verification period has expired. Please reload the page.