Comprehensive data protection for all workloads
Post Reply
CoLa
Influencer
Posts: 10
Liked: 4 times
Joined: Dec 11, 2024 8:09 am
Full Name: F. L.
Contact:

Microsoft Entra ID Tenant Restore

Post by CoLa »

Hello,

we have set up the new Entra Backup in 12.3 and it works so far (at least according to the job log).
However, if I now try to start a restore here, I only get an error message.

Code: Select all

An error occurred accessing the database. This usually means that the connection to the database failed.
Check that the connection string is correct and that the appropriate DbContext constructor is being used to specify it or find it in the application's config file.
See http://go.microsoft.com/fwlink/?LinkId=386386 for information on DbContext and connections.
See the inner exception for details of the failure.
Image

Does anyone else have this error? B&R runs on MSSQL (2022), PostgreSQL is 15.10.2 (just for ENTRA ID Backup and Veeam365)

Case ID is #07526582

Regards
Mildur
Product Manager
Posts: 10306
Liked: 2752 times
Joined: May 13, 2017 4:51 pm
Full Name: Fabian K.
Location: Switzerland
Contact:

Re: Microsoft Entra ID Tenant Restore

Post by Mildur »

Hello CoLa,

Welcome to the forum.

I've updated your comment to replace the contract ID with your correct case number: 07526582.

I found one similar case. I will share it with your support engineer.
But for now, please continue the troubleshooting process with our customer support team. I also see that you're in the process of scheduling a remote session.

Best,
Fabian
Product Management Analyst @ Veeam Software
veremin
Product Manager
Posts: 20677
Liked: 2382 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Microsoft Entra ID Tenant Restore

Post by veremin »

Am I correct in understanding that you initially encountered a different error described here.

After properly configuring the Entra ID backup repository, that error disappeared, and a different one appeared, as shown in the screenshot?

The second issue is unknown to us, so we kindly ask you to collect debug logs and add them to the existing case, as they are currently not present there.

Thank you.
CoLa
Influencer
Posts: 10
Liked: 4 times
Joined: Dec 11, 2024 8:09 am
Full Name: F. L.
Contact:

Re: Microsoft Entra ID Tenant Restore

Post by CoLa »

Yes, at first the error was as described in https://www.veeam.com/kb4653 (that a PostgreSQL connection must be created for Entra ID backup). It was created, backup set up and backup has run (every day so far without error).

If I now want to perform a restore, the new error appears. It's actually quite simple.

PS: I have uploaded the VEEAM logs of the last two days.
veremin
Product Manager
Posts: 20677
Liked: 2382 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Microsoft Entra ID Tenant Restore

Post by veremin »

Understood.

As I mentioned above, we'll need new debug logs to understand the root cause of this issue.

My assumption is that the Entra ID backup repository was incorrectly configured through the DB connection utility; perhaps the password for the user wasn't set or something else— the logs will be able to give us a more precise indication.

Thanks.
CoLa
Influencer
Posts: 10
Liked: 4 times
Joined: Dec 11, 2024 8:09 am
Full Name: F. L.
Contact:

Re: Microsoft Entra ID Tenant Restore

Post by CoLa »

In general, I see the Entra ID backup DB in the PostgreSQL Admin and the backup itself runs without errors (it shouldn't with a wrong password or setting, right?).
veremin
Product Manager
Posts: 20677
Liked: 2382 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Microsoft Entra ID Tenant Restore

Post by veremin »

It's more of an assumption than a concrete statement—the debug logs will reveal the true cause, so we are patiently awaiting those.

Thanks!
Michael Albrecht
Lurker
Posts: 1
Liked: never
Joined: Jan 25, 2016 9:18 am
Full Name: Michael Albrecht
Contact:

Re: Microsoft Entra ID Tenant Restore

Post by Michael Albrecht »

Any News about this Problem ?
david.domask
Veeam Software
Posts: 2607
Liked: 610 times
Joined: Jun 28, 2016 12:12 pm
Contact:

Re: Microsoft Entra ID Tenant Restore

Post by david.domask »

Hi Michael, welcome to the forums.

The topic creator's case was resolved after setting a new role in postgres with superuser permissions, and looks to have resolved the issue.
David Domask | Product Management: Principal Analyst
CoLa
Influencer
Posts: 10
Liked: 4 times
Joined: Dec 11, 2024 8:09 am
Full Name: F. L.
Contact:

Re: Microsoft Entra ID Tenant Restore

Post by CoLa » 1 person likes this post

Yes, we simply created and stored a new PostgreSQL user just for this purpose, then it worked. Thought someone from Veeam would make a note of this.
milonet
Influencer
Posts: 10
Liked: never
Joined: May 22, 2018 12:50 pm
Full Name: Marco Milone
Contact:

Re: Microsoft Entra ID Tenant Restore

Post by milonet »

Hi, i have a same issue. I can perform backup but not restore.
I configured "postgres" account in connection wizard entra id section. The "postgres" account is fulladmin with superuser role
It seems that i'm using a windows account instead "postgres" account
CoLa
Influencer
Posts: 10
Liked: 4 times
Joined: Dec 11, 2024 8:09 am
Full Name: F. L.
Contact:

Re: Microsoft Entra ID Tenant Restore

Post by CoLa » 1 person likes this post

Create a NEW user with a password and these roles and use this user
Post Reply

Who is online

Users browsing this forum: Baidu [Spider], Bing [Bot] and 124 guests