Competition: What’s your favorite Redgate tool? Enter now.

Odd permissions issue with restore

Jeff RandallJeff Randall Posts: 41
edited December 7, 2006 10:03AM in SQL Backup Previous Versions
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.

Comments

  • 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
  • peteypetey Posts: 2,358 New member
    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
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.