Link to home
Start Free TrialLog in
Avatar of mbanuet
mbanuet

asked on

Error 3279 "Access is denied due to a password failure" while running job

I  have a job that creates backups on a tape media and it was running fine until 2 days ago when it started to fail. This is the message on the job history:

    The job failed.  The Job was invoked by User sa.  The last step to run was step 1 (MSPAPELERA).  The job was requested to start at step 1 (MSPAPELERA).

    Executed as user: DIAGW2K2\Administrator. Access is denied due to a password failure [SQLSTATE 42000] (Error 3279)  BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013)  Associated statement is not prepared [SQLSTATE HY007] (Error 0)  Access is denied due to a password failure [SQLSTATE 42000] (Error 3279)  VERIFY DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013).  The step failed.

I changed the job's owner to sa and to DIAGW2K2\Administrator but I still get the same error. I'm not using any kind of passwords to protect the tape.

This is the SQL Statement of Step1:

BACKUP DATABASE [MSPAPELERA] TO  TAPE = N'\\.\Tape0' WITH  INIT ,  NOUNLOAD ,  NAME = N'MSPAPELERA backup CINTA',  NOSKIP ,  STATS = 10,  NOFORMAT DECLARE @i INT
select @i = position from msdb..backupset where database_name='MSPAPELERA'and type!='F' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name='MSPAPELERA')
RESTORE VERIFYONLY FROM   TAPE = N'\\.\Tape0'  WITH FILE = @i


Magda
Avatar of arbert
arbert

When you changed the owner of the job, did you change it while you were connected as SA?  If you change the owner of a job and you don't have admin rights, the job will SHOW the owner you changed it to, but the job will only run with the permissions of the creator of the job....
Avatar of mbanuet

ASKER

I'm connected with Enterprise Manger on the local server and I'm logged on as Administrator on Windows.

I already deleted the job and created it again and I'm still having the same problem.
Set "SQL Server Agent" service login to an user account with administrative rights.

Avatar of mbanuet

ASKER

The SQL Server Agent is logged in as Administrator and all jobs run fine except for that
Avatar of mbanuet

ASKER

I changed the SQL Server Agent to log in as an Administrator account but I'm still getting the error:

The job failed.  The Job was invoked by User PNL\Administrador.  The last step to run was step 1 (MSPAPELERA).  The job was requested to start at step 1 (MSPAPELERA).

Executed as user: PNL\Administrador. Access is denied due to a password failure [SQLSTATE 42000] (Error 3279)  BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013)  Associated statement is not prepared [SQLSTATE HY007] (Error 0)  Access is denied due to a password failure [SQLSTATE 42000] (Error 3279)  VERIFY DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013).  The step failed.
Avatar of mbanuet

ASKER

Ok, after changing the owners and log in accounts of the sql services I still had the same problem...

Then I remembered about an error we got some time ago with another tape drive unit, it was another error code but we fixed it by cleaning the drive more often so I went for our cleaning cartridge and after that, when I ran the job with another data cartridge it was perfect.

The error is gone now :D
ASKER CERTIFIED SOLUTION
Avatar of Computer101
Computer101
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial