Cannot restore to local Windows8 - error 15404

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Cannot restore to local Windows8 - error 15404

Postby PDinCA » Sat Sep 28, 2013 2:25 am

SQL error 15404: Could not obtain information about Windows NT group/user 'MyCompany\\me', error code 0x5.

I'm the only User who set up this machine and is successfully logged into the domain and is a local admin on the machine and has every server role (you can see I tried everything I could think of!). Even Adventureworks2102 didn't revolt when I attached it with log rebuild, so at least that part is good, and I can SELECT from its tables...

SQB Service WAS running under "Local Service" but I changed it to my domain login, despite enforced password changes every 90 days, just to poke that stick at it - no change.

I've restored this "Utility" DB across domains MANY times without incident.

I've been through the documentation site and tried to find and change everything, including the script to change to "sa" for the xp_...dll

What next, please?
PDinCA
 
Posts: 512
Joined: Mon Jul 25, 2005 11:42 pm
Location: Costa Mesa, CA, USA

Postby petey » Mon Sep 30, 2013 3:14 am

After you've used the sqbsetlogin extended stored procedure to use a SQL login for the SQL Backup service, could you please check if the setting was saved in the registry, under ServiceLogin in

Code: Select all
HKLM\\Software\\Red Gate\\SQL Backup\\BackupSettingsGlobal\\<instance name>

and if the SQL Backup Agent service startup account has rights to read from that registry node?

Alternatively, since there's only one user using that machine, you could set up SQL Backup to skip checking for backup and restore rights, by creating a SkipChecks DWORD registry value in the node above, and giving it a value of 1.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2227
Joined: Sun Apr 24, 2005 12:34 pm

Postby PDinCA » Mon Sep 30, 2013 4:39 pm

Took the alternative and I'm good to go. Many thanks Peter
PDinCA
 
Posts: 512
Joined: Mon Jul 25, 2005 11:42 pm
Location: Costa Mesa, CA, USA


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 1 guest