When attempting to perform a backup via Redgate SQL Backup it fails instantly with the following error, this started to occur after being forced to change the sql logins password as far as I can tell but most likely coincided with changing from Windows to Windows & SQL Authentication on the database –

Continue reading “Redgate SQL Backup – Login failed for user – Error 586/18456”