Red Gate forums :: View topic - Cannot restore to local Windows8 - error 15404
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Cannot restore to local Windows8 - error 15404

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
PDinCA



Joined: 25 Jul 2005
Posts: 509
Location: Costa Mesa, CA, USA

PostPosted: Sat Sep 28, 2013 2:25 am    Post subject: Cannot restore to local Windows8 - error 15404 Reply with quote

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?
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2299

PostPosted: Mon Sep 30, 2013 3:14 am    Post subject: Reply with quote

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:
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
Back to top
View user's profile Send private message Send e-mail
PDinCA



Joined: 25 Jul 2005
Posts: 509
Location: Costa Mesa, CA, USA

PostPosted: Mon Sep 30, 2013 4:39 pm    Post subject: Reply with quote

Took the alternative and I'm good to go. Many thanks Peter
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group