Hi everyone
I'm using Veeam B&R to backup physical server, running MSSQL. Backup itself goes fine, but with warning "Unable to truncate SQL server transaction logs".
MSSQL server using sql authentication, not windows. I've added "sa" user to Veeam credentials section, but still got same warning. Windows logs from server says "unable to log in", but it looks like Veeam trying to login with _windows_ account named "sa". How should I tell Veeam to use sql authentication for sql login ?
Thanks in advance !
-
- Novice
- Posts: 3
- Liked: never
- Joined: Oct 21, 2020 1:44 pm
- Full Name: Dmitry Vasiliev
- Contact:
-
- Product Manager
- Posts: 14417
- Liked: 1576 times
- Joined: Feb 04, 2013 2:07 pm
- Full Name: Dmitry Popov
- Location: Prague
- Contact:
Re: SQL login with sql authentication
Hello Dmitry,
Can you please check the SQL processing tab in the Guest Processing settings of your agent backup job? SQL account should be listed there instead of guest credentials:
Can you please check the SQL processing tab in the Guest Processing settings of your agent backup job? SQL account should be listed there instead of guest credentials:
-
- Novice
- Posts: 3
- Liked: never
- Joined: Oct 21, 2020 1:44 pm
- Full Name: Dmitry Vasiliev
- Contact:
Re: SQL login with sql authentication
Thanks for your answer
Yes, I've checked once again, and account set correctly
But on a server I've got following error (original on russian, translated by Google translate):
It looks like Veeam trying to login with given account (sa), but treating it as windows account, not MSSQL
Yes, I've checked once again, and account set correctly
But on a server I've got following error (original on russian, translated by Google translate):
Code: Select all
"The account could not be logged in.
Subject:
Security ID: SYSTEM
Account Name: PHILHARM-BUHG $
Account Domain: PHILHARMONIC
Login code: 0x3E7
Input type: 4
Account that failed to sign in:
SID: NULL SID
Account name: sa
Account domain: PHILHARM-BUHG
Error details:
Reason for error: Unknown username or incorrect password.
Status: 0xC000006D
Substate: 0xC0000064
Process details:
Caller Process ID: 0xfc0
Caller Process Name: C: \ Program Files \ Veeam \ Endpoint Backup \ Veeam.EndPoint.Manager.exe
Network details:
Workstation name: PHILHARM-BUHG
Source Network Address: -
Source port: -
Authentication Details:
Login process: Advapi
Authentication Package: Negotiate
Intermediate Services: -
Package name (NTLM only): -
Key length: 0"
-
- Product Manager
- Posts: 14417
- Liked: 1576 times
- Joined: Feb 04, 2013 2:07 pm
- Full Name: Dmitry Popov
- Location: Prague
- Contact:
Re: SQL login with sql authentication
Hello Dmitry,
I am sorry, I must have missed that the account you are using is a sql only account. For the sql processing is not possible to use the local sql accounts, the account must be registered in AD. Hope that helps!
I am sorry, I must have missed that the account you are using is a sql only account. For the sql processing is not possible to use the local sql accounts, the account must be registered in AD. Hope that helps!
Help Center wrote:To specify a user account that Veeam Agent for Microsoft Windows will use to connect to the Microsoft SQL Server, select from the Specify Microsoft SQL Server account with database admin privileges list a user account that has access permissions on the database. To connect to the Microsoft SQL Server, you must use a Microsoft Windows user account that has sysadmin privileges on the Microsoft SQL Server. You cannot use Microsoft SQL Server accounts (for example, the SA account) to connect to the database.
Who is online
Users browsing this forum: Baidu [Spider] and 8 guests