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
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'
RESTORE VERIFYONLY FROM TAPE = N'\\.\Tape0' WITH FILE = @i
Magda
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....
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.
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.
ASKER
The SQL Server Agent is logged in as Administrator and all jobs run fine except for that
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.
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.
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.