I uninstalled and reinstalled; the default, when I opened “Connect to Server” was “Local SQL Server” and “.\SQLEXPRESS” (which are correct); Windows Authentication was checked and “DESKTOP-TH7P8CP\Fred” was the user name (the “Windows authentication”, as you suggested and I didn’t understand – it’s all on a PC in my home and I don’t have it passworded).
This failed on the nightly backup with this error message: “Job execution error: [SRV:8007#13] Authorization failed. … blank passwords aren’t allowed, …”. It ran fine on a manual start with SSMS open.
I wanted to change to Windows Authentication because I wanted to run Ola Hallengren’s checkdb code and was unable to find any SQL Server authentication that would allow it to run before the backup. However, it runs fine from a batch job so I’m going to do it that way. (SQL Server Agent isn’t part of the free Express version.) As I don’t want/need to password my PC I’ll revert to SQL Server authentication. When I install this on my client’s server I’ll use Windows Authentication as it is passworded, of course.
I also want to run some maintenance code after the backup, but there’s no indication in the log file that it ran, while there were entries for the “before” code. I’ll modify the “after” code to make a table change and find out for sure this evening – and do another batch job if it doesn’t.
Thanks for the help; you can marked this closed.
Rolf, thanks for the “space” idea; I’ll file it and expect to use it someday.
P.S. It would be easier to provide the text of error messages if it were possible to copy/paste from your logs.