schedule backup job

Hi,
I have assigned a backupoperation role to a user and try to
schedule a backup job with this user. But it won't run at all and there is a
warning message in application event log as following:
"SQL Server Scheduled Job 'HRISPROD backup Tues'
(0x23C034EB3B83734487481D0F623D3309) - Status: Failed - Invoked on:
2004-05-18 08:35:01 - Message: The job failed. Unable to determine if the
owner (csdbackup) of job HRISPROD backup Tues has server access (reason:
Unable to connect to server - check SQL Server and SQL Server Agent
errorlogs). "
But I can do the backup manually with this login. Please help. Many thanks.
Hi,
Can you restart your SQL Server and SQL Agent service and try executing the
job again.
If the service is not getting started then , reissue the password in the
control - panel -- services -- Log on option and start the service. I feel
that there is some issues in the service.
Thanks
Hari
MCDBA
"00Allen Iverson" <no_spam@.bk.com> wrote in message
news:#qMQDkJPEHA.904@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have assigned a backupoperation role to a user and try to
> schedule a backup job with this user. But it won't run at all and there is
a
> warning message in application event log as following:
> "SQL Server Scheduled Job 'HRISPROD backup Tues'
> (0x23C034EB3B83734487481D0F623D3309) - Status: Failed - Invoked on:
> 2004-05-18 08:35:01 - Message: The job failed. Unable to determine if the
> owner (csdbackup) of job HRISPROD backup Tues has server access (reason:
> Unable to connect to server - check SQL Server and SQL Server Agent
> errorlogs). "
>
> But I can do the backup manually with this login. Please help. Many
thanks.
>