If the SQL Backup Agent service connects using SQL Server authentication, and you have changed the SQL Server account password, you need to update the password for the SQL Backup Agent service. In Services, right-click the SQL Server service and select Start.Clear the data value for the ServiceLogin registry entry, but do not delete the entry itself.64-bit systems: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Red Gate\SQL Backup\BackupSettingsGlobal\.32-bit systems: HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\.Open the Registry Editor and locate the ServiceLogin registry entry:.Right-click the SQL Server service and select Stop.Find the SQL Server service for the relevant instance of SQL Server, called "SQL Server ()".From the Windows Control Panel, select Administrative Tools, then Services.You will need to stop the SQL Server service briefly to do this.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |