Odd permissions issue with restore

Jeff Randall

Running the following:
master..sqlbackup N'-SQL "RESTORE DATABASE [ic001CommonPrd]
FROM DISK = ''D:\SQLBackups\FULL_PILS_ic001CommonPrd_20061206_020022.sqb''
WITH STANDBY = ''C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\UNDO_ic001CommonPrd.DAT'',
MOVE ''ic001Cluster_Data'' TO ''D:\DATA\ic001CommonPrd.MDF'',
MOVE ''ic001Cluster_Log'' TO ''D:\DATA\ic001CommonPrd_log.LDF'',
PASSWORD = ''***********''"'

Returns the following error:
Restoring ic001CommonPrd (database) from: \SQLBackups\FULL_PILS_ic001CommonPrd_20061206_020022.sqb Login failed for user 'jrandall'. Server : SOY SQL authentication User name : jrandall


jrandall is a valid user (with sa rights) on the server where I am trying to restore the DB.
It is also a valid user (with sa rights) on the server where the backup was taken from.

Jeff Randall

I am also getting the same error when I try ot backup a DB from this server.

Login failed for user 'jrandall'. Server : SOY SQL authentication User name : jrandall

petey

If you had changed the password for 'jrandall' recently, the SQL Backup service may be using an outdated password.

You need to update the password in this case e.g.

sp_addextendedproc sqbsetlogin, 'xp_sqlbackup.dll'
GO

sqbsetlogin 'jrandall', '<password>'
GO

sp_dropextendedproc sqbsetlogin
GO