读书人

配置Replication,该如何解决

发布时间: 2012-06-05 13:54:06 作者: rapoo

配置Replication
我需要做同步
配置使用Replication。考上的一些相料行,到最後一步出下面提示,不明白具是哪有,各位朋友看看

Messages
SQL Server could not configure 'HSUAT01' as a Distributor. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

An error occurred during decryption.
There is no remote user 'distributor_admin' mapped to local user '(null)' from the remote server 'repl_distributor'.
Changed database context to 'master'. (Microsoft SQL Server, Error: 15466)

[解决办法]
SQL Server Management Studio-->实例-->Replication-->右键
-->Configure distribution-->然后都是全界面操作的了.. (基本上全选[下一步]即可)

两边都做完这一步配置之后,再开始建发布订阅.
[解决办法]
检查Windows验证及SQL验证是否都启用了.

先disable distribution再重新Configure distribution试试..
[解决办法]
查看sql service的启动帐号是什么?

改为local system试试..

读书人网 >SQL Server

热点推荐