Very Computer

by **Steve Foster [SBS MVP** » Sat, 29 May 2004 22:29:37

> I have recently setup SBS2003. I am attempteing to setup a scheduled
> database backup throught the Database Maintenance Plan and for some
> reason It bombs. I think there is something simple that I am
> overlooking. Any Ideas?

> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Job Engine
> Event ID: 208
> Date: 5/26/2004
> Time: 8:09:00 AM
> User: N/A
> Computer: TL0
> Description:
> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
> Maintenance Plan1'' (0x6ED3623DF2F29F41B9D5F78CC0F49953) - Status:
> Failed - Invoked on: 2004-05-26 08:09:00 - Message: The job failed.
> Unable to determine if the owner (TL0\Administrator) of job DB Backup
> Job for DB Maintenance Plan 'DB Maintenance Plan1' has server access
> (reason: Could not obtain information about Windows NT group/user
> 'TL0\Administrator'. [SQLSTATE 42000] (Error 8198)).

Have you been working on SQL security lately? Removed the
BUILTIN\Administrators group from the Logins perhaps?

--
Steve Foster [SBS MVP]
---------------------------------------
MVPs do not work for Microsoft. Please reply only to the newsgroups.

Very Computer

SQL Database maintenance plan

SQL Database maintenance plan