How can we help you today? How can we help you today?

Odd permissions issue with restore

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: D:\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
0

Comments

2 comments

Sort by
  • 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
    Jeff Randall
    0
  • 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
    petey
    0

Add comment

Please sign in to leave a comment.