SQL Server交叉复制登录失败 [英] SQL server cross replication login failed

问题描述

Hello All，

Hello All,

我们有DEV和UAT域名。我正在尝试创建从UAT到DEV的复制，反之亦然。由于我们有两个不同的域名，我们无法使用域名帐户。所以，我创建了SQL帐户来添加订阅者。但是，不知怎的，我仍然需要登录失败，因为
用户错误18456.我已经检查过SQL身份验证已设置为允许SQL和Windows帐户。任何人都可以请帮助，因为这是紧急问题，需要尽快解决。感谢您的帮助。 

We have DEV and UAT domain. I am trying to create replication from UAT to DEV and vice versa. As we have two different domain we can't use domain account. So, i have created SQL account to add subscriber. But, somehow i am still reeving login failed for user Error 18456. I have checked SQL authentication has been set to allow SQL and Windows account. Can anyone please help as this is urgent issue and need to resolve asap. Thanks for your help in advance. 

推荐答案

确保两台SQL Server都支持混合身份验证，并确保两者的密码相同服务器。如果您最近更改为混合身份验证，则需要重新启动SQL Server。

Ensure that both SQL Servers support mixed authentication and that the password is the same on both servers. If you recently changed to mixed authentication you will need to restart your SQL Server.

还可以从命令行运行distrib命令以准确检测其失败的位置 - 是否无法连接到出版商，订户或分销商？

Also run the distrib command from the command line to detect exactly where it is failing - is it failing connecting to the publisher, subscriber or distributor?

这篇关于SQL Server交叉复制登录失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！