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

Researcher 6 Reputation points
2023-09-08T12:23:14.6566667+00:00

1.We are currently working on setting up replication for our web server, where the publisher/distributor server is a web server and the Subscriber is a local server - express edition. During the process of enabling the publisher, we encountered the following error:

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

User's image

We attempted to connect to the snapshot and log reader agents using both Windows authentication and SQL authentication, but unfortunately, neither approach yielded the desired results.

There are no errors when both the publisher/distributor server and the Subscriber are local servers, everything works fine.

 2. If I connect to my web server by specifying the port number, then while enabling the publisher I get “must be enabled as a Publisher before you can create a publication. In the following dialog box, enable this server as a Publisher”, so if I connect to by specifying port number I get “SQL Server replication requires the actual server name to make a connection to the server. Specify the actual server name, ‘MyServer‘. (Replication.Utilities)”

Could someone please provide guidance on how to resolve these issues for my webserver?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,772 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,459 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 33,286 Reputation points
    2023-09-11T08:45:14.5333333+00:00

    Hi @Researcher,

    Plese ensure trust between the two domains.

    If above doesn’t solve the issue, we need to check if it is a kerberos issue.

    SQL Server Troubleshooting: Resolving “The login is from an untrusted domain and cannot be used with Windows authentication”

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments