"Scott" <sbai***@mileslumber.com> wrote in message
news:Owf95XhwGHA.1624@TK2MSFTNGP02.phx.gbl...
> When I create a backup job and schedule it, I get the below error. I can
> create the job and run it immediately fine. But if I try to schedule it, I
> get this error. This is Win 2003 Standard SP1 and SQL 2000 SP4. I also use
> Mixed Mode security model. I'm also creating and running logged in as
> Administrator.
>
> Can someone explain this error?
>
>
> EVENT LOG:
>
> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Job Engine
> Event ID: 208
> Date:  8/17/2006
> Time:  10:11:01 AM
> User:  N/A
> Computer: MYSERVER
>
>
> Description:
> SQL Server Scheduled Job 'Backup my_database'
> (0x3E62953E66C7704E95203DB62AA0FEB1) -
> Status: Failed - Invoked on: 2006-08-17 10:11:00 -
> Message: The job failed.  Unable to determine if the owner
> (myDomain\Administrator) of
> job Backup my_database has server access (reason: Could not obtain
> information about
> Windows NT group/user 'myDomain\Administrator'. [SQLSTATE 42000] (Error
> 8198)). For more
> information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>

"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:OkIwHZhwGHA.1888@TK2MSFTNGP03.phx.gbl...
> Maybe the server can't connect to the domain controller to determine
> windows authentication.
>
> Have you tried setting the owner of the job to sa or local system?
>
>
>
>
>
> "Scott" <sbai***@mileslumber.com> wrote in message
> news:Owf95XhwGHA.1624@TK2MSFTNGP02.phx.gbl...
>> When I create a backup job and schedule it, I get the below error. I can
>> create the job and run it immediately fine. But if I try to schedule it,
>> I get this error. This is Win 2003 Standard SP1 and SQL 2000 SP4. I also
>> use Mixed Mode security model. I'm also creating and running logged in as
>> Administrator.
>>
>> Can someone explain this error?
>>
>>
>> EVENT LOG:
>>
>> Event Type: Warning
>> Event Source: SQLSERVERAGENT
>> Event Category: Job Engine
>> Event ID: 208
>> Date:  8/17/2006
>> Time:  10:11:01 AM
>> User:  N/A
>> Computer: MYSERVER
>>
>>
>> Description:
>> SQL Server Scheduled Job 'Backup my_database'
>> (0x3E62953E66C7704E95203DB62AA0FEB1) -
>> Status: Failed - Invoked on: 2006-08-17 10:11:00 -
>> Message: The job failed.  Unable to determine if the owner
>> (myDomain\Administrator) of
>> job Backup my_database has server access (reason: Could not obtain
>> information about
>> Windows NT group/user 'myDomain\Administrator'. [SQLSTATE 42000] (Error
>> 8198)). For more
>> information, see Help and Support Center at
>> http://go.microsoft.com/fwlink/events.asp.
>>
>
>

"Scott" <sbai***@mileslumber.com> wrote in message
news:Ok2vLskwGHA.2400@TK2MSFTNGP06.phx.gbl...
> thanks. sa worked, but why will sql allow running a job immediately using
> admin account, but not when scheduled using the administrator account?