Getting an untrusted domain error when installing SQL Server Express on Windows Server 2019

Question

I am trying to install SQL Server Express 2019 on a Windows Server 2019 for use with web app installed on the same server. I am starting with a blank server with a firewall. I am getting the following error. I tried to go to the link that was provided, but it just takes me to a Black Friday sale on Surface. I have admin rights on the server. I have tried to find questions about this, but all questions deal with connecting to a remote server and not with the issue during an install.

TITLE: Microsoft SQL Server 2019 Setup

---

The following error has occurred:

Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.

Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

For help, click: https://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=0x54FF9508%25400x9A41B222

---

BUTTONS:

&Retry

Cancel

---

Answer 1

Hello Robert,

Welcome to the Q&A Forum; this is a great place to get support, answers, and tips.

Thank you for posting your question; I'll be more than glad to help you out.

When in which step do you receive this error?

Just before you can start or during the setup (in which step? any screenshot?)?

This error message occurs mainly during a connection attempt AFTER the installation if you are trying to connect with a domain account, e.g., via SSMS.

So, please give us some more information.

I hope my answer is helpful to you,

Your

Bjoern Peters

If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!

Answer 2

Hi @Robert Gepfert

Based on the error prompt, you need to ensure trust between domains.

Or you can use SQL Server Authentication.

Here is a same thread you may take a reference to.

Best regards,

Percy Tang

Answer 3

The first two answers seem to miss the question. During SQL Server Express 2019 installation, with mixed mode selected, I receive this error: Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication. No instance is created. I've installed plenty of times on other servers. Here the unique feature is a new server (Win 2019). Microsoft online material does not seem to address this issue.