SBS2003 Standard Edition SQLMonitoring Event ID 208 Error

Written by James McDonald

April 13, 2010

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.

You May Also Like…

Squarespace Image Export

To gain continued access to your Squarespace website images after cancelling your subscription you have several...

MySQL 8.x GRANT ALL STATEMENT

-- CREATE CREATE USER 'tgnrestoreuser'@'localhost' IDENTIFIED BY 'AppleSauceLoveBird2024'; GRANT ALL PRIVILEGES ON...

Exetel Opt-Out of CGNAT

If your port forwards and inbound and/or outbound site-to-site VPN's have failed when switching to Exetel due to their...