All DB maintenance plans fail

MS SQL 2000 SP3 on a Windows 2003 SP1 Server. Both SQL services are running
under an Administrator account. The database maintenance plans to backup
the server databases were also created when that account was logged onto the
server.
When I originally setup the maintenance plan backups with the wizard they
worked fine, but now they do not. I have repeatedly deleted them and tried
other domain admin accounts and local admin accounts without any luck. When
I review the log under the jobs it says access denied. I have attached the
DB Maintenace Plan......txt log data to show what it is recording.
===========================
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'DATABASE' as 'MYDOMAIN\Administrator' (trusted)
Starting maintenance plan 'DB Maintenance Plan' on 10/3/2006 9:06:04 AM
[1] Database Manufacturing Tracking: Check Data and Index Linkage...
** Execution Time: 0 hrs, 0 mins, 54 secs **
[2] Database Northwind: Check Data and Index Linkage...
** Execution Time: 0 hrs, 0 mins, 1 secs **
[3] Database pubs: Check Data and Index Linkage...
** Execution Time: 0 hrs, 0 mins, 1 secs **
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft]&#
91;ODBC SQL
Server Driver][SQL Server]Database state cannot be changed while other u
sers
are using the database 'QualityProposed'
[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE st
atement
failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption comma
nd failed.
[4] Database QualityProposed: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft]&#
91;ODBC SQL
Server Driver][SQL Server]Repair statement not processed. Database needs
to
be in single user mode.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement
not
processed. Database needs to be in single user mode.
** Execution Time: 0 hrs, 0 mins, 1 secs **
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft]&#
91;ODBC SQL
Server Driver][SQL Server]Database state cannot be changed while other u
sers
are using the database 'QualityTracking'
[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE st
atement
failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption comma
nd failed.
[5] Database QualityTracking: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft]&#
91;ODBC SQL
Server Driver][SQL Server]Repair statement not processed. Database needs
to
be in single user mode.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement
not
processed. Database needs to be in single user mode.
** Execution Time: 0 hrs, 0 mins, 1 secs **
[6] Database Manufacturing Tracking: Database Backup...
Destination: [\\.\Tape0]
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3279: [Microsoft]&#
91;ODBC SQL
Server Driver][SQL Server]Access is denied due to a password failure
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE i
s
terminating abnormally.
[7] Database Northwind: Database Backup...
Destination: [\\.\Tape0]
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3279: [Microsoft]&#
91;ODBC SQL
Server Driver][SQL Server]Access is denied due to a password failure
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE i
s
terminating abnormally.
[8] Database pubs: Database Backup...
Destination: [\\.\Tape0]
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3279: [Microsoft]&#
91;ODBC SQL
Server Driver][SQL Server]Access is denied due to a password failure
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE i
s
terminating abnormally.
[9] Database QualityProposed: Database Backup...
The backup was not performed since data verification errors were found.
[10] Database QualityTracking: Database Backup...
The backup was not performed since data verification errors were found.
Deleting old text reports... 0 file(s) deleted.
End of maintenance plan 'DB Maintenance Plan' on 10/3/2006 9:08:02 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)Jordon,
Sounds like you are trying to put the database into single user mode which
it doesn't like.
Remove the Check Database Integrity option and you can run the Backup,
Re-index and re-calc stats elements in multi user mode.
Cheers
Andy
"Jordan" <none@.here.com> wrote in message
news:OjgzTJ05GHA.696@.TK2MSFTNGP06.phx.gbl...
> MS SQL 2000 SP3 on a Windows 2003 SP1 Server. Both SQL services are
> running under an Administrator account. The database maintenance plans to
> backup the server databases were also created when that account was logged
> onto the server.
> When I originally setup the maintenance plan backups with the wizard they
> worked fine, but now they do not. I have repeatedly deleted them and
> tried other domain admin accounts and local admin accounts without any
> luck. When I review the log under the jobs it says access denied. I have
> attached the DB Maintenace Plan......txt log data to show what it is
> recording.
>
> ===========================
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'DATABASE' as 'MYDOMAIN\Administrator' (trusted)
> Starting maintenance plan 'DB Maintenance Plan' on 10/3/2006 9:06:04 AM
> [1] Database Manufacturing Tracking: Check Data and Index Linkage...
> ** Execution Time: 0 hrs, 0 mins, 54 secs **
> [2] Database Northwind: Check Data and Index Linkage...
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> [3] Database pubs: Check Data and Index Linkage...
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft]
[ODBC
> SQL Server Driver][SQL Server]Database state cannot be changed while o
ther
> users are using the database 'QualityProposed'
> [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE
statement
> failed.
> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption com
mand failed.
> [4] Database QualityProposed: Check Data and Index Linkage...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft]
[ODBC
> SQL Server Driver][SQL Server]Repair statement not processed. Database
> needs to be in single user mode.
> The following errors were found:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statemen
t not
> processed. Database needs to be in single user mode.
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft]
[ODBC
> SQL Server Driver][SQL Server]Database state cannot be changed while o
ther
> users are using the database 'QualityTracking'
> [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE
statement
> failed.
> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption com
mand failed.
> [5] Database QualityTracking: Check Data and Index Linkage...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft]
[ODBC
> SQL Server Driver][SQL Server]Repair statement not processed. Database
> needs to be in single user mode.
> The following errors were found:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statemen
t not
> processed. Database needs to be in single user mode.
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> [6] Database Manufacturing Tracking: Database Backup...
> Destination: [\\.\Tape0]
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3279: [Microsoft]
[ODBC
> SQL Server Driver][SQL Server]Access is denied due to a password failu
re
> [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE
is
> terminating abnormally.
> [7] Database Northwind: Database Backup...
> Destination: [\\.\Tape0]
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3279: [Microsoft]
[ODBC
> SQL Server Driver][SQL Server]Access is denied due to a password failu
re
> [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE
is
> terminating abnormally.
> [8] Database pubs: Database Backup...
> Destination: [\\.\Tape0]
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3279: [Microsoft]
[ODBC
> SQL Server Driver][SQL Server]Access is denied due to a password failu
re
> [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE
is
> terminating abnormally.
> [9] Database QualityProposed: Database Backup...
> The backup was not performed since data verification errors were found.
> [10] Database QualityTracking: Database Backup...
> The backup was not performed since data verification errors were found.
> Deleting old text reports... 0 file(s) deleted.
> End of maintenance plan 'DB Maintenance Plan' on 10/3/2006 9:08:02 AM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>|||I have also tried to break up all the actions into single jobs. For
instance on the backups I had the maintenance schedule just backup the
non-system databases at 2 in the morning and they still failed.
"Andrew Copeland" <andycuk@.community.nospam> wrote in message
news:%23oH4ud05GHA.4608@.TK2MSFTNGP03.phx.gbl...
> Jordon,
> Sounds like you are trying to put the database into single user mode which
> it doesn't like.
> Remove the Check Database Integrity option and you can run the Backup,
> Re-index and re-calc stats elements in multi user mode.
> Cheers
> Andy
> "Jordan" <none@.here.com> wrote in message
> news:OjgzTJ05GHA.696@.TK2MSFTNGP06.phx.gbl...
>|||Jordon,
Your order database is still in use so you really need to ensure that all
actions are stopped as the ALTER DATABASE command issued here needs to
change the database into single user mode.
Can you check the monitor to see what is using the database out of hours?
Regards
Andy
"Jordan" <none@.here.com> wrote in message
news:e4YwwaB6GHA.3732@.TK2MSFTNGP05.phx.gbl...
>I have also tried to break up all the actions into single jobs. For
>instance on the backups I had the maintenance schedule just backup the
>non-system databases at 2 in the morning and they still failed.
>
> "Andrew Copeland" <andycuk@.community.nospam> wrote in message
> news:%23oH4ud05GHA.4608@.TK2MSFTNGP03.phx.gbl...
>|||I managed to track it down to the owner name on the tasks being
Administrator@.mydomain.com rather than MYDOMAIN\Administror.
The funny thing is that the services start as MYDOMAIN\Administrator and I
log in as that to manage maintenace plans but the individual tasks in the
plan all have that @.mydomain.com user. Changing these to the x\x format
took care of the problem
Thanks .
"Andrew Copeland" <andycuk@.community.nospam> wrote in message
news:eUkdSfT6GHA.4132@.TK2MSFTNGP05.phx.gbl...
> Jordon,
> Your order database is still in use so you really need to ensure that all
> actions are stopped as the ALTER DATABASE command issued here needs to
> change the database into single user mode.
> Can you check the monitor to see what is using the database out of hours?
> Regards
> Andy
> "Jordan" <none@.here.com> wrote in message
> news:e4YwwaB6GHA.3732@.TK2MSFTNGP05.phx.gbl...
>