How do you make a SQL Server Authentication password change take effect in SQL Backup Agent service

• 
  Good Afternoon!

  You should be able to change the SQL Server Authentication login account information from the SQL Backup GUI.

  You can read how to do so from the following documentation:

  https://documentation.red-gate.com/sbu/getting-started/installing/adding-sql-server-instances#AddingSQLServerinstances-EditingaSQLServerinstanceregistration

  
  

  Let me know if you have any other questions.
  

  
  
  

  squigley March 19, 2020 21:27

  - 0 +
• 
  Yes,  I was able to change password in the Server/Instance registration via the GUI but that password does not propagate to the backup service running on the server.  https://documentation.red-gate.com/sbu/permissions#Permissions-ChangingtheSQLBackupAgentservicecredentials
  
  From the documentation:
  If you are using SQL Server authentication and you change the account password, you must also apply the change to the SQL Backup Agent service, otherwise backups and restores may fail. This can be done using the sqbsetlogin stored procedure as above, but specifying the new account credentials on step 2.
  
  I did the above and restarted the service but the service still did not use the new password.  So far, I've had to reinstall the backup service on 2 servers because the services would not recognize the password change.

  jlray March 19, 2020 23:00

  - 0 +
• 
  Yes,  I was able to change password in the Server/Instance registration via the GUI but that password does not propagate to the backup service running on the server.  https://documentation.red-gate.com/sbu/permissions#Permissions-ChangingtheSQLBackupAgentservicecredentials
  
  From the documentation:
  If you are using SQL Server authentication and you change the account password, you must also apply the change to the SQL Backup Agent service, otherwise backups and restores may fail. This can be done using the sqbsetlogin stored procedure as above, but specifying the new account credentials on step 2.
  
  I did the above and restarted the service but the service still did not use the new password.  So far, I've had to reinstall the backup service on 2 servers because the services would not recognize the password change.

  jlray March 20, 2020 09:06

  - 0 +
• 
  Yes,  I was able to change password in the Server/Instance registration via the GUI but that password does not propagate to the backup service running on the server.  https://documentation.red-gate.com/sbu/permissions#Permissions-ChangingtheSQLBackupAgentservicecredentials
  
  From the documentation:
  If you are using SQL Server authentication and you change the account password, you must also apply the change to the SQL Backup Agent service, otherwise backups and restores may fail. This can be done using the sqbsetlogin stored procedure as above, but specifying the new account credentials on step 2.
  
  I did the above and restarted the service but the service still did not use the new password.  So far, I've had to reinstall the backup service on 2 servers because the services would not recognize the password change.

  jlray March 20, 2020 09:06

  - 0 +
• 
  Try either of these:
  
  EXEC master..sqbsetlogin 0, '<user name>', '<password>'
  
  or 
  
  EXEC master..sqbutility 9999, '<user name>', '<password>'
  
  Will get the documentation corrected for the sqbsetlogin command.

  petey2 March 23, 2020 04:24

  - 0 +

Add comment

Please sign in to leave a comment.