Registry permission issue with SQLbackup 7.4.0.186/SQL2012

Compresses, encrypts, secures and monitors SQL Server backups.

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

Registry permission issue with SQLbackup 7.4.0.186/SQL2012

Postby Tom_NL » Mon Sep 23, 2013 11:25 pm

The last 2 weeks we implemented 12 new SQL 2012 servers and installed the latest version of SQLbackup (7.4.0.168)

After (succesfull) installation SQLbackup refused to work and evey time we configured the Server options these values disappeared after restarting the GUI.

Finaly after a lot of debugging we found this issue was caused by the user running sqlbackup having no rights on the redgate registry hyves

HKEY_LOCAL_MACHINE\\SOFTWARE\\Red Gate\\SQL Backup\\BackupSettings\\(LOCAL)
HKEY_LOCAL_MACHINE\\SOFTWARE\\Red Gate\\SQL Backup\\BackupSettingsGlobal\\(LOCAL)
HKEY_LOCAL_MACHINE\\SOFTWARE\\Red Gate\\SQL
Backup\\InstalledInstances\\(LOCAL)

After manualy granting the nessesairy permissions everything now works OK, but this is probably a bug in the setup, probably popping up because we don't assign sqlserver local admin rights

Rgards,
Tom
Tom_NL
 
Posts: 10
Joined: Sun May 02, 2010 8:25 am

Postby petey » Tue Sep 24, 2013 5:31 am

Could you please let me know the Windows operating system version you installed SQL Backup on?

Thanks.
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 Tom_NL » Tue Sep 24, 2013 8:07 am

The OS is Windows Server 2012 Standard edition.
SQL server is SQL Server 2012, als standard edition.

Regards,
Tom
Tom_NL
 
Posts: 10
Joined: Sun May 02, 2010 8:25 am

Postby petey » Sat Sep 28, 2013 4:29 am

Thanks for the details. We have reproduced the error, and it will be fixed in a future release.
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


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests