===== [V9] ISSUE: Microsoft SQL Server not found warning on a Microsoft SQL database backup ===== Article ID: 9525
Reviewed: 01/03/2023

Product Version:
AhsayOBM: 9
OS: Windows ===== Problem Description ===== When performing a MS SQL database backup, the following warning message is displayed in the backup report:

No.	Type	Timestamp	Log
*	...	...	...
*	info	...	Download valid index files from backup job "Current" to "temp_path\backupset_id\index".
*	warn	YYYY/MM/DD hh:mm:ss	Microsoft SQL Server not found!
*	...	...	...

===== Cause ===== This issue can occurs if the Windows account running the backup job is not found in the affected MS SQL server's Security Logins, or if the account does not have the sysadmin and public Server Roles.

You can check by looking at the SQL ERRORLOG file at

${database_folder}\MSSQLog

Check if there may be error 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 suggest that the Windows account running the backup job has not been assigned to the MS SQL server's Security Login. ===== Resolution ===== To resolve the issue, perform the following steps:

Open the SQL Server Management Studio.
Under Object Explorer, select Security:
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 (e.g. Right click, Properties, Server Roles).
- If the account is not there, add the account, then assign the public and sysadmin Server Role to it (e.g. Right click, New Login).