Agent-based backups for Windows and Linux, centralized agent management
Post Reply
Dvas
Novice
Posts: 3
Liked: never
Joined: Oct 21, 2020 1:44 pm
Full Name: Dmitry Vasiliev
Contact:

SQL login with sql authentication

Post by Dvas »

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 !

Dima P.
Product Manager
Posts: 12530
Liked: 1173 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: SQL login with sql authentication

Post by Dima P. »

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:

Image

Dvas
Novice
Posts: 3
Liked: never
Joined: Oct 21, 2020 1:44 pm
Full Name: Dmitry Vasiliev
Contact:

Re: SQL login with sql authentication

Post by Dvas »

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):

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"
It looks like Veeam trying to login with given account (sa), but treating it as windows account, not MSSQL

Dima P.
Product Manager
Posts: 12530
Liked: 1173 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: SQL login with sql authentication

Post by Dima P. »

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!
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.

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests