Red Gate forums :: View topic - Unable to save information inside GUI's "Server Options"
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

Unable to save information inside GUI's "Server Options"

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



Joined: 14 Feb 2011
Posts: 18

PostPosted: Fri Jun 08, 2012 4:59 pm    Post subject: Unable to save information inside GUI's "Server Options" Reply with quote

I have updated the GUI to SQL Backup 7.0.6.2 and the server components too. I right-click on the server in the GUI and choose Options. The "Server Options" dialog box comes up. I made changes in there (both File Management and Email settings) and clicked on OK. The settings changes do not remain after clicking on Options again - they revert back to blanks. The sql server 2005 is installed in Windows Server 2003 x64 SP2. The user name set up to run the SQL Backup Agent on the server is a domain service account with full-control permissions for files,folders and sub-folders inside C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup. I read the help instructions on a older post by Eddie Davis at http://www.red-gate.com/messageboard/viewtopic.php?t=15060 but it did not resolve my issue.
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2306

PostPosted: Sat Jun 09, 2012 2:20 pm    Post subject: Reply with quote

Those settings are stored in the registry node

HKLM\Software\Red Gate\SQL Backup\BackupSettingsGlobal\<instance name>

on the machine where the SQL Server instance is running on. Try changing the e-mail server name, and see if the value is saved in the above registry node, in the 'SMTPHost' value. If not, please check if the SQL Backup Agent service startup account has rights to read and write to the above registry node.
_________________
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
NeM



Joined: 14 Feb 2011
Posts: 18

PostPosted: Sat Jun 09, 2012 2:58 pm    Post subject: Reply with quote

Thanks for the reply Petey. This is now resolved. It turns out the encrypted password for the SMTP account in the registry at HKLM\Software\Red Gate\SQL Backup\BackupSettingsGlobal\<instance name> in the SMTPPassword node was incorrect. It did not work through the GUI when I tried to correct it there but after stopping the SQL Backup agent service and correcting it at that registry node and restarting the service, it did work and the settings information are correctly retained in the GUI.
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