"Microsoft SQL Server not found" warning on a Microsoft SQL database backup

Please use the following steps on Microsoft SQL Server not found warning on a Microsoft SQL database backup.

Symptom:

When performing a Microsoft SQL database backup, the following warning message is displayed in the backup report:

Microsoft SQL Server not found!

Cause:

This issue can occur if the Windows account running the backup job is not found in the affected Microsoft SQL server's Security Logins, of if the account does not have the " sysadmin" and " public" Server Roles.

You can check by looking at the 'SQL ERRORLOG' file at:
C:\Program Files\Microsoft SQL Server\%database_folder%\MSSQL\Log

Check if there may be errors such as the following: (e.g. the log entries around the time of the warning displayed in backup report)

YYYY-MM-DD hh:mm:ss.xx Logon Error: 18456, Severity: 14, State: 5.
YYYY-MM-DD hh:mm:ss.xx Logon Login failed for user 'COMPUTER_NAME\WINDOWS_ACCOUNT'. Reason: Could not find a login matching the name provided. [CLIENT: ip_address]
YYYY-MM-DD hh:mm:ss.xx Logon Error, 18456, Severity: 14, State 5.
YYYY-MM-DD hh:mm:ss.xx Logon Login failed for user 'COMPUTER_NAME\WINDOWS_ACCOUNT'. Reason: Could not find a login matching the name provided. [CLIENT: ]

The above message suggests that the Windows account running the backup job has not been assisgned to the Microsoft SQL server's Security Login.

Resolution:

To resolve the issue, perform the following steps:

1. Open the SQL Server Management Studio.
2. Under ' Object Explorer', select Security.
3. Select Logins, check if the Windows user that you are running the backup job with is there under Logins.
   • If the account is there, confirm if the " public" and " sysadmin" Server Roles have been assigned to the account.
     Right-click > Properties > Server Roles
   
   
   • If the account is not there, add the account, then assign the " public" and " sysadmin" Server Role to it.
     Right-click > New Login