KB2001: Microsoft SQL Server not found warning on a Microsoft SQL database backup
Article ID
All Products
Last reviewed date
Symptoms
When performing a MS SQL database backup, the following warning message is displayed in the backup report:
| Type | Timestamp | Log |
| Warn | 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 suggests 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:
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 (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).
Keywords